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

A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption. 健康监视器检查可用于重做日志和归档记录的可访问性和损坏的内容扫描。 B. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent. 健康监视检查可用于验证数据库文件的完整性和报告故障是 否这些文件是无法存取，毁损或不一致的。

C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.

D. Health Monitor checks are always initiated manually when there is some critical error. Answer: A,B

QUESTION NO: 41 Exhibit:

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:为了一些当前参数设置查看图表。用户登录到HR方案，发出以下 命令：

SQL> CREATE TABLE emp (empno NUMBER(3), ename VARCHAR2(20), sal NUMBER(8,2));

SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES');

At this moment, a second user also logs in to the HR schema and issues the following command: 就在这 时，第二个用户同时登录到HR方案，并发出以下命令： SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2); What happens in the above scenario?

A. The second user's session immediately produces the resource busy error. B. The second user's command executes successfully.

C. The second user's session waits for a time period before producing the resource busy error. 第二个用户的会话在产生资源忙的错误之前等待一段时间。 D. A deadlock is created. Answer: C

QUESTION NO: 42？

In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?

(Choose all that apply.) 在哪些情况下ASM元数据备份会帮你在一个磁盘组恢复ASM磁盘？ A. when one or more file directory paths are accidentally deleted from an ASM disk group 当一个或多个文件目录路径从ASM磁盘组被意外删除

B. when one of the disks in a disk group is accidentaly unplugged C. when the data file on an ASM disk group gets corrupted

D. when one or more disks in an ASM disk group are lost 当ASM磁盘组中的一个或多个磁盘丢失时 Answer: A,D

QUESTION NO: 43？

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.) 哪两个是启用闪回数据归档的先决条件？

A. Database must be running in archivelog mode.

B. Automatic undo management must be enabled. 必须启用自动撤销管理。 C. Undo retention guarantee must be enabled.

D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM). 必须用自动段空间管理（ASSM）去管理表空间，该表空间上创 建了闪回数据归档。

Answer: B,D

QUESTION NO: 44

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command: 在您的数据库中，结果高速缓存模式参数已经在初始化 参数文件中设为手动。你发出以下命令：

SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales

GROUP BY sale_category;

Where would the result of this query be stored? 此查询的结果将被储存在哪里？

A. database buffer cache B. shared pool共享池 C. PGA

D. large pool Answer: B

QUESTION NO: 45

You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition? 你需要执行现有销售表的联机 表重定义以将它分割成两个表空间TBS1和TBS2。带有优先子句的销售表有一个物化视图、物化日志、索 引、参照完整性约束和触发器。当您执行联机表的重定义时什么样的行动是依赖对象需要的？

A. The dependent materialized view should have a complete refresh performed after the online table redefinition process. 在线表重新定义过程后依赖物化视图应该执行一个完全的刷新。

B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process. C. Referential integrity constraints must be manually enabled after the online table redefinition process. D. The materialized log should be dropped before the online table redefinition process. Answer: A

QUESTION NO: 46

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command: （sbt 全称是 system backup to tape）

你要备份用户表空间。它有一个 900 MB 的数据文件。你有 300 MB 的磁带驱动器。 SBT 通道配置用于 RMAN。要完成备份，你发出以下 RMAN 命令：

RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two statements are true regarding the execution of the above command? (Choose two.) A. The RMAN parallelizes the backup although the parallelism is not set for a channel.

B. The backup piece size will be limited to 300 MB. 备份片的大小将被限制为300 MB。 C. The operation is accomplished using the default channel available. 操作是通过使用可用的缺省通道来完成。

D. Three channels for the tape drive must be configured by setting the parallelism to three. Answer: B,C

QUESTION NO: 47

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database? (Choose all that apply.) 你重新安装 Oracle11g 数据库。关于这个数据库中设置的默认审计哪 些描述是真实的？

A. The audit trail is stored in an operating system file. B. Auditing is disabled for all privileges. C. The audit trail is stored in the database. 审计跟踪存储在数据库中。

D. Auditing is enabled for all privileges.

E. Auditing is enabled for certain privileges related to dat …… 此处隐藏：6945字，全部文档内容请下载后查看。喜欢就下载吧 ……