Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 11:

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

• Question 12:

  You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command:

  RMAN>CHANGE BACKUPSET 231 NOKEEP;

  What is the implication of this command?

  A. The backup is deleted.
  B. The backup is marked unavailable.
  C. The backup overrides the backup retention policy.
  D. the backup becomes eligible for deletion according to the existing retention policy
  D. the backup becomes eligible for deletion according to the existing retention policy

• Question 13:

  Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

  A. Supplemental log must be enabled.
  B. Supplemental log must be enabled for the primary key
  C. Undo retention guarantee for the database must be configured.
  D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
  A. Supplemental log must be enabled.
  B. Supplemental log must be enabled for the primary key
  D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

• Question 14:

  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 creates a task and workload, and executes the task.
  B. It creates a task and workload but does not execute the task.
  C. It produces an error because a template has not been created.
  D. It produces an error because the SQL Tuning Set has not been created.
  A. It creates a task and workload, and executes the task.

• Question 15:

  View the Exhibit.

  

  Examine the following command that is executed for the TRANSPORT table in the SH schema:

  SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS(lsh\ 'customers^be1, '(countryjd, cust_state_province)') FROM dual;

  Which statement describes the significance of this command?

  A. It collects statistics into the pending area in the data dictionary.
  B. It creates a virtual hidden column in the CUSTOMERSjDBE table.
  C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
  D. It creates a histogram to hold skewed information about the data in the columns.
  B. It creates a virtual hidden column in the CUSTOMERSjDBE table.

• Question 16:

  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).
  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.

• Question 17:

  What are the recommendations for Oracle Database 11 g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

  A. ORACLE_BASE should be set explicitly.
  B. An Oracle base should have only one Oracle home created in it.
  C. Flash recovery area and data file location should be on separate disks.
  D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
  A. ORACLE_BASE should be set explicitly.
  C. Flash recovery area and data file location should be on separate disks.
  D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

• Question 18:

  You are managing an Oracle Database 11 g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)

  A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
  B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
  C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
  D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
  A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
  B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
  D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

• Question 19:

  You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11 g:

  1.

  Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.

  2.

  Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities?

  A. to minimize plan regression due to the use of a new optimizer version
  B. to completely avoid the use of new plans generated by a new optimizer version
  C. to prevent plan capturing when the SQL statement is executed after the database upgrade
  D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
  A. to minimize plan regression due to the use of a new optimizer version

• Question 20:

  Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

  A. It returns space usage of only BasicFile LOB chunks.
  B. It returns space usage of only SecureFile LOB chunks.
  C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
  D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
  B. It returns space usage of only SecureFile LOB chunks.