Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 231:

  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/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1' DB_RECOVERY_FILE_DEST = '/u01/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.

• Question 232:

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

  Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 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 233:

  The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)

  A. WHERE clause
  B. ORDER BY clause
  C. BETWEEN clause
  D. NLSSORT function
  E. NLS_SORT function
  A. WHERE clause
  D. NLSSORT function

• Question 234:

  Which of the following tasks is not performed by the job coordinator?

  A. Update job log when a job completes
  B. Spawn and remove job slaves
  C. Write/read job info to/from memory cache
  D. Query job table
  E. Pass job information to job slaves
  A. Update job log when a job completes

• Question 235:

  Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

  A. The database must be running in ARCHIVELOG mode.
  B. No special setup is required, and the feature is enabled by default.
  C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
  D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
  E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
  E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

• Question 236:

  You have created a script in the recovery catalog called backup_database.

  Which of the following commands would successfully execute that script?

  

  A. B. C. D. E.
  D

• Question 237:

  What is the danger associated with stopping a running job by using the STOP_JOB procedure?

  A. The job will need to be reenabled before it will execute again.
  B. The job may hold locks on objects referenced within it.
  C. All jobs within the job group will also be stopped.
  D. The job may leave data in an inconsistent state.
  E. There is no danger in using the STOP_JOB procedure.
  D. The job may leave data in an inconsistent state.

• Question 238:

  Evaluate the following function code: Which statement is true regarding the above function?

  

  A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
  B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.
  C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
  D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
  A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

• Question 239:

  You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re- create the missing disk group by using the ASMCMD md_restore command.

  Which of these methods would you use to achieve this? (Choose all that apply.)

  A. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.
  B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
  C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
  D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
  B. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
  C. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
  D. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.

• Question 240:

  You execute the following FLASHBACK TABLE command:

  SQL> FLASHBACK TABLE emp TO TIMESTAMP TO_TIMESTAMP('2008-01-04 11:00:00','YYYY-MMDD HH24:MI:SS');

  Which two statements are correct? (Choose two.)

  A. The emp table that was dropped by mistake earlier is restored.
  B. The FLASHBACK TABLE statement is executed as a single transaction.
  C. The FLASHBACK TABLE statement does not maintain existing indexes on the emp table.
  D. The changes made to the emp table since the specified time are undone if no constraint is violated during flashback.
  B. The FLASHBACK TABLE statement is executed as a single transaction.
  D. The changes made to the emp table since the specified time are undone if no constraint is violated during flashback.