ITPub博客

首页 > 数据库 > Oracle > OCP 053 107-112

OCP 053 107-112

原创 Oracle 作者:GM_DBA 时间:2014-02-11 15:57:36 0 删除 编辑

QUESTION 107

Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.?Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.)

A. redo logs

B. control file

C. temporary files of temporary tablespace

D. the latest backup of only the damaged data file

E. the latest backup of all the data files In the USERS tablespace

Answer: ABD

Explanation

【题目示意】

此题考查有关于表空间备份恢复的知识。

开启归档模式的数据库中一个名为USBRDATAOL.dbf的表空间损坏,需要恢复数据库到故障检查点。备份的数据文件是可用的。选择三个DBA在用户管理恢复进程中需要使用的文件。

【解析】

   恢复数据库需要重做日志文件、控制文件和损坏的数据的备份文件。Redo logs是介质恢复要用到的,the latest backup of only the damaged data file是来转储用的,至于控制文件可能会记录一些信息。因为题目要求选择三个,可用排除法排除BE选项,不需要临时表空间的临时文件,也不需要整个用户表空间的所有数据文件的备份。


【小结】选择ABD

 

 

 

 

 

 

QUESTION 108

You want to set the following Initialization parameters for your database Instance

LOG_ARCHIVE_DEBT_1 = ,,LOCATION=/disk1/arch

LOG_ARCHIVE_DBST_2 = ,,LOCATION=/disk2/arch

LOC_ARCHIVB DBST_3 = ,,LOCATION=/disk3/arch

LOG_ARCHIVE DBST_ = ,,LOCATION=/disk3/arch

Identify the statement that correctly describes this setting.

A. The MANDATORY location must be a flash recovery area.

B. The optional destinations may not use the flash recovery area.

C. This setting is not allowed because the first destination is not set as MANDATORY.

D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

Answer: D

Explanation

【题目示意】

此题考查有关于快速恢复区相关的知识。

    为数据库实例设置初始化参数。如果归档日志不能在目的地四被创建,则在线日志文件不能被覆盖。


【小结】选择D

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 109

Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources

Answer: CD

Explanation

【题目示意】

    此题考查关于STA相关的知识

【解析】

...

【实验】

 

【小结】选择CD

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 110

You executed the following command in Recovery Manager (RMAN):

RMAN> REPORT NEED BACKUP days 3;

What is the output of this command?

A. a list of files that require a backup within three days

B. a list of files requiring more than 3 days of archive logs to apply

C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

D. a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

Answer: A

Explanation

【题目示意】

    此题考查RMAN中备份参数相关的知识

【解析】

    该命令输出的是需要在三天内备份的文件的列表。

【小结】选择A

 

相关参考:

http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2006.htm#RCMRF90279

 

 

 

 

 

 

 

 

 

QUESTION 111

You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:

LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY'

LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch'

LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch

LOG_ARCH1VK_DEST_4 = ' LOCATION=/disk4/arch'

LOG_ARCHIVE_MIN-SUCCEED_DEST = 2

While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch?

A. The online redo log file Is not allowed to be overwritten.

B. The archived redo log files are written to the flash recovery area until the   MANDATORY destination is made available.

C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.

D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

Explanation

【题目示意】

    此题考查归档路径设置的相关知识。

【解析】

数据库已经配置好闪回恢复区,设置如下参数。数据库实例正常工资时,发现归档日志文件在设置的第一个参数路径不能被创建。所有的重做日志组已经使用,问在日志切换时会发生什么?

    题中共有4LOG _ARCHIEVE_DEST,而LOG_ARCHIVE_MIN-SUCCEED_DEST = 2,即意味着必须有两个能归档成功,而LOG_ARCHIVE_DEST 1 是指定MANDATORY,即要求它必须归档成功,但此时LOG_ARCHIVE_DEST 1不可用,根据LOG_ARCHIVE_MIN-SUCCEED_DEST = 2,保证接下来的两个归档地址必须归档成功。


【小结】选择D

 

相关参考:

http://docs.oracle.com/cd/E11882_01/server.112/e25494/archredo.htm#ADMIN11346

 

QUESTION 112

Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two)

A. A job is specified as part of a program definition

B. A program can be used in the definition of multiple jobs

C. A program and job can be specified as part of a schedule definition

D. A program and schedule can be specified as part of a job definition

Answer: A

Explanation

【题目示意】

    此题考查调度器、作业和进程相关的知识

【解析】

此题选A:作业被指定为一个程序定义的一部分。

    A job is the combination of a schedule and a program, along with any additional arguments required by the program. This section introduces you to basic job tasks, and discusses the following topics:

 

【小结】选择A

 

相关参考:

http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12382

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29319205/viewspace-1079586/,如需转载,请注明出处,否则将追究法律责任。

上一篇: OCP 053 102-106
请登录后发表评论 登录
全部评论

注册时间:2013-11-20

  • 博文量
    33
  • 访问量
    190483