Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 601:

  Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?

  A. alter tablespace DAVE_TBS backup mode;
  B. alter tablespace DAVE_TBS start backup;
  C. alter tablespace DAVE_TBS begin backup;
  D. alter tablespace DAVE_TBS backup begin;
  E. alter tablespace DAVE_TBS backup;
  C. alter tablespace DAVE_TBS begin backup;

• Question 602:

  Which command is used to open the database after an incomplete recovery?

  A. alter database open
  B. alter database open repairlog
  C. alter database open resetlogs
  D. alter database open resetlog
  E. alter database resetlogs open
  C. alter database open resetlogs

• Question 603:

  Which three statements are true regarding persistent lightweight jobs? (Choose three.)

  A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
  B. The user cannot set privileges on persistent lightweight jobs.
  C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
  D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
  E. The use of a template is mandatory to create persistent lightweight jobs.
  B. The user cannot set privileges on persistent lightweight jobs.
  C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
  E. The use of a template is mandatory to create persistent lightweight jobs.

• Question 604:

  Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

  A. It detects changes in SQL execution plans.
  B. It produces results that can be used to create the SQL plan baseline.
  C. The importance of SQL statements is based on the size of the objects accessed.
  D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
  E. It shows only the overall impact on workload and not the net SQL impact on workload.
  A. It detects changes in SQL execution plans.
  B. It produces results that can be used to create the SQL plan baseline.
  D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

• Question 605:

  In what order would you execute the following steps to create a recovery catalog?

  a.

  Issue the create catalog command.

  b.

  Create the recovery-catalog database.

  c.

  Create the recovery-catalog user.

  d.

  Grant the recovery_catalog_owner privilege to the recovery-catalog user.

  e.

  Issue the register database command from the target database.

  A. a, b, c, d, e
  B. b, a, d, c, e
  C. b, c, d, a, e
  D. b, c, d, e, a
  E. b, d, c, a, e
  C. b, c, d, a, e

• Question 606:

  Why would you execute the report obsolete command?

  A. To list all backups that were no longer available for restore operations
  B. To list all backups that had aged beyond the RMAN retention criteria
  C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
  D. To list all datafiles that are no longer part of the database and thus do not need to be backed up
  E. To list all archived redo logs that are no longer needed for any database recovery
  B. To list all backups that had aged beyond the RMAN retention criteria

• Question 607:

  In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)

  A. when one or more file directory paths are accidentally deleted from an ASM disk group
  B. when one of the disks in a disk group is accidentally unplugged
  C. when the data file on an ASM disk group gets corrupted
  D. when one or more disks in an ASM disk group are lost
  A. when one or more file directory paths are accidentally deleted from an ASM disk group
  D. when one or more disks in an ASM disk group are lost

• Question 608:

  While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

  A. The plan baselines can be evolved over time to produce better performance.
  B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
  C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
  D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
  A. The plan baselines can be evolved over time to produce better performance.
  C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.

• Question 609:

  Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

  A. You can add or remove the trace files to the package.
  B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
  C. You can add SQL test cases to the incident package.
  D. You cannot create an incremental incident package when the physical files are purged from the ADR.
  A. You can add or remove the trace files to the package.
  B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
  C. You can add SQL test cases to the incident package.

• Question 610:

  You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:

  SQL> @utlu111i.sql

  Which statement about the execution of this script is true?

  A. It must be executed from the Oracle Database 11g environment.
  B. It must be executed only after the SYSAUX tablespace has been created.
  C. It must be executed from the environment of the database that is being upgraded.
  D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
  E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
  C. It must be executed from the environment of the database that is being upgraded.