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

Section: (none)

QUESTION 267

You plan to control the sessions performing a huge number of I/O operations. Your

requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?

A. Set a threshold for the default system-defined moving window baseline. B. Add directives to the Automatic Database Diagnostic Monitor (ADDM). C. Modify the profile for the targeted users for which control needs to be imposed.

D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

Answer: D Section: (none)

Explanation/Reference:

QUESTION 268

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

A. Option A B. Option B C. Option C D. Option B

Answer: A Section: (none)

QUESTION 269

Examine the following set of RMAN commands:

RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ?/u02 /backup/ %U' \RMAN> RUN (

ALLOCATE CHANNEL Chi DEVICE TYPE DISK;

EXECUTE SCRIPT full_backup; )

Which statement is true when the RMAN RUN block Is executed?

A. The execution of the script fails because multiple channels cannot coexist. B. The script is executed and both the channels are used for the script execution. C. The new channel, CHI, is Ignored because a channel has been configured already.

D. ration parameter DCI is overridden because a new channel is allocated in RMAN RUN block.

Answer: D Section: (none)

Explanation/Reference:

QUESTION 270

Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

A. Segment Advisor B. SQL Access Advisor C. Optimizer statistics gathering D. Automatic SQL Tuning Advisor

E. Automatic Database Diagnostics Monitor

Answer: ACD Section: (none)

QUESTION 271

Examine the output of the query that you executed to list the objects in the recycle bin:

You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:

SQL> PURGE TABLE sales_tab;

What would be the outcome of this command?

A. All three tables in the recycle bin are purged B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin D. Only the table with the latest DROPSCN is purged

Answer: B Section: (none)

Explanation/Reference:

QUESTION 272

You issue the following RMAN command to set a retention policy on a database:

RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

What will be the outcome of issuing this command?

A. After two days, a backup will be marked obsolete B. After two days, a backup will be deleted from the media

C. If the RMAN repository has records of two or more recent backups of a file, then older

backups will be deleted from the media.

D. If the RMAN repository has records of two or more recent backups of a file, then older

backups will be marked obsolete.

Answer: D Section: (none)

QUESTION 273

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

A. It does not allow you to change the moving window size.

B. Adaptive threshold functionalities use it by default to compute statistics.

C. It is created by default with the window size being equal to the AWR retention time.

D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

Answer: BC

Section: (none)

QUESTION 274

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

A. statistics recommendations B. SQL profile recommendations C. index-related recommendations D. restructuring of SQL recommendations

Answer: B Section: (none)

QUESTION 275

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.

Which three statements about resumable space allocation are true? (Choose three.)

A. Even with resumable space allocation enabled for your database, you can disable resumable

space allocation for a single session.

B. A resumable statement is suspended only if an out of space error occurs.

C. When a resumable statement is suspended, the transaction that contains the statement is also suspended. D. A resumable statement can only be suspended and resumed once during the execution of the statement. E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are

suspended for a session.

Answer: ACE Section: (none)

Explanation/Reference:

QUESTION 276

The following command is executed to create the baseline template:

SQL> EXECUTE

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