Oracle Database 11g: New Features for Administrators

QUESTION NO: 1
You are managing an Oracle Database 11 g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk-l -d DATA
Which statement is true regarding the outcome of this command?

A. The command succeeds and retrieves information by scanning the disk headers based on an ASMJDISKSTRING value. B. The command produces an error because the ASM instance is down. C. The command succeeds but it shows only the status of the ASM instance. D. The command succeeds but it retrieves only the disk names.

Correct Answer: A

QUESTION NO: 2
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

A. Create a repeating baseline template. B. Create and populate a SQL Tuning Set from the AWR on every Monday. C. Insert a finding directive for future ADDM tasks. D. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

Correct Answer: A

QUESTION NO: 3
Which two statements about workload capture and replay operations are true? (Choose two.)

A. The clients must be created manually on the test machines to perform more realistic testing. B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay. C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload. D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

Correct Answer: C,D

QUESTION NO: 4
View the Exhibit to examine the Automatic SQL Tuning result details.

Which action would you suggest for the selected SQL statement in the Exhibit?

A. Accept the recommended SQL profile. B. Run the Access Advisor for the SQL statement. C. Run the Segment Advisor for recommendations. D. Collect statistics for the related objects.

Correct Answer: B

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

A. Diagnose and repair a data file corruption online. B. Diagnose and repair a data file corruption offline. C. Diagnose and repair failures on a standby database. D. Recover from failures in the Real Application Cluster (RAC) environment.

Correct Answer: C,D

QUESTION NO: 6
View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

What is the reason for this error?

A. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command. B. Another repair session is running concurrently. C. There are new failures recorded in the Automatic Diagnostic Repository (ADR). D. The failure ID has not been mentioned in the command for data file 5.

Correct Answer: B

QUESTION NO: 7
Following is the list of locations in random order where oranfstab can be placed.
1 ./etc/mtab 2 .$ORACLE_HOME/dbs/oranfstab 3 ./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?

A. 1,2,3 B. 1,3,2 C. 3,2, 1 D. 2,3, 1

Correct Answer: D

QUESTION NO: 8
Examine the following values of the Initialization parameters In the database having the SID ORCL:
BACKGROUNDJDUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01 /app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?

A. $ORACLE_HOME/bdump B. /u01/app/oracle/product/11.1.0/db_1 C. /u01/app/oracle D. $ORACLE_HOME/log

Correct Answer: C

QUESTION NO: 9
Evaluate the following code:
SQL>VARIABLE task_name VARCHAR2(255);
SQL>VARIABLE sql_stmt VARCHAR2(4000);
SQL>BEGIN
:sql_stmt := 'SELECT COUNTO FROM customers
WHERE cust_state_province ="CA"; :task_name := 'MY_QUICKTUNE_TASK';
DBMS_ADVISOR .QUICK_TUNE(DBMS_ADVISOR .SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
END;
What is the outcome of this block of code?

A. It produces an error because the SQL Tuning Set has not been created. B. It creates a task and workload but does not execute the task. C. It creates a task and workload, and executes the task. D. It produces an error because a template has not been created.

Correct Answer: C

Oracle Database 11g: New Features for Administrators - 1Z0-050 Exam Questions