Oracle - 11G - 题库337 - 图文(14)

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 需要超过 3 天的归档记录申请时间的文 件列表

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: B

QUESTION NO: 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? 当数据库实例运行时，你意识到， 日志存档目的地I参数设置的目标不适用于被创建在里面的归档重做日志文件。所有重做日志组已经使用。 一个日志切换事件中会发生什么？

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_I parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.由日志归档目标 I 参数 设定的目标被忽略且在接下来的两个可用的位置创建归档重做日志文件以保证创建归档日志成功。 Answer: D

QUESTION NO: 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: B D

. Schedule (时间表) 通过 DBMS_SCHEDULER 包中的过程 CREATE_SCHEDULE 定义调度的开始时间，结束时间以及重复 间隔

CREATE_EVENT_SCHEDULE 过程用来创建由事件触发的时间表，由一个特定时间段内的一个事件调起

一项任务

. Program (程序)

定义了作业的形式及内容，作业形式可以是PL/SQL 匿名块，也可以是存储过程或者外部可执行文件， 执行的存储过程带有输入参数时必须以匿名块运行 . Job (作业)

通过CREATE_JOB创建一个作业，这个存储过程使用了重载，所以输入参数的选择可以非常灵活，既 可以独立设置作业的时间、内容、Job Class，也可以引用已经存在的Schedule 和 Program 来简化作业的创 建

QUESTION NO: 113

What RMAN command is used to execute a tablespace point-in-time recovery? 什么 RMAN 命令是用来执行 表空间时间点恢复 A. recover B. duplicate C. restore D. copy

E. None of the above Answer: A

QUESTION NO: 114

A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state? 用户在一张表上执行一个更 新。提交事务后不久，他们意识到在他们的 WHERE 子句中他们有一个错误，导致错误的行被更新了。哪一 个闪回选项将允许你撤销此交易，并恢复该表到以前的状态？ A. Flashback Drop B. Flashback Query

C. Flashback Versions Query D. Flashback Transaction Query E. Flashback Table闪回表 Answer: E

QUESTION NO: 115

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take? 一位开发者致电并报告他不慎 删除生产数据库中的一个重要的查找表。他需要该表能被恢复。你会采取什么样的行动呢？ A. Initiate an incomplete recovery operation using RMAN. B. Copy the table from a development database. C. Advise the user to rekey the data.

D. Perform a Flashback Drop operation. 执行闪回删除操作。 E. Perform a Flashback Recovery operation. Answer: D

QUESTION NO: 116

In a Database Replay workload capture, what client request information is gathered? (Choose all that apply.) 在数据库重放负载捕获，什么样的客户端请求的信息被收集？ A. SQL text SQL文本 …… 此处隐藏：2270字，全部文档内容请下载后查看。喜欢就下载吧 ……