单项选择题

Examine the following values of the initialization parameters in the database having the SID ORCL：
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=
The environment variables have the following value：
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository （ADR） home？（）

A. /u01/app/oracle/product/11.1.0/db_1
B. /u01/app/oracle
C. $ORACLE_HOME/bdump
D. $ORACLE_HOME/log

点击查看答案

上一题目录下一题

相关考题

多项选择题

Identify two situations in which you can use Data Recovery Advisor for recovery.（）

A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.

多项选择题

Examine the following command that is used to duplicate a database on the same host：
RMAN> RUN {
ALLOCATE AUXILIARY CHANNEL， aux 1 DEVICE TYPE DISK； DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY； \ }
Which two statements describe the effect after the database is duplicated successfully？（）

A. The data files of the read-only tablespaces in the target database are not duplicated
B. The read-only tablespaces in the target database are still defined in new the database
C. The read-only tablespaces in the target database are changed to online after duplication
D. The data files of the read-only tablespaces in the target database get duplicated
E. The read-only tablespaces in the target database are not defined in the new database

多项选择题

You plan to execute the following command to perform a Flashback Database operation in your database：
SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；
Which two statements are true about this？（）

A. The database must have multiplexed redo log files
B. The database must be in the MOUNT state to execute the command
C. The database must be in the NOMOUNT state to execute the command
D. The database must be opened in RESTRICTED mode before this operation
E. The database must be opened with the RESETLOGS option after the flashback operation