when a table is dropped and you restore it from the Recycle Bin
when a user’s schema is dropped and you recover the user’s schema
when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duration
第1题:
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record, the SQL statement that will undo the deletion, and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks?()
第2题:
You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()
第3题:
A. The database must have multiplexed redo logs for the flashback to succeed.
B. The database must be MOUNTED for the flashback to succeed.
C. The database must use block change tracking for the flashback to succeed.
D. The database must be opened in restricted mode for the flashback to succeed.
E. The database must be opened with the RESETLOGS option after the flashback is complete.
F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
第4题:
Which two statements are correct regarding the Flashback Versions Query feature?()
第5题:
In which scenario do you use the Flashback Database feature?()
第6题:
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature?()
第7题:
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()
第8题:
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
第9题:
In which scenario will you use the Flashback Transaction Query feature?()
第10题:
In which case would you use the Flashback Database feature to perform a recovery?()