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

QUESTION NO: 54

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message: 一个数据库运行在归档记录模式下并执行定期备份。用户收到以下错误消息： Which is the recommended sequence of operations you need to perform for the query successfully? 哪一条是您需要成功执行查询的推荐的操作顺序，？

A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.

B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.

C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs. 在挂载模式下重新启动数据库，还原损坏的数据文件，恢复数据文件， 然后用重置日志打开数据库。

D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode. Answer: C

QUESTION NO: 55

Observe the structure of the table employees: The table contains 8475 records. 观察员工表的结构：表中 包含8475条记录。

One of the employees wants to know the names of all employees of the company. For this, he fires the following query: 其中一名雇员想知道该公司所有员工的名字。为这一点，他触发以下查询： SELECT * FROM EMPLOYEES ORDER BY emp_fname;

Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation. Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result? 由于执行查询操作不能放入内存，它需要磁盘空间来完成操 作。Oracle将分配以下哪种类型的段来完成操作并提供所需的结果？

A. Rollback segment

B. Temporary segment临时段 C. Data segment D. Index segment Answer: B

QUESTION NO: 56

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter? ASM 能力限制参数增值 的效果是什么?

A. The number of DBWR processes increases B. The number of ASMB processes increases