Oracle 053 186-355译文版

QUESTION NO:186

 

你使用什么命令去设置一个永久性的设置(rman中)以便so that备份写到一个磁带设备。

C. CONFIGURE DEFAULT DEVICE TYPE TO SBT

 

 

QUESTION NO:187

(Choose all thatapply.)  control_file_record_keep_time初始参数应该设置什么值？

C. The initialization parameter shouldbe set to greater than 0 with the RMAN repository utilizing the control file orthe recovery catalog. 使用控制文件或恢复编目，RMAN仓储，该初始化参数应该设置>0;

E. The initialization parameter shouldnever be set to 0 if you are using RMAN. 如果你使用RMAN，该初始值不应设置为0.

 

QUESTION NO:188

给出下列的步骤，哪个是正确的顺序，去创建一个归档模式数据库的备份（control-file自动备份启用）？

a. backup archivelogall;  

b. backup database all;

c. backup controlfile;

d. backup archivelog,database, controlfile delete input;

e. backup database plus archivelog delete input

A. e

B. a, b, a, c

C. d

D. b, a, c

E. b, a, c, d, e

 

QUESTION NO:189（Jesse）

(Choose all that apply.)关于backup命令语句描述正确的是：

A. The BACKUP command can not be used to make image copies of a datafile.-----backup as copy

B. The BACKUP command can improveperformance by multiplexing backup files.通过复用备份文件，backup命令可以改进性能

C. The BACKUP can take advantage of利用 the block-changetracking capability.备份可以利用block-changetracking能力。

D. The BACKUP command cannot store data in incremental backups.增量备份

E. The BACKUP command can store data in cumulativeincremental backups only.

 

QUESTION NO:190

哪个命令用于去配置RMAN为每次备份执行以压缩方式备份

C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSEDBACKUPSET

 

 

QUESTION NO:191

你发起以下命令

RMAN>CONFIGURE BACKUP OPTIMIZATIONON;备份优化，能不备就不备。

这个命令对你的备份的影响是：

B. Read-only datafiles will not bebacked up as long as backups of thosefiles already exist and those backups meet established retention criteria.

只读的数据文件将不备份，只要这些文件备份已经存在且这些备份还在保留期内。

QUESTION NO:192

(Choose all that apply.)  RMAN恢复编目的目标是什么？

A. It must be used because all RMAN-related backup andrecovery metadata information is contained in it.

B. It provides a convenient, optional,repository of backup- and recovery-related metadata.它提供了一个实用的，可选的，基于备份和恢复元数据的仓库

C. It provides the ability to storeRMAN scripts for global use by any database that has access to the repository.它提供了存储RMAN脚本的能力（被数据库全局使用）

D. It provides a means of storing all RMAN backup setsphysically in an Oracle database server.

E. It provides the ability to storebackup records for more than a year.它提供能力去存储备份记录超过1年。

 

QUESTION NO:193

 (Choose all that apply.) 什么权限必须被授权（去允许一个账户去创建恢复编目）？

A. RECOVERY_CATALOG_OWNER

B. DBA

C. RESOURCE

D. SELECT ANY DICTIONARY

E. CONNECT

 

QUESTION NO:194

哪个命令用于去创建一个恢复编目架构

B. create catalog

 

QUESTION NO:195

(Choose all that apply.)如果你没有连接到recovery catalog进行备份数据库，哪个操作将引起recovery catalog被更新

A. The next time you back up thedatabase when you are also connected to the recovery catalog and the targetdatabase下次你备份数据库，当你也连接到recovery catalog和目标数据库

B. The next time you are connected tothe target database and the recovery catalog database and issue the resynccommand 下次你连接到target数据库和恢复catalog数据库，发起resync命令。

C. The next time you connect RMAN to just the recoverycatalog

D. The next time you connect to the recovery catalog and thetarget database with RMAN

E. Connecting to the recovery catalog and issuing the resyncall databases command

 

QUESTION NO:196

