Set - 10

Question 36 :

What are the disadvantages of clusters ?

Answer :

The time for Insert increases.


Question 37 :

Can Long/Long RAW be clustered ?

Answer :

No.


Question 38 :

Can null keys be entered in cluster index, normal index ?

Answer :

Yes.


Question 39 :

Can Check constraint be used for self referential integrity ? How ?

Answer :

Yes. In the CHECK condition for a column of a table, we can reference some other column of the same table and thus enforce self referential integrity.


Question 40 :

What are the min. extents allocated to a rollback extent ?

Answer :

Two