Question 41 :
What are the states of a rollback segment ? What is the difference between partly available and needs recovery ?
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 ?
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 ?
Question 44 :
an you define multiple savepoints ?
Question 45 :
Can you Rollback to any savepoint ?