Oracle Oracle Database Application Development 1Z0-053 Questions & Answers

• Question 1:

  What are the different logging modes available in Oracle Database 11g? (Choose two.)

  A. NOLOG mode

  B. NOARCHIVELOG mode

  C. LOGGING mode

  D. HOTDATABASE mode

  E. ARCHIVELOG mode

  Correct Answer: BE

• Question 2:

  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

  Correct Answer: A

• Question 3:

  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.

  Correct Answer: C

• Question 4:

  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

  Correct Answer: D

• Question 5:

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

  A. True

  B. False

  Correct Answer: A

• 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.

  Correct Answer: C

• Question 7:

  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.

  Correct Answer: A

  Before you change database to archivelog mode, you need to have a clean database shutdown.

• Question 8:

  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.

  Correct Answer: E

• Question 9:

  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.

  Correct Answer: A

• Question 10:

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

  A. 7

  B. 1

  C. 10

  D. 11

  E. 21

  Correct Answer: C