Free Oracle 1Z0-050 Exam Dumps Questions & Answers

Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)
SQL>STARTUP UPGRADE

• A.  It allows only SYSDBA connections.
• B.  It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
• C.  It ensures that all job queues remain active during the upgrade process.
• D.  It enables all system triggers.

What are the advantages of variable extent size support for large ASM files? (Choose two.)

• A.  It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
• B.  It improves performance in the extended cluster configuration by reading from a local copy of an extent.
• C.  Fewer extent pointers are needed to describe the file and less memory is required to
  manage the extent maps in the shared pool.
• D.  This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

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 nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
• B.  All fixed plan baselines are converted into nonfixed plan baselines.
• C.  The plan baselines are verified with the SQL profiles.
• D.  All the nonaccepted SQL profiles are accepted into the plan baseline.

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

• A.  SQL statements that are part of the AWR baseline only
• B.  SQL statements that are part of the available SQL Tuning Set (STS) only
• C.  SQL statements that are available in the cursor cache and executed by a user other than SYS
• D.  SQL statements based on the AWR top SQL identification

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 and populate a SQL Tuning Set from the AWR on every Monday.
• B.  Create a repeating baseline template.
• C.  Insert a finding directive for future ADDM tasks.
• D.  Change the RETENTION setting for the AWR snapshots to 7 days on Monday.