Choose two. Which two are prerequisites for using FLASHBACK TABLE?

• A.The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
• B.The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
• C.Row Movement must be enabled on the table being flashed back.
• D.A table's constraints must be disabled before issuing the flashback.
• E.A table's indexes must be set to unusable before issuing the flashback.

Comment: *

Name: *

Email: *

Verification: *

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

• A.by using the RMAN switch command to set the new location for the data files
• B.by creating a new database in the new host, and then using the RMAN recover command
• C.by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host
• D.by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

Comment: *

Name: *

Email: *

Verification: *

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

• A.to allow database duplication without a connection to the target instance.
• B.to store backups that would cause the controlfile to become too large.
• C.to report on the database schema at an earlier point in time.
• D.to store backup metadata that would cause the controlfile to become too large.
• E.to allow database duplication without a connection to the auxiliary instance.

Comment: *

Name: *

Email: *

Verification: *