32.The default constraint name begins with SYS_

1. true
   
2. false
   

ans:A

33.The not null constraint can be defined in table level?

1. true
   
2. false
   

ans :B

34.which constraint will not allow null value?

1. check
   
2. unique
   
3. primary
   
4. not null
   

ans:C,D

35.which is not supported in select clause in a view definition?

1. having
   
2. cube
   
3. group by
   
4. order  by
   
5. none of the above
   

ans:E  (for update not supported)


36.Rownum is not stored in the database

1. true
   
2. false
   

ans :A(it is assigned as each record is fetched)

37.what are the special chars allowed in table name?

1. %
   
2. #
   
3. $
   
4. @
   
5. &
   

ans:B,C

38.A view can be create before the creation of its base table

1. true
   
2. false
   

ans:A (with force option in create view statement)

39.what is the default value for maxvalue in decreasing sequence?

1. -1
   
2. 0
   
3. 1
   
4. nomaxvalue
   

ans:A

40.Before referencing currval nextval should be referenced

1. true
   
2. false
   

ans:A