053(七十九）

391、

391.When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)
A. Tablespace name
B. Storage quota
C. Retention
D. Table name
E. Create a default archive

392、

392.To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?
A. TRUNCATE the archive table.
B. DROP the Flashback Data Archive.
C. Nothing; expired rows are automatically removed.
D. Nothing; expired rows are moved to an archive table.
E. Delete entries from the archive where the metadata date retained is greater than the retention period.

393、

393.Which of the following initialization parameters have been deprecated in Oracle 11g 
because of the introduction of the Automatic Workload Repository? (Choose all that apply.)
A. BACKGROUND_DUMP_DEST
B. FOREGROUND_DUMP_DEST
C. CORE_DUMP_DEST
D. USER_DUMP_DEST
E. DIAGNOSTIC_DEST
F. All of the above

394、

394.Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?
The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't set,
A. then the default is set to $ORACLE_BASE. The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn't set,
B. then it is set to $ORACLE_HOME. 
C. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME. 
D. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE. 

395、

395.Which of these formats represents the correct hierarchy for the ADR?
A. <diagnostic_dest>/rdbms/diag/<dbname>/<instname>
B. <diagnostic_dest>/diag/rdbms/<instname>/<dbname>
C. <diagnostic_dest>/diag/rdbms/<dbname>/<instname> 
D. None of the above