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
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
举一反三
- 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
- 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
- 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 three situations is incomplete recovery required?() A: After a shutdown abort. B: When recovering to an SC C: D: When recovering until a specific time. E: When a required archived log is missing.
- Which describes the default behavior when you create a table? () A. The table is accessible to all users. B. Tables are created in the public schema. C. Tables are created in your schema. D. Tables are created in the DBA schema. E. You must specify the schema when the table is created.