Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 111:

  Which statement is true regarding virtual private catalogs?

  A. The virtual private catalog owner cannot create and modify the stored scripts.
  B. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
  C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
  D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
  D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

• Question 112:

  Your organization decided to upgrade the existing Oracle 10g database to Oracle 11 g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:

  SQL>@utlrp.sql

  What is the significance of executing this script?

  A. It performs parallel recompilation of only the stored PL/SQL code.
  B. It performs sequential recompilation of only the stored PL/SQL code.
  C. It performs parallel recompilation of any stored PL/SQL as well as Java code.
  D. It performs sequential recompilation of any stored PL/SQL as well as Java code.
  C. It performs parallel recompilation of any stored PL/SQL as well as Java code.

• Question 113:

  Examine the section of the Health Check report given below:

  DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') ----------------------------------------------------------------------- Run Name: HM_RUN_1061 Run Id: 1061 Check Name : Data Block Integrity Check Mode : REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time : 2007-05-12 22:11:20.835135 -07:00 Error Encountered: 0 Source Incident Id : 7418 Number of Incidents Created :0

  Which two statements are true regarding the Health Check report? (Choose two.)

  A. Health Check was performed manually.
  B. Health Check was performed to check the disk image block corruptions
  C. Health Check was performed to check interblock and intersegment corruption.
  D. Health Check was performed to verify the integrity of database files and report failures.
  E. Health Check was performed by the Health Monitor automatically in response to a critical error.
  A. Health Check was performed manually.
  B. Health Check was performed to check the disk image block corruptions

• Question 114:

  In which cases is reference partitioning effective in enhancing performance?

  A. It is effective only in partition pruning.
  B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
  C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
  D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
  D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

• Question 115:

  An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:

  SQL>CREATE INDEX ord_custname_ix ON orders(custname);

  The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to

  perform this test. Which is the most efficient method of performing this task?

  A. disabling the index
  B. making the index invisible
  C. making the index unusable
  D. using the MONITORING USAGE clause for the index
  B. making the index invisible

• Question 116:

  What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)

  A. It can recommend partitioning only on tables that have at least 10,000 rows.
  B. It cannot generate recommendations that support multiple workload queries.
  C. It can recommend only B-tree indexes and not bitmap or function-based indexes.
  D. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
  A. It can recommend partitioning only on tables that have at least 10,000 rows.
  D. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

• Question 117:

  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?

  A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
  B. Capture the plans from the previous version using STS and then load them into the stored outline.
  C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
  D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
  C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

• Question 118:

  Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

  A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
  B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
  C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
  D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
  B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
  D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

• Question 119:

  Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

  A. The database files are corrupted when the database is open
  B. The archived log files are missing for which backup is not available.
  C. The user has dropped an important table that needs to be recovered.
  D. You are not able to start up the database instance because the required database files are missing.
  A. The database files are corrupted when the database is open
  D. You are not able to start up the database instance because the required database files are missing.

• Question 120:

  The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:

  LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1 /archive1 LOG_ARCHIVE_DEST_2 = 'SERVICE = Stdb1 DB_RECOVERY_FILE_DEST = 7u01/oradata'

  Examine the following RMAN command issued to set the deletion policy for archived log files:

  RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;

  Which statement is true regarding what this command accomplishes?

  A. All archived redo log files backed up at least twice to tape are deleted.
  B. All archived redo log files backed up at least once to tape are eligible for deletion.
  C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
  D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
  D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.