默认题库 - 1Z0-053

多选题

What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)

A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh

查看答案

单选题

RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.（）

A. True
B. False

查看答案

多选题

Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）

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.

查看答案

单选题

You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）

A. You will need to open the database with the resetlogs command.
B. All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
C. You will use the resetlogs version of the create controlfile command.
D. You will use the noresetlogs version of the create controlfile command.
E. You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

查看答案

单选题

Which tasks can be performed with the DSCLI on IBM System Storage DS6000 and DS8000 servers?（）

A. Monitor disk errors and manage storage complexes
B. Monitor disk errors and invoke point-in-time copy
C. Invoke point-in-time copy and initiate a storage unit shutdown
D. Invoke point-in-time copy and manage storage complexe

查看答案

多选题

You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)

A. The KEEP option overrides the configured retention policy
B. The KEEP option is an attribute of an individual backup piece
C. The backup contains only data files and archived redo log files
D. The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

查看答案

单选题

A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）

A. The transactions that use the disk group will halt.
B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.
C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

查看答案

单选题

What is the net effect of the following command？（） alter diskgroup dgroup1 drop disk abc；

A. The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.
B. The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
C. The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.
D. This command will fail because you cannot drop a specific disk in an ASM disk group.
E. The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.

查看答案

单选题

Performance divergence indicated in the Workload Replay report is most likely due to what？（）

A. DML and SQL statement results that do not match between the capture and replay systems
B. When errors that occur in the capture system dont occur in the replay system
C. Top SQL statements
D. Infrastructure or system-configuration differences
E. Time-of-day differences between capture and replay system

查看答案

单选题

Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion？（）

A. The database must be in read-write mode.
B. The database must have no external files.
C. The database must open in read-only mode.
D. The database must be mounted but not opened.

查看答案