Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 381:

  Which of the following parameters defines the location where Oracle should create archived redo logs?

  A. LOG_ARCHIVE_1
  B. LOG_DESTINATION_1
  C. LOG_ARCHIVED_DESTINATION_1
  D. LOG_ARCHIVE_DEST_1
  E. LOG_ARCHIVE_SOURCE_1
  D. LOG_ARCHIVE_DEST_1

• Question 382:

  The _______ writes the Flashback Database logs in the flash recovery area.

  A. FLSH
  B. FLDB
  C. RVWR
  D. RVRW
  E. FBDA
  C. RVWR

• Question 383:

  What will be the result of the following configuration?

  Log_archive_dest_1 = 'location=c:\oracle\arch\mydb' Log_archive_dest_2 = 'location=z:\oracle\arch\mydb'

  A. An error will occur during database startup because the second parameter is not valid.
  B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
  C. Archived redo logs will be created in two different locations by the ARCH process.
  D. Archived redo logs will be created in two different locations by the LGWR process.
  E. Neither parameter setting is valid, so the database will not start up.
  C. Archived redo logs will be created in two different locations by the ARCH process.

• Question 384:

  Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

  A. ADR diagnostic files
  B. all the optimizer statistics
  C. initialization parameter settings
  D. PL/SQL functions, procedures, and packages
  E. the table and index definitions and actual data
  B. all the optimizer statistics
  C. initialization parameter settings
  D. PL/SQL functions, procedures, and packages

• Question 385:

  Which dynamic view displays the status of block-change tracking?

  A. V$BLOCK_CHANGE
  B. V$BLOCK_CHANGE_TRACKING
  C. V$BLOCKCHANGE
  D. V$BLOCK_TRACKING
  B. V$BLOCK_CHANGE_TRACKING

• Question 386:

  When you create a backup control file, where is the resulting file written to?

  A. The database user dump destination directory
  B. The database diagnostic destination directory
  C. To $ORACLE_HOME/rdbms
  D. To $ORACLE_HOME/admin
  E. To the directory and filename you specify in the command
  E. To the directory and filename you specify in the command

• Question 387:

  RMAN provides more granular catalog security through which feature?

  A. Virtual private database
  B. Virtual private catalog
  C. RMAN virtual database
  D. RMAN secure catalog
  E. Oracle Database Vault
  B. Virtual private catalog

• Question 388:

  After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?

  A. Opening the database in RESTRICTED mode
  B. Opening the database with the RESETLOGS option
  C. Setting a new DBID for the newly restored database
  D. Restoring the server parameter file (SPFILE) to the new host
  B. Opening the database with the RESETLOGS option

• Question 389:

  You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:

  ALTER TABLE employees SHRINK SPACE CASCADE;

  Which statement is correct in this scenario?

  A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.
  B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
  C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
  D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
  C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

• Question 390:

  Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all that apply.)

  A. To check that the obsolete backups are deleted from the repository records and from the disk.
  B. To update the RMAN repository if you delete archived redo logs with operating system commands.
  C. To update outdated information about backups that disappeared from disk or tape or became corrupted and inaccessible.
  D. To synchronize the actual files on disk or in the media management catalog with the RMAN repository for which the backup was not taken using RMAN.
  B. To update the RMAN repository if you delete archived redo logs with operating system commands.
  C. To update outdated information about backups that disappeared from disk or tape or became corrupted and inaccessible.