053(五十四）

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 inthe 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?

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.

 

267、

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.

 

268、

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.RMAN> run
{
SET UNTIL TIME 'Nov 15 2007 11:00:00';
RESTORE DATABASE;
RECOVER DATABASE;
}
B.RMAN> run
{
SET UNTIL TIME 'Nov 15 2007 11:00:00';
RESTORE DATABASE;
RECOVER DATABASE USING BACKUP CONTROLFILE;
}
C.RMAN> run
{
RESTORE DATABASE;
RECOVER DATABASE UNTIL TIME 'Nov 15 2007 11:00:00';
}
D.RMAN> run
{
RESTORE TABLESPACE user_data;
RECOVER TABLESPACE user_data UNTIL TIME 'Nov 15 2007 11:00:00'; 
}

 

269、

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.

 

270、

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