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

QUESTION NO: 14

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.) 在Oracle11g数据库中使用企业管理器支持工作台可以完成哪些任务 A. Generate reports on data failure such as data file failures.

B. You can track the Service Request (SR) and implement repairs. 你可以跟踪服务请求（SR）和实施维修。

C. You can package and upload diagnostic data to Oracle Support. 您可以打包和上传诊断数据到Oracle支持网站。

D. You can manually run health checks to gather diagnostic data for a problem. 你可以为一个问题手动运行健康检查以收集诊断数据。 Answer: B,C,D

QUESTION NO: 15

What are the advantages of variable extent size support for large ASM files? (Choose two.) 支持大ASM文 件的可变区大小的优势是什么？

A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.

B. It improves performance in the extended cluster configuration by reading from a local copy of an extent.

C. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool. 在共享池中需要较少的区指针去描述文件，并且需要更少的内存去管理区 位图。

D. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents. 此功能可以更快地打开文件，因为减少了需要存储文件区的内存量。 Answer: C,D

QUESTION NO: 16

Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.) 哪两个是ASM元数据备份和恢复（AMBR）特点的使用？ A. It can be used to back up all data on ASM disks.

B. It can be used to recover the damaged ASM disk group along with the data.

C. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure. 它可以用来收集关于一个带有磁盘路 径、磁盘名、故障组、属性、模板和别名的目录结构的已经存在的ASM磁盘组的信息。

D. It can be used to re-create the ASM disk group with its attributes. 它可以用来重新创建带有属性的ASM磁盘组。 Answer: C,D

QUESTION NO: 17

Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)

哪两个变化及其对系统的影响可以通过使用数据库重放特性测试？ A. multiplexing of the control file

B. adding the redo log member to the database C. database and operating system upgrades 数据库和操作系统升级

D. changing the database storage to ASM-managed storage 更改数据库存储到ASM管理的存储 Answer: C,D

QUESTION NO: 18？

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? 哪一个是作为自动任务框架的一部分运行的自动SQL调优使用的源？ A. SQL statements that are part of the AWR baseline only B. SQL statements based on the AWR top SQL identification 基于自动工作负载信息库最高位的SQL标识的SQL语句

C. SQL statements that are part of the available SQL Tuning Set (STS) only

D. SQL statements that are available in the cursor cache and executed by a user other than SYS Answer: B

QUESTION NO: 19

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area? 闪回恢复区进行备份时，您会注意到一个归档重做日志文件丢失。 您有多个目的地归档重做日志文件。它有什么样的影响闪回恢复区的备份？ A. The backup fails because one of the archived redo log files is missing. B. The backup succeeds but it would be without the missing archived log.

C. During backup, you are prompted for the alternative destination for the missing archived redo log file. D. The backup succeeds because it fails over to one of the alternative archived redo log destinations. 备 份成功，因为它失效转移到其他的归档重做日志目的地之一。 Answer: D

QUESTION NO: 20

You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.) 您管理Oracle11g数据库实例和Oracle10g数据库实例在同一台机器上。这两种情况下使用ASM实例用于存 储。在这种场景下，关于ASM磁盘组的兼容属性哪种说法是真实的？

A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances. 用于每个实例的数据库兼 容版本设置必须是大于或等于该数据库实例中所使用的所有ASM磁盘组的关系型数据库管理系统兼容性。 B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group. 关系型数据库管理系统兼容性和数据库版本决定了一个数据库实例是否可以挂载ASM 磁盘组

C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

D. ASM compatibility controls which features for the ASM will be enabled. 用于ASM特性的ASM兼容性控制 将被启用。 Answer: A,B,D