最新Oracle_11G_OCP_1Z0-053题库免费下载

最新 Oracle OCP 11G 题库并且前无古人花了三个月心血把053的671道题逐个地翻译了一遍，有翻译，有答案的出处，有注释,只对谁想考OCP 11G的，非常有帮助，另外两个是我同事编写的关键字记忆法，有200题的和671题的。张贴一部分给大家学习一下，如有喜欢的可以转载下载，绝对非常有用。
下载地址为：http://down.51cto.com/data/339411
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％以上的系统辅助表空间时，它会在警报日志文件中产生一个每周预警。
Answer: D

QUESTION NO: 4
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM
compatibility  attribute  set  to  11.1.0  and  redundancy  set  to  high.  One  of  the  disks  in  the  disk  group
becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose
all that apply.) 你正在管理一个Oracle11g数据库的ASM实例，该实例的ASM兼容属性设置为11.1.0且冗余
设置为高的磁盘组中有三个磁盘。因为停电其中一个磁盘组中的磁盘变得不可用。在这种情况下哪些描述
是真实的？
A. The disk is immediately dropped from the disk group.
B. The ASM tracks the extents that are modified during the outa  自动储存管理跟踪在OUTA期间被修改的
区
C. The ASM migrates the extents from the unavailable disk to the remaining disks.
D. The disk automatically goes offline. 磁盘会自动脱机。
Answer: B,D

QUESTION NO: 5
Which statements are true regarding table compression? (Choose all that apply.)
关于表压缩哪些说法是正确的？
A. It saves disk space and reduces memory usage. 它可以节省磁盘空间，并降
低内存使用率。
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
它在数据操作语言以及直接装载操作期间产生额外的CPU开销。
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.
Answer: A,C