Oracle OCP 1Z0-050(1-10题)解析
QUESTION 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.
正确答案:B、C
【解析】
Data Recovery Advisor(以下简称DRA)是Oracle的一个内置(Build-In)工具,用于进行数据错误、损坏的报告和修复建议。比如,DRA能够自动发现当前存在坏块,并且查看备份资料库(RMAN),给出修复建议和语句。DRA甚至可以做到“一键式”的恢复,敲一个修复命令,就自动执行修复脚本,将错误解除。
DRA目前可以在两种方式下进行工作,一个是数据库启动障碍,比如启动过程报错。另一个是运行过程障碍,例如运行中数据库异常损坏(如数据文件被后台删除)。故正确答案为B、C。
注意,在11g版本中,Data Recovery Advisor不支持RAC环境。
QUESTION 2:
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA
where DB01 is the net service name.
Which authentication method would be used first?
A. authentication by using the local OS of the database server
B. authentication by using the Oracle Internet Directory
C. authentication by password file
D. authentication by using certificates over SSL
正确答案:C
【解析】
从$ SQLPLUS scott/tiger@DB01 AS SYSDBA,是使用密码验证的,明显看到scott账户的密码就是tiger
LDAP_DIRECTORY_SYSAUTH enables or disables directory-based authorization for SYSDBA and SYSOPER.
QUESTION 3:
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
正确答案:B
【解析】
在Oracle Database 11g之前,Oracle的各类跟踪文件、alert日志文件等诊断文件的存储位置并不统一,而从Oracle 11g开始统一规划这些文件的存储。推出了Automatic Diagnostic Repository(ADR)。它是基于文件的资料库,用来存储数据库诊断信息,如traces、dumps、alert log和健康监控报告。数据库、自动存储管理(ASM)、集群就绪服务(CRS) 和其它Oracle 产品或组件将所有诊断数据都存储在ADR 中,不同的产品和组件都具有相同的目录结构。
数据库初始化参数DIAGNOSTIC_DEST决定了ADR base的存储位置,默认情况下,如果设置了ORACLE_BASE,那么DIAGNOSTIC_DEST 等于 ORACLE_BASE,否则等于ORACLE_HOME/log。指定了参数DIAGNOSTIC_DEST,由原来的参数CORE_DUMP_DEST、BACKGROUND_DUMP_DEST和USER_DUMP_DEST设置的位置将被忽略。
QUESTION 4:
Observe the following PL/SQL block:
BEGIN
dbms_