052-219(新增70题2018)

You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally.

Which statement in this scenario is true?

A. The database crashes.

B. The DBA needs to re-create the file.

C. The file gets re-created automatically.

D. The file gets restored automatically from the last backup.

E. The DBA needs to perform a complete database recovery.

F. The DBA needs to perform an incomplete database recovery.

Answer: C

实验：

SQL> show parameter background_dump_dest;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace
--进入目录删除alert_orcl.log
alter tablespace test1 offline;
alter tablespace test1 online;
--alert_orcl.log自动生成了

Tue Mar 20 02:15:07 2018
alter tablespace test1 offline
Completed: alter tablespace test1 offline
alter tablespace test1 online
Completed: alter tablespace test1 online