Oracle_11G_题库337

ORACLE试题

QUESTION NO: 1

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.) 确定哪两种情况下，你可以使用用于恢复的数据恢复顾问。

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open. 打开数据库时，数据库文件损坏。 C. You are not able to start up the database instance because the required database files are missing. 你不能启动数据库实例，因为所需的数据库文件丢失。 D. The archived log files are missing for which backup is not available. Answer: B,C

QUESTION NO: 2

Examine the following values of the initialization parameters in the database having the SID ORCL: 检查以下在数据库中具有ORCL SID的初始化参数的值：

BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1

What is the location of the Automatic Diagnostic Repository (ADR) home? 自动诊断信息库（ADR）之家 在什么位置？

A. /u01/app/oracle/product/11.1.0/db_1 B. /u01/app/oracle C.

$ORACLE_HOME/bdump D. $ORACLE_HOME/log Answer: B

QUESTION NO: 3

Observe the following PL/SQL block: BEGIN

dbms_spm.configure('SPACE_BUDGET_PERCENT', 30); END;

Which statement is correct regarding the above PL/SQL block? 有关上述PL / SQL块哪种说法是正确的？ A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.

B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB). C. It reserves 30% of the space in the SYSTEM tablespace for SMB.

D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace. 当SQL管理库占了30％以上的系统辅助表空间时，它会在警报日志文件中产生一个每周预警。 Answer: D

QUESTION NO: 4

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.) 你正在管理一个Oracle11g数据库的ASM实例，该实例的ASM兼容属性设置为11.1.0且冗余 设置为高的磁盘组中有三个磁盘。因为停电其中一个磁盘组中的磁盘变得不可用。在这种情况下哪些描述 是真实的？

A. The disk is immediately dropped from the disk group.

B. The ASM tracks the extents that are modified during the outa 自动储存管理跟踪在OUTA期间被修改的 区

C. The ASM migrates the extents from the unavailable disk to the remaining disks.

D. The disk automatically goes offline. 磁盘会自动脱机。

Answer: B,D

QUESTION NO: 5

Which statements are true regarding table compression? (Choose all that apply.) 关于表压缩哪些说法是正确的？

A. It saves disk space and reduces memory usage. 它可以节省磁盘空间，并降 低内存使用率。

B. It saves disk space but has no effect on memory usage.

C. It incurs extra CPU overhead during DML as well as direct loading operations. 它在数据操作语言以及直接装载操作期间产生额外的CPU开销。 D. It incurs extra CPU overhead during DML but not direct loading operations. E. It requires uncompress operation during I/O. Answer: A,C

QUESTION NO: 6

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo

management is enabled in the database. Which configuration should you use to accomplish this task? 您 作为一个DBA在决策支持系统上工作。有一个去跟踪和存储在数据库几张表至少三年的所有交易的业务需 求。在数据库中启用自动撤销管理。你应该使用哪个配置来完成这个任务？ A. Enable Flashback Data Archive for the tables. 为这些表启用闪回数据归档。 B. Specify undo retention guarantee for the

database. C. Enable supplemental logging for the database.

D. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.

E. Create Flashback Data Archive on the tablespace on which the tables are stored. Answer: A

QUESTION NO: 7

Which components are needed for successful and most efficient recovery. 成功和最有效的恢复需要哪些

组

件。

A. The backup RB3 and the current online redo log files 回滚段 3 和当前联机重做日志文件的备份 B. the backup RB2 and the archived redo log files after the log sequence number 15622 C. Backup RB1 and the archived redo log hies after the log sequence number 12871 D. The backup RB3 and the archived redo log files after the log sequence number 16721 Answer: A

QUESTION NO: 8

You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. 你正在用ASM存储来管理Oracle数据库

11g实例。你失去了一个ASM磁盘组数据。你有RMAN进行数据备份以及ASM元数据备份。

You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)

你想通过使用ASMCMD md_restore命令来重新创建丢失的磁盘组。你会用哪种方法实现这一目标？

A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group. 使用相同的磁盘组 名称，相同的磁盘集和故障组配置和磁盘组上的数据，用和备份的磁盘组一样的确切配置来恢复磁盘组。 B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations. 使用相同的磁盘组名称，相同的磁盘集 和故障组配置，用和备份的磁盘组一样的确切配置来恢复磁盘组。

C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes. 更改的磁盘组规范，故障组规格，磁盘组的名称，和其他磁盘属性来恢复 磁盘组。

D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter. 通过传递现有的磁盘组的名称到一个输入参数来恢复现有磁盘组中的元数据。 Answer: B,C,D

QUESTION NO: 9

Which statement describes the effect of table redefinition on the triggers attached to the table? 哪种说法描述连接到表的触发器上的表重定义效果？

A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table. 表上的所有触发器都将失效，并自动重新验证表上的下一个DML执行。

B. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.

C. All triggers on the table remain valid.

D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table. Answer: A

QUESTION NO: 10

You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this? 你计划收集自动负载信息库（AWR）的数据，在一个月的每个 星期一早上。你要Oracle数据库自动创建一个每星期一的基线，并删除旧的基线。什么是正确的行动来实 现这一点？

A. Create and populate a SQL Tuning Set from the AWR on every Monday.

B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday. C. Create a repeating baseline template. 创建一个重复基线模板。 D. Insert a finding directive for future ADDM tasks. Answer: C

QUESTION NO: 11

Which three statements are true regarding persistent lightweight jobs? (Choose three.) 哪三种说法是真实的关于持续的轻量级作业？

A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo. 持久性 的轻量级作业 修改数据字典中的几张表以生成大量的重做。

B. The user cannot set privileges on persistent lightweight jobs. 用户不能设置持久性的轻量级作业权限。 C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time. 持久轻量级作业是有用的，当用户需要在很短的时间内创造大量的作业。

D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.

E. The use of a template is mandatory to create persistent lightweight jobs. 强制性使用模板以创建持久性的轻量级作业。 Answer: B,C,E

QUESTION NO: 12

Your database initialization parameter file has the following entry: 你的数据库初始化参数文件中有以下项 目：SEC_MAX_FAILED_LOGIN_ATTEMPTS=3最大安全失败登录尝试=3 Which statement is true regarding this setting?

A. It drops the connection after the specified number of login attempts fail for any user.

为任何用户登录尝试失败到达指定的次数后断开连接。

B. It is enforced only if the password profile is enabled for the user. C. It locks the user account after the specified number of attempts.

D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege. Answer: A

QUESTION NO: 13

Which statement is true regarding virtual private catalogs? 关于虚拟私有目录哪种说法是真实的？

A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.

B. The virtual private catalog owner cannot create and modify the stored scripts.

C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database. 要执行大多数的RMAN操作，虚拟目录的所有者必须在目标数 据库上具有SYSDBA或SYSOPER权限。 Answer: D

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

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle_11G_题库337在线全文阅读。