Questions

Answer the following questions to test your knowledge of this chapter:

1. Which transaction property ensures access just to confirmed data changes (assuming the transaction has already reached COMMIT)?
   1. Atomicity
   2. Consistency
   3. Isolation
   4. Durability
2. Which attribute signifies the transaction time reflection for the Flashback data reconstruction?
   1. UNDO
   2. REDO
   3. SCN
   4. LGWR
3. Which state of the database must be applied to perform FLASHBACK DATABASE?
   1. NOMOUNT
   2. MOUNT
   3. OPEN
   4. RESETLOGS
4. Which statement gets you the table Tab content as it existed at the SCN 37787875368953?
   1. select * from Tab AS OF SCN 37787875368953;
   2. select * from Tab AS OF TIMESTAMP 37787875368953;
   3. select * from Tab FLASHBACK to 37787875368953;
   4. select * from Tab where SCN=37787875368953;