You back up your database, which is running in ARCHIVELOG mode, at regular intervals. On Oracle 1Z0-032 Exam Monday morning, you find that one of the data files is corrupted and the database administrator is recovering the file by executing the following command after restoring the file from a backup:

SQL> RECOVER AUTOMATIC datafile 8; What is the objective of using the AUTOMATIC option with the RECOVER command?

Question

You back up your database, which is running in ARCHIVELOG mode, at regular intervals. On Oracle 1Z0-032 Exam Monday morning, you find that one of the data files is corrupted and the database administrator is recovering the file by executing the following command after restoring the file from a backup:

SQL> RECOVER AUTOMATIC datafile 8; What is the objective of using the AUTOMATIC option with the RECOVER command?

Accepted Answer

A. to apply all required archived log files without prompting for confirmation

Answer

B. to allow the recovery process to determine the optimal thread number to recover the data file

Answer

C. to apply all required archived log files after confirmation, and then automatically open the database

Answer

D. to allow the recovery process to determine the log sequence number from where the recovery process is

You back up your database, which is running in ARCHIVELOG mode, at regular intervals. On Oracle 1Z0-032 Exam Monday morning, you find that one of the data files is corrupted and the database…

Question

Options

How the community answered

Community Discussion