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文本
B. Shared server requests (Oracle MTS) C. Bind variable values 绑定变量值
D. Information about transactions 事务信息
E. Remote DESCRIBE and COMMIT operations Answer: A,C,D
QUESTION NO: 117
Which of the following are true concerning block media recovery? (Choose all that apply.) 关于块介质恢复 下列哪个是真的？
A. Any gap in archive logs ends the recovery.
B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are notcorrupt. 如果遇到一个归档记录缺口，RMAN 将向前搜索未损坏的较新版本的块。
C. Uncorrupted blocks from the flashback logs may be used to speed recovery.闪回日志的未损坏块可用于 加快恢复D. The database can be in NOARCHIVELOG mode. E. None of the above.
Option A is incorrect because a gap in archive logs does not automatically end the recovery.
RMAN will search forward for uncorrupted newer blocks; if RMAN finds one, it will continue with the restore and recovery operation. RMAN will check the flashback logs for uncorrupted copies of the block before it checks the backups.
Option D is incorrect because the database must be in ARCHIVELOG mode. Answer: B,C
QUESTION NO: 118
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the
maximum values for SGA and PGA, based on the amount of memory available on the system? DBA 已经选 择在 OLTP 数据库中分开管理 SGA 和 PGA 内存，因为他独特的应用知识。基于系统上可用的内存量，当配 置 SGA 和 PGA 的最大值时，这些良好的出发点中哪个可以利用？ A. 20% SGA, 80% PGA
B. 25% SGA, 75% PGA C. 50% SGA, 50% PGA D. 75% SGA, 25% PGA E. 80% SGA, 20% PGA Answer: E
QUESTION NO: 119
You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to
reach the RESUMABLE_TIMEOUT value. Which of these actions is appropriate? 您会注意到由于空间限制
一个长期运行的交易被暂停，也没有暂停后解决问题的触发事件。你也注意到关键的事务恰好即将达到可恢 复超时值。这些行动的哪一个是适当的？
A. Abort the session, fix the space problem, then resubmit the transaction.
B. Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend the time-out for the session while you fix the problem. 当你解决这个问题时，使用DBMS可恢复的.设置会话超时程序以延长会 话的超时时间。
C. Do nothing, let the transaction fail, then fix the problem. D. Use Segment Shrink to clean up the table.
E. Use the DBMS_RESUMABLE.SET_TIMEOUT procedure to extend the time-out for the session while you fix the problem. Answer: B
QUESTION NO: 120
Which of the following are not disabled by default? 下列哪项不是默认情况下禁用？
A. Jobs B. Chains C. Windows
D. Window groups
E. Schedule时间表
A schedule is enabled by default. The others are disabled by default. Answer: E
QUESTION NO: 121
You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur? 您会注意到在一个非约束的RAC数据库中，一个链中的作业还没 有完成。下面这些哪一个是可能发生有效的原因？
A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage. B. The job affinity is to a service and one node in that service is unavailable.
C. The job affinity is to an instance and that instance is unavailable.作业和一个实例有密切关系，该实例不可用。
D. There is no service affinity.
E. None of the above.
C. Since we‘ve established that the RAC is not performance constrained, option A is not valid—if the resource group were not able to obtain adequate CPU, this might be a valid answer. Option B is not correct because service affinity guarantees that if one instance in the service is available, the Scheduler will attempt to use it to run the job. If there is no service or instance affinity, the Scheduler will attempt to balance the load across surviving nodes. 既然我们已经确定RAC没有性能约束，选项A不是有效--如果资源 组无法获得足够的CPU，这可能是一个有效的答案。选项B是不正确的，因为服务的亲和力保证如果在服 务中的一个实例，调度会尝试用它来运行作业，如果没有服务或实例的亲和力，调度会尝试幸存的节点之 间的负载平衡。Jobs can be defined with a service affinity (they should run on a specific service) as opposed to an instance affinity (they should run on a specific instance). If a job is assigned to a service consisting of two instances, even if one instance is down, the other can execute the job normally. Answer: C
QUESTION NO: 122
The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements? 该本地语言支持语言参数指定默认的约束将用于以下哪些全球化元素？ A. Languages for server messages用于服务器消息的语言
B. Day and month names and abbreviations日期和月份名称和缩写
C. Symbols to represent a.m., p.m., AD, and BC代表上午，下午，公元和公元前的符号 D. Affirmative and negative response strings (YES, NO) 肯定和否定响应字符串（是，否）
E. All of the above
Answer: E
NLS：native language support本地语言支持
QUESTION NO: 123
The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following
globalization elements? (Choose all that apply.)该本地语言支持地域参数指定缺省的协议用于以下哪些全 球化元素？
A. Date format日期格式
B. Decimal character十进制字符
C. Group separator组分隔符，NLS 指定将用作组分隔符和小数位的字符。组分隔符就是用来分隔整数位组 (如千、百万等等) 的字符。小数分隔符用来将一个数字的整数部分与小数部分分隔开。 D. First day of the month E. None of the above F. All of the above Answer: A,B,C
QUESTION NO: 124
What are three benefits of using ASM? (Choose three.)使用ASM的三个好处是什么？ A. Ease of disk administration and maintenance易于磁盘的管理和维护 B. Load balancing across physical disks跨物理磁盘的负载均衡
C. Software RAID-1 data redundancy with double or triple mirrors双倍或三重镜像的软件RAID-1数据冗余 D. Automatic recovery of failed disks Answer: A,B,C
QUESTION NO: 125
What components are present in an ASM instance? (Choose three.) ASM实例中都存在哪些组件？ A. SGA共享全局区
B. Database processes数据库进程 C. Database datafiles D. Control files
E. Database parameter file or spfile数据库参数文件或spfile
A, B, E. Option A is correct because the SGA is allocated when the ASM instance is started. Option B is correct because the Oracle processes are also started when the ASM instance is started. Option E is correct because the ASM instance requires either a parameter file or an spfile. Answer: A,B,E
QUESTION NO: 126
Which of the following is a benefit of ASM fast disk resync? 下列哪项是ASM快速磁盘重新同步的好处？ A. Failed disks are taken offline immediately but are not dropped. 发生故障的磁盘将立即脱机，但不掉线 （删除）。
B. Disk data is never lost.
C. By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk. D. The failed disk is automatically reformatted and then resynchronized to speed up the recovery process. E. Hot spare disks are automatically configured and added to the disk group. Answer: A
When a disk fails, it is taken offline immediately but it is not dropped at that time. By default, you will have 3.6 hours to correct the problem before ASM will automatically drop the disk. You can configure this time by modifying the disk attributes. 磁盘出现故障时，它立即脱机，但它不是在那个时候删除。默认情况下， 在ASM会自动删除磁盘之前，你将有3.6小时之前纠正这一问题。您可以通过修改磁盘属性配置这个时候。
QUESTION NO: 127
What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation? 重新平衡操作期间，增加ASM能力限制参数值的结果是什么？
A. The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
B. The ASM rebalance operation will consume fewer resources and complete in a longer amount of time. C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time. ASM再平衡操作将被并行化，并应在一个更短的时间内完成。 D. There is no ASM_POWER_LIMIT setting used in ASM. E. None of the above