必威体育精装版 Oracle OCP 11G 题库中文版PDF.pdf

日期版本 内容 文档完善者 邮箱 2013/09/22V2.1 美河学习在线 toogso@G 我QUESTION NO: 1 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) 确定哪两种情况下，你可以使用用于恢复的数据恢复顾问。 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. Answer: B,C QUESTION NO: 2 Examine the following values of the initialization parameters in the database having the SID ORCL: 检查以下在数据库中具有ORCL SID的初始化参数的值： 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? 自动诊断信息库（ADR ）之家 在什么位置？ A. /u01/app/oracle/product/11.1.0/db_1 B. /u01/app/oracle C. $ORACLE_HOME/bdump D. $ORACLE_HOME/log Answer: B QUESTION NO: 3 Observe the following PL/SQL block: BEGIN dbms_spm.configure(SPACE_BUDGET_PERCENT, 30); END; Which statement is correct regarding the above PL/SQL block? 有关上述PL / SQL块哪种说法是正确的？ A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace. B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB). C. It reserves 30% of the space in the SYSTEM tablespace for SMB. D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace. 当SQL管理库占了30 ％以上的系统辅助表空间时，它