Oracle Database 11g: New Features for Administrators - 1Z0-050 Exam Practice Test
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?
Correct Answer: B
Vote an answer
Which two prerequisites are needed for performing workload capture and replay? (Choose two.)
Correct Answer: C,D
Vote an answer
Which steps are mandatory to enable Direct NFS?
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11 .so_stub with libodm11 .so.
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11 .so_stub with libodm11 .so.
Correct Answer: B
Vote an answer
Examine the following PL/SQL block:
DECLARE
my_plans plsjnteger;
BEGIN
My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id =>
?9twu5t2dn5xd?;
END;
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
DECLARE
my_plans plsjnteger;
BEGIN
My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id =>
?9twu5t2dn5xd?;
END;
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
Correct Answer: D
Vote an answer
You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?
SQL>ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?
Correct Answer: D
Vote an answer
Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?
Correct Answer: D
Vote an answer
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose al that apply.)
Correct Answer: B,C,D,E
Vote an answer
Which statements are true regarding SecureFile LOBs? (Choose all that apply.)
Correct Answer: C,E
Vote an answer
Which statement describes the effect of table redefinition on the triggers attached to the table?
Correct Answer: C
Vote an answer
SQL> EXECUTE
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>
TO_TIMESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4l,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?
DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>
TO_TIMESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4l,
EXPIRATION=>NULL);
Which statement is true about the effect of the above command?
Correct Answer: B
Vote an answer
You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
Correct Answer: B
Vote an answer
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
Correct Answer: B,D
Vote an answer