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

D. It is part of the data dictionary and stored in the SYSTEM tablespace.

E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

Answer: CE Section: (none)

QUESTION 256

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:

ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;

What would be the outcome of this command?

A. It produces an error because data already exists in the table.

B. It produces an error because compression can be enabled at table creation only.

C. It compresses all data added or modified henceforth but the existing data in the table is not

compressed immediately.

D. It immediately compresses all existing data as well as new data, resulting from either fresh

additions or modifications to existing data.

Answer: C Section: (none)

QUESTION 257

Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

A. flashback query B. distributed transactions

C. logging in and logging out of sessions D. all DDL statements having bind variables E. direct path load of data from external files

Answer: CD Section: (none)

QUESTION 258

Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements. B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash. C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement. D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL

statement crashes and an incident is created in the ADR.

Answer: BD Section: (none)

Explanation/Reference:

QUESTION 259

Which setting enables the baselines by default in Oracle Database 11g?

A. setting the STATISTICS_LEVEL parameter to TYPICAL

B. adding filters to the Automatic Database Diagnostic Monitor (ADDM) C. enabling Automated Maintenance Task using Oracle Enterprise Manager D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

Answer: A Section: (none)

QUESTION 260

Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

A. Diagnose and repair a data file corruption offline. B. Diagnose and repair a data file corruption online. C. Diagnose and repair failures on a standby database.

D. Recover from failures in the Real Application Cluster (RAC) environment.

Answer: CD Section: (none)

QUESTION 261

In which cases is reference partitioning effective in enhancing performance?

A. It is effective only in partition pruning.

B. It is effective only in partitionwise joins provided that the query predicates are different from the

partitioning key.

C. It is effective in both partition pruning as well as partitionwise joins provided that the query

predicates are identical to the partitioning key.

D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the

query predicates are different from or identical to the partitioning key.

Answer: D Section: (none)

QUESTION 262

In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)

A. partitioning recommendations B. statistics collection recommendations C. index creation recommendations D. materialized view recommendations E. materialized view log recommendations

Answer: ACDE Section: (none)

Explanation/Reference:

QUESTION 263

Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

A. The database must be running in ARCHIVELOG mode.

B. No special setup is required, and the feature is enabled by default.

C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the

DIAGNOSTIC_DEST initialization parameter.

D. The Enterprise Manager Support Workbench can be enabled only if the background process

manageability monitor (MMON) is configured.

E. Select the Enable option in the Oracle Configuration Manager Registration window during the

installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

Answer: E Section: (none)

QUESTION 264

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)

A. stored scripts in the recovery catalog B. backups that can be deleted from disk C. backup sets and image copies are obsolete

D. backups that do not have the AVAILABLE status in the RMAN repository

Answer: AD Section: (none)

QUESTION 265

View the Exhibit for the object interdependency diagram.

The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure. GET_DATA is called in the CHECK_DATA function. A new column PROD_QTY is added to the PRODUCTS table. How does this impact the status of the dependent objects?

A. All dependent objects remain valid.

B. Only the procedure and function become invalid and must be recompiled.

C. Only the view becomes invalid and gets automatically revalidated the next time it is used.

Answer: A Section: (none)

Explanation/Reference:

QUESTION 266

View the Exhibit to examine the parameters set for your database instance. You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:

SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, - max_latency=>50, -max_iops=>:max_iops, -max_mbps=>:max_mbps, - actual_latency=>:actual_latency);

Which statement describes the consequence?

D. Only the procedure and function become invalid and get automatically revalidated the next time they are called

A. The command produces an error.

B. The calibration process runs successfully and populates all the bind variables. C. The calibration process runs successfully but the latency time is not computed. D. The calibration process runs successfully but only the latency time is computed.

Answer: A

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