In which scenario will you use the Flashback Transaction Query feature？（）
A: when you want to restore an important table that is dropped from the Recycle Bin
B: when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
C: when you want to restore a dropped user’s schema
D: when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
A: when you want to restore an important table that is dropped from the Recycle Bin
B: when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
C: when you want to restore a dropped user’s schema
D: when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
举一反三
- In which scenario will you use the Flashback Transaction Query feature？（） A: A when you want to restore an important table that is dropped from the Recycle Bin B: B when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction C: Cwhen you want to restore a dropped user’s schema D: D when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
- In which scenario will you perform an incomplete recovery？（） A: when a table is dropped and stored in the Recycle Bin B: when all the control files are deleted C: when a member of a multiplexed redo log group is dropped D: when you are required to recover a table to its previous state
- You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table. Which CREATE statement should you use？（） A: A B: B C: C D: D
- In which scenario will you perform an incomplete recovery？（） A: A when a table is dropped and stored in the Recycle Bin B: B when all the control files are deleted C: C when a member of a multiplexed redo log group is dropped D: D when you are required to recover a table to its previous state
- It is important to assess your goals from time to time, ________ where you are and where you want to be, and plan accordingly. (value, evaluate)