Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

• A. configuring control file autobackup to be ON
• B. setting the retention policy to a REDUNDANCY value greater than 1
• C. backing up data filed only and not the archived redo log files
• D. backing up the recovery catalog to the same disk as that of the target database
• E. running the recovery catalog database in NOARCHIVELOG mode.

In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators.
In addition, reports are generated using complex joins with non-equality operators.
What table organization is the best for this workload?

• A. hash clustered table
• B. external table
• C. heap table
• D. sorted hash clustered table
• E. global temporary table
• F. object table

Note the following statements that use flashback technology:
1.FLASHBACK TABLE <table> TO SCN <scn>;
2.SELECT * FROM <table> AS OF SCN 123456;
3.FLASHBACK TABLE <table> TO BEFORE DROP;
4.FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5.SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

• A. 1, 2, and 5
• B. 1, 3, and 4
• C. 1, 2, 3, 4, and 5
• D. 2, 3, 4, and 5

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

• A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
• B. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space
• C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
• D. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');
SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

• A. The statistics are treated as the current statistics by the optimizer for the current sessions only.
• B. The statistics are treated as the current statistics by the optimizer for all sessions.
• C. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
• D. The statistics are stored in the pending statistics table in the data dictionary.