oracle10gOCP题库资源-CSDN文库

共3个文件

exe：2个

pdf：1个

需积分: 9 80 浏览量 2010-10-29 21:35:39 上传评论收藏 2.92MB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

新题库.rar （3个子文件）

1Z0-042.exe 1.18MB

1z0-043.pdf 2.32MB

1Z0-043_185题库.exe 880KB

科目代码: 1z0-043

科目名称: oracle database 10g:administration ii

分卷: A

1: 单选题

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every

Sunday night. On Monday morning, while querying the user1.employees table, you receive the

following error message:

01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5:

'/u01/app/oracle/oradata/orcl/example01.dbf'

You need to rectify the corruption while ensuring the following:

The data file should remain online.

The mean time to recover (MTTR) should be minimal.

You are not using a backup control file, and all the archived logs are accessible. Which option

would you choose?

选项

flash back the corrupted blocks

use the DBMS_REPAIR package

use the RMAN TSPITR command

use the RMAN BLOCKRECOVER command

use the RESTORE DATABASE and RECOVER DATABASE commands

investigate the time at which the corruption occurred and perform a point-in-time recovery

正确答案: D

2: 单选题

A database is running in ARCHIVELOG mode. It has two online redo log groups and each group

has one member. A LGWR I/O fails due to permanent media failure that has resulted in the loss of

a redo log file and the LGWR terminates causing the instance to crash.

Which method should be used to efficiently recover from this loss of the current group member?

选项

Restart the database; it would automatically re-create the corrupted redo log member.

Restore the corrupted redo log group, perform incomplete recovery, relocate by renaming the

member of the damaged online redo log group to a new location, and then open the database with

RESETLOGS.

Restore the corrupted redo log member, perform incomplete recovery, relocate by renaming the

member of the damaged online redo log group to a new location, and then open the database with

RESETLOGS.

Restore whole database backup, perform incomplete recovery, relocate by renaming the member

of the damaged online redo log group to a new location, and then open the database with the

RESETLOGS option.

正确答案: D

3: 单选题

There was media failure and you need to check the data files for any block corruption. Which

option would you use to create a report on any corruptions found within the database?

选项

the DBNEWID utility

the DBVERIFY utility

the ANALYZE command

the RMAN REPORT command

the RMAN CROSSCHECK command

the CHECK_OBJECT procedure of the DBMS_REPAIR package

正确答案: B

4: 单选题

You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?

选项

You do not need to restore all the data files.

You do not need to open the database with the RESETLOGS operation.

You do not need to perform a full backup after the RESETLOGS operation.

You do not need to recover all the data files to the same system change number (SCN).

正确答案: C

5: 多选题

You set the value for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter to 7.

Which two records in the control file of the database are circularly reused for storage because of

using this parameter? (Choose two.)

选项

backup records

data file records

archive log records

tablespace records

redo thread records

正确答案: C E

6: 多选题

You executed the following command at the command prompt:

$ rman TARGET sys/oracle@ad10g CATALOG rmanusr/rmanusr@as10g SCRIPT backup_whole

Which three statements are true regarding this command? (Choose three.)

选项

The backup_whole script is stored in the target database.

The backup_whole is a stored script in the recovery catalog.

The RMAN session terminates automatically after the execution of the command.

The backup_whole script is executed automatically after the successful connection to the recovery

catalog only.

The command produces an error because the RMAN script cannot be executed from the command

line.

The backup_whole script is executed automatically after the successful connection to target and

catalog database.

正确答案: B C F

7: 单选题

You have configured and registered your target database in a recovery catalog. Because the

application needs it, you created a new tablespace in the target database. Then you executed the

following command from an RMAN session after connecting to the target and catalog databases,

both:

RMAN> REPORT SCHEMA;

Which statement describes the operation performed?

选项

The target database instance transfers the updated information to the recovery catalog.

The command shows the information from the control file of the target database and recovery

catalog is synchronized with the target database after the command is executed.

The media manager transfers the schema details from the control file of the target database to the

recovery catalog.

The recovery catalog will be updated by RMAN with the updated information in the control file of

the target database and displays information about the database files.

正确答案: D

8: 多选题

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform

a cancel-based recovery? (Choose two.)

选项

You find that one of the redo log members in each redo log group is lost.

You find that a data file that belongs to the USERS tablespace is damaged.

You find that a data file that belongs to the SYSTEM tablespace is damaged.

You find that the current redo log group is damaged and is not available for recovery.

You realized while performing a recovery that an archived redo log file needed for recovery is

lost.

正确答案: D E

9: 多选题

评论收藏

内容反馈

derek

粉丝: 203
资源: 505

oracle10g OCP 题库

最新资源

oracle10g OCP 题库

oracle 10g ocp题库

Oracle 10g OCP 题库

ORACLE 10G OCP 题库

ORACLE 10G OCP 题库 IZ047

oracle 10g ocp 043题库

最新oracle10g OCP题库

OCP题库(oracle)

Oracle OCP题库

OCP题库

OCP题库！！！！！！！！！！！！！！！

oracle 10g OCP试题

Oracle 11g OCP题库 O51 052 053 pdf版

oracle 11g ocp题库

Oracle 11g OCP试题VCE 051 052 053

OCP题库软件

OCP最新题库

ORALCE OCP题库

Oracle_11g_OCP最新题库(PDF+VCE)2013.10.25考试过

Oracle11g_OCP

Oracle 11g OCP最新题库及模拟器

OCP题库题库题库题库

OCP认证题库

OCP升级题库

oracle10g OCP培训资料

OCP题库_051

OCA-OCP题库

最新资源