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

QUESTION 201

Examine the following PL/SQL block:

SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report); END;

Which statement describes the effect of the execution of the above PL/SQL block?

A. The plan baselines are verified with the SQL profiles.

B. All fixed plan baselines are converted into nonfixed plan baselines. C. All the nonaccepted SQL profiles are accepted into the plan baseline.

D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

Answer: D Section: (none)

QUESTION 202

In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It consumes more memory compared with conventional patching.

B. It can be installed and uninstalled via OPatch unlike conventional patching. C. It takes more time to install or uninstall compared with conventional patching. D. It does not require down time to apply or remove unlike conventional patching. E. It is not persistent across instance startup and shutdown unlike conventional patching.

Answer: AD Section: (none)

Explanation/Reference:

QUESTION 203

Which statement about the enabling of table compression in Oracle Database 11g is true?

A. Compression can be enabled at the table, tablespace, or partition level for direct loads only. B. Compression can be enabled only at the table level for both direct loads and conventional DML. C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only. D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and

conventional DML.

Answer: D Section: (none)

QUESTION 204

You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?

A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE. B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE. C. Use compression when performing tape backups. D. Configure multiple SBT channels.

Answer: B Section: (none)

QUESTION 205

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?

A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as

SGA_MAX_SIZE.

B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the

SGA and 40 percent to the PGA.

C. The database instance starts, but Automatic Memory Management is disabled.

D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or

SGA_TARGET parameter.

Answer: B Section: (none)

QUESTION 206

Which statements are true regarding the Query Result Cache? (Choose all that apply.)

A. It can be set at the system, session, or table level.

B. It is used only across statements in the same session.

C. It can store the results from normal as well as flashback queries.

D. It can store the results of queries based on normal, temporary, and dictionary tables.

Answer: AC Section: (none)

Explanation/Reference:

QUESTION 207

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)

A. Every SQL statement in the STS is considered only once for execution.

B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution

statistics.

C. The execution plan and execution statistics are computed for each SQL statement in the STS. D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.

Answer: AC Section: (none)

QUESTION 208

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level? (Choose two.)

A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement B. issuing the ALTER SESSION ENABLE RESUMABLE; statement

C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

Answer: CD Section: (none)

QUESTION 209

You executed the following commands:

SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false'); SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

A. The statistics are stored in the pending statistics table in the data dictionary. B. The statistics are treated as the current statistics by the optimizer for all sessions.

C. The statistics are treated as the current statistics by the optimizer for the current sessions only. D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Answer: A Section: (none)

QUESTION 210

The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?

A. to prevent the creation of an excessive number of scheduler job classes

B. to allow the Automated Maintenance Tasks to use system resources without any restriction

C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

Answer: D Section: (none)

Explanation/Reference:

QUESTION 211

You want to disable resumable space allocation for all sessions.

Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions? A. 0 B. 10 C. 100 D. NULL

Answer: A Section: (none)

QUESTION 212

Note the following parameters settings in your database:

SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M

You issued the following command to increase the value of DB_8K_CACHE_SIZE:

SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

What would happen?

A. It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically B. It will be successful only if the memory is available from the auto tuned components

C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET D. It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

Answer: D Section: (none)

QUESTION 213

View the Exhibit to examine the error during the database startup.

You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

RMAN> REPAIR FAILURE;

Which statement describes the consequence of the command?

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