你在recoverycatalog中创建了一个脚本backup_database。下面哪个命令将能成功执行该脚本：

 

D. Run {

execute scriptbackup_database;

}

 

 

QUESTION NO:197

你如何去创建一个recovery catalog：

 

b. Create therecovery-catalog database. 创建recovery-catalog数据库

c. Create therecovery-catalog user.        创建recovery-catalog用户

d. Grant therecovery_catalog_owner privilege to the recovery-catalog user.授权recovery_catalog_owner特权给该用户

a. Issue the createcatalog command.  发起create catalog命令

e. Issue the register database command from the targetdatabase.

 

创建recovery-catalog数据库---创建RC用户-授权recovery_catalog_owner权限给RC用户—发起create catalog命令---从target数据库上发起register database命令

 

A. a, b, c, d, e

B. b, a, d, c, e

C. b, c, d, a, e

D. b, c, d, e, a

E. b, d, c, a, e

 

QUESTION NO:198

你怎样授权RVPC用户去访问RMAN虚拟专用catalog中的特定的RMAN数据库记录？

D. Issue the grant command from RMANwhen connected to the recovery catalog-owning schema.从RMAN下发起grant命令，当连接到recovery-catalog所属的模式时

 

QUESTION NO:199（Jesse）

 (Choose all that apply.)RVPC用户可以做以下哪些？

 

A. Register databases if granted theregister database privilege如果已经授权注册数据库权限的话，可以注册数据库

C. See all database-related metadata inthe recovery catalog if they are granted access to that database如果他们被授权访问数据库，看recovery catalog中的所有数据库相关的元数据。

 

QUESTION NO:200---重点…backup  datafile and 1,and 2

给定的脚本：

create script db_backup_datafile_script

{

backup datafile and 1, and 2 plus archivelogdelete input;

}

 

运行这个命令的结果是：

 

Run {execute script db_backup_datafile_script using 2;}

 

D. The execute script command willprompt for the value of  and2 since it'snot included in the command.

 

Topic 3,Pool 3

QUESTION NO:201

 (Choose all that apply.)从RMAN命令行中正确连接到target数据库和recoverycatalog的途径？假定target数据库为ORCL，recoverycatalog数据库为RCAT。也假定recovery-catalog属主为rcat_own,假定环境配置为ORCL数据库

 

C. rman target=/   catalog=rcat_own/rcat_own@RCAT

D. rman target=sys/robert@orclcatalog=rcat_own/rcat_own@RCAT

 

QUESTION NO:202

What command would youissue to enable automated backups of control files?你发起哪个命令去启用automated backups of control files?

C. configure controlfile autobackup on

 

QUESTION NO:203------

Given the following RMANcommands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG-modedatabase. 

c. shutdown immediate

a. restore database;

e. restore archivelog all;

b. recover database;

d. startup

f. alter database open

A. a, b, c, d, e, f

B. c, b, a, d, e, f

C. c, b, a, d, f

D. c, a, b, d

E. c, a, e, b, d, f

 

QUESTION NO:204

 (Choose all that apply.)  RMAN数据库恢复的命令,

A. restore

B. repair

C. copy

D. recover

E. replace

 

QUESTION NO:205

如果你的数据库完全丢失，执行下列RMAN操作去进行恢复？

a. restore controlfile

b. restore database

c. restore spfile

d. recover database

e. alterdatabase open

f. alter database open resetlogs

A. b, a, c, d, e

B. a, c, b, d, f

C. c, a, b, d, e

D. c, a, b, d, f

E. e, a, b, d, c

 

QUESTION NO:206

如果你丢失了你完整的数据库（包括spfile，控制文件，在线重做日志，数据文件），那种类型的数据库恢复是需要的？

B. Incomplete database recovery.

 

 

QUESTION NO:207

哪个命令将还原所有的数据文件到9/30/2008 at 18:00hours?

C. restore database until time'09/28/2008:18:00:00';

 

QUESTION NO:208------好好理解理解（Jesse）

如果他们成功，这些命令的最后结果是什么？

