Which three statements are true about Flashback Data Archive?

Which three statements are true about Flashback Data Archive? A. Flashback Data Archive prevents flashback queries from getting a snapshot too-old error. B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first. C. To enable Flashback Data Archive for a table, it is mandatory to […]

Read More

Which statement is true about the DUPLICATE command?

Examine the RMAN commands:RMAN> CONNECT TARGET “sbu@prod AS SYSBACKUP”;RMAN>CONNECT AUXILIARY “sbu@dup_db AS SYSBACKUP”;RMAN >DUPLICATE TARGET DATABASE TO dup_dbFROM ACTIVE DATABASEPASSWORD FILESECTION SIZE 400M;Which statement is true about the DUPLICATE command? A. It fails because there is no connection to a recovery catalogue. B. It fails because no parallel channels are allocated for the auxiliary database. […]

Read More

What are three prerequisites for this command to succeed?

In your database, the user SCOTT wants to retrieve the dropped HR. EMPLOYEES table by using the command:SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;What are three prerequisites for this command to succeed? A. Undo retention guarantee must be enabled. B. No other table with the same name should exist in the HR schema. C. SCOTT […]

Read More

Which two are prerequisites for performing Flashback Transaction?

Which two are prerequisites for performing Flashback Transaction? A. A supplemental log must be enabled for the primary key. B. Undo retention guarantee must be configured for the database. C. Fast Recovery Area must be enabled for the database. D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package. E. Row […]

Read More

Which statement is true?

You use RMAN to take regular backups for your database.Examine the RMAN commands:RMAN> CROSSCHECK BACKUP;RMAN>DELETE EXPITED BACKUP;Which statement is true? A. All backups and archived redo log files that are not required for the recovery are deleted and the repository is updated. B. All metadata, for backups and archived redo log files that are recorded […]

Read More

Which action should you perform?

You are performing regular backups of your production database by using a recovery catalog.You add two new tablespaces to your production database after performing a backup. They must be included infuture backups.Which action should you perform? A. Synchronize the recovery catalog with the target database control file. B. Create a new database incarnation record. C. […]

Read More

What happens at the next log switch?

Your database is running in archivelog mode. Examine the parameters for your database instance:LOG_ARCHIVE_DEST_l =’LOCATION=/disk1/arch MANDATORY’LOG_ARCHIVE_DEST_2 =’LOCATION=/disk2/arch’LOG_ARCHIVE_DEST_3 =’LOCATIO=/disk3/arch’LOG_ARCHIVE_DEST _4 =’LOCATIONs/disk4/arch’LOG_ARCHIVE _MIN_SUCCEED_DEST = 2While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is notavailable. All redo log groups have been used.What happens at the next log switch? A. The database […]

Read More