Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 1:

  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

• Question 2:

  How many individual archive-log destination directories are supported by Oracle Database11g?

  A. 7
  B. 1
  C. 10
  D. 11
  E. 21
  C. 10

• Question 3:

  View the Exhibit for the object interdependency diagram.

  The PRODUCTS table is used to create the PRODCAT_VW view.

  PRODCAT_VW is used in the GET_DATA procedure.

  GET_DATA is called in the CHECK_DATA function.

  A new column PROD_QTY is added to the PRODUCTS table.

  How does this impact the status of the dependent objects? Exhibit:

  

  A. All dependent objects remain valid.
  B. Only the procedure and function become invalid and must be recompiled.
  C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
  D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.
  A. All dependent objects remain valid.

• Question 4:

  Your archive-log destination directory runs out of space. What is the impact of this on the database?

  A. None. The database will switch over to the stand-by archive-log destination directory.
  B. A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
  C. The database will shut down, and will not restart until you correct the out-of-space situation.
  D. The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally.
  E. Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-ofspace condition is corrected.
  E. Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-ofspace condition is corrected.

• Question 5:

  If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

  A. The alter database archivelog command will fail.
  B. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
  C. The alter database archivelog command will succeed.
  D. The alter database archivelog command will ask if you want to make the database consistent first.
  E. There is no alter database archivelog command. The correct command is alter database alterlogging.
  A. The alter database archivelog command will fail.

• Question 6:

  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 7:

  Archived redo logs can be copied to more than one destination by Oracle.

  A. True
  B. False
  A. True

• Question 8:

  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 9:

  Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?

  A. Yes, if the database is in ARCHIVELOG mode.
  B. Yes, if the database is in NOARCHIVELOG mode.
  C. No, the backup is not usable in any way.
  D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.
  C. No, the backup is not usable in any way.

• Question 10:

  Which is the correct command to put the database in ARCHIVELOG mode?

  A. alter database archivelog
  B. alter system enable archivelog mode
  C. alter database enable archive
  D. alter database archivelog enable
  E. None of the above
  A. alter database archivelog