RMAN> show retention policy;

RMAN configurationparameters for database with db_unique_name ORCL are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

Backup databasetag=’gold_copy’ plus archivelog tag=’gold_copy’ delete input;

Backup databasetag=’silver_copy’ plus archivelog tag=’silver_copy’ delete input;

A. Attempting to restore silver_copy will fail.

B. Attempting to restore gold_copy will fail.

C. Both backups will be available for restore withoutquestion.

D. Attempting to restore gold_copy mayor may not succeed.

E. You will not be able to restore either gold_copy orsilver_copy.

 

QUESTION NO:209

你正在使用RMAN去备份你的archivelog数据库。你已经启用了controlfile autobackups。在RMAN备份期间，哪个文件不能备份？

A. Database Datafiles

B. Database Control Files

C. Online redo logs

D. Archived redo logs

E. The database SPFILE

F. None of the above, all these files are backed up.

 

QUESTION NO:210----

 

RMAN offers the equivalent等价 of the SQL command alter database backup controlfile to trace.   RMAN提供了等价的SQL命令alterdatabase backup controlfile to trace.错误的。

A. True

B. False

 

QUESTION NO:211

You need to restore yourdatabase back to 9/30/2008 at 18:00. In what order would you run the followingcommands to compete this task?

你需要还原你的数据库到9/30/2008 at 18:00.你用什么顺序去运行下列命令来完成这个任务？

a. restore controlfileuntil time ‘09/30/2008:18:00:00’;

b. restore database until time ‘09/30/2008:18:00:00’;

c. restore spfile untiltime ‘09/30/2008:18:00:00’;;

d. recover database until time ‘09/30/2008:18:00:00’;

e. alter database open resetlogs;

f. alter database open;

A. b, d, e

B. b, d, f

C. c, a, b, d, e

D. c, a, b, d, f

E. a, b, d, e

 

QUESTION NO:212

What is the correctorder of the following commands if you wanted to restore datafile 4, which was accidentallyremoved from the file system?如果你想去还原数据文件4（该文件已经意外的从文件系统下删除），如何做？

a. sql ’alter databasedatafile 4 online’;

b. restore datafile 4;

c. recover datafile 4;

d. sql ’alter databasedatafile 4 offline’;

e. startup

f. shutdown

df4offline---restore df4---recover df4---df4 online.

 

A. a, c, b, d

B. d, b, c, a

C. f, d, b, c, a, e

D. c, a, b, d, f

E. a, b, d, e

 

 

QUESTION NO:213

你的数据库运行，3个控制文件中的一个被意外删除。你启动RMAN和运行restorecontrolfile from autoback;

 

下列哪些描述是正确的(Choose all that apply.)

C. The command fails because thedatabase is running.数据库运行状态下该命令失效

E. This is not the correct way toaddress this problem.不是正确定位问题的途径

 

QUESTION NO:214

Which of the followingare valid until commandoptions when attempting point-in-time recovery in RMAN? (Choose all thatapply.)当尝试在RMAN中进行基于时间点的恢复时，until命令选项正确的是：

A. until time

B. until change

C. until sequence序列

D. until SCN

E. until commit

题库答案为ACD

 

QUESTION NO:215

下列哪个不是recover命令做的？

A. Restore archived redo logs.

B. Apply archived redo logs.

C. Restore incremental backups.

D. Apply incremental backups.

E. Restore datafile images.？？？？？？

 

QUESTION NO:216

(Choose all that apply.)你的数据库有system,sysaux,undo,users,temp表空间，你想回滚users表空间的数据到昨天。哪个表空间执行还原操作去完成这个任务？

A. SYSTEM

B. SYSAUX

C. UNDO

D. USERS

E. TEMP

F. This restore is not possible.

 

QUESTION NO:217

你使用imagecopy去备份你的数据库。你丢失了system表空间，需要重启你的数据库（尽可能快的）,正确的解决方案是：

C. Use the switch datafile command toinstantly switch to the datafile copy,