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 sam …… 此处隐藏：6943字，全部文档内容请下载后查看。喜欢就下载吧 ……