ORACLE 11G OCP 管理2 WorkshopII 1Z0-053 题库200-300之间题 -(4)

(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

Answer: BDE Section: (none)

QUESTION 233

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the

OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans. B. Capture the plans from the previous version using STS and then load them into the stored outline. D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being

loaded to the SQL plan baseline.

Answer: C Section: (none)

QUESTION 234

Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?

A. a cumulative level 1 backup B. a differential level 1 backup C. a full backup D. a whole backup

Answer: A Section: (none)

C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB)

QUESTION 235

The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.

SQL> STARTUP;

Which two activities are performed during a successful start up operation? (Choose two.)

A. The databases configured to use the ASM instance are mounted

B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started D. ASM discovers and examines the contents of all files that are in the paths specified in the

ASM_DISKGROUPS initialization parameters

Answer: BC Section: (none)

Explanation/Reference:

QUESTION 236

Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.

Which components are backed up when this option is specified?

A. only the control file, the current SPFILE, and data files

B. only the current SPFILE and data files if autobackup is disabled C. only the data files and the archived redo logs

D. the control file, current SPFILE file, data files, and archived redo logs

Answer: D Section: (none)

QUESTION 237

You executed the following commands in an RMAN session for your database instance that has failures:

RMAN> LIST FAILURE;

After some time, you executed the following command in the same session:

RMAN> ADVISE FAILURE;

But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only. C. It produces an error with recommendation to run the LIST FAILURE command before the

ADVISE FAILURE command.

Answer: A Section: (none)

QUESTION 238

View the Exhibit to examine the output for the V$DIAG_INFO view.

Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)

D. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

A. The path to the location of the background as well as the foreground process trace files is

/u01/oracle/diag/rdbms/orclbi/orclbi/trace.

B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace. D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

Answer: ACD

Section: (none)

Explanation/Reference:

QUESTION 239

Evaluate the following command:

SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';

What is the impact of this setting on the usage of SecureFiles?

A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB. B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB. C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is

specified to create the LOB.

D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is

used and creates a BasicFile.

Answer: A Section: (none)

QUESTION 240

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:

ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';

To which disks in the disk group will the new value be applicable?

A. all disks in the disk group

B. all disks that are currently in OFFLINE mode C. all disks that are not currently in OFFLINE mode D. all disks in the disk group only if all of them are ONLINE

Answer: C Section: (none)

Explanation/Reference:

QUESTION 241

You issued the following RMAN command to back up the database:

RMAN> RUN{

ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE TAG quarterly KEEP FOREVER

RESTORE POINT FY06Q4;}

Which two statements are true regarding the backup performed? (Choose two.)

A. Archived redo log files are backed up along with data files.

B. Only data files are backed up and a restore point named FY06Q4 is created.

C. Archived log files are backed up along with data files, and the archived log files are deleted.

D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

Answer: AD Section: (none)

QUESTION 242

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?

A. A base catalog exists B. The recovery catalog is empty

C. The base recovery catalog must be dropped

D. A target database is registered in the recovery catalog

Answer: A Section: (none)

QUESTION 243

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库ORACLE 11G OCP 管理2 WorkshopII 1Z0-053 题库200-300之间题 -(4)在线全文阅读。