Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 641:

  You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance:

  SQL> shutdown immediate;

  What is the result of executing this command?

  A. The ASM instance is shut down, but the other instances are still running.
  B. It results in an error because other database instances are connected to it.
  C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
  D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
  B. It results in an error because other database instances are connected to it.

• Question 642:

  Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

  A. Cursor cache
  B. Stored outline
  C. SQL Tuning Set
  D. Automatic Workload Repository (AWR) snapshots
  A. Cursor cache
  C. SQL Tuning Set

• Question 643:

  Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?

  A. The database must be in read-write mode.
  B. The database must have no external files.
  C. The database must open in read-only mode.
  D. The database must be mounted but not opened.
  C. The database must open in read-only mode.

• Question 644:

  You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value. Which three statements about resumable space allocation are true? (Choose three.)

  A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
  B. A resumable statement is suspended only if an out of space error occurs.
  C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
  D. A resumable statement can only be suspended and resumed once during the execution of the statement.
  E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
  A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
  C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
  E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

• Question 645:

  Why would you run the delete obsolete command? (Choose all that apply.)

  A. To remove missing backup set pieces physically from disk
  B. To remove metadata related to backup set pieces in the control file and the recovery catalog C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
  D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria
  E. To remove old versions of RMAN backups
  D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria

• Question 646:

  Choose the correct order to package and upload data for an incident to Oracle Support.

  A. Schedule, create new package, view manifest, view contents
  B. Create new package, view manifest, view contents, schedule
  C. Schedule, create new package, view contents, view manifest
  D. Create new package, view contents, view manifest, schedule
  E. None of the above.
  D. Create new package, view contents, view manifest, schedule

• Question 647:

  You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

  A. The archived redo log files will be overwritten.
  B. The archived redo log files are deleted automatically.
  C. The archived redo log files should be moved to some other location.
  D. The archived redo log files are still maintained because the file names are unique.
  D. The archived redo log files are still maintained because the file names are unique.

• Question 648:

  Which command is used to configure RMAN to perform a compressed backup for every backup executed?

  A. BACKUP AS COMPRESSED BACKUPSET DATABASE
  B. BACKUP AS COMPRESSED COPY OF DATABASE
  C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
  D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
  E. BACKUP DATABASE COMPRESS
  C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET

• Question 649:

  You can back up the RMAN recovery catalog with RMAN.

  A. True
  B. False
  A. True

• Question 650:

  As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?

  A. Shut down the database
  B. Clear the online redo log
  C. Back up the database
  D. Checkpoint the database
  E. Call Oracle support
  D. Checkpoint the database