Set - 10

Question 41 :

What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?

Answer :

The various states of a rollback segment are :
ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.


Question 42 :

What is the difference between unique key and primary key ?

Answer :

Unique key can be null; Primary key cannot be null.


Question 43 :

An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?

Answer :

No.


Question 44 :

an you define multiple savepoints ?

Answer :

Yes.


Question 45 :

Can you Rollback to any savepoint ?

Answer :

Yes.