Oracle
1Z0-032 · Question #16
1Z0-032 Question #16: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-032 to reveal the answer and full explanation for question #16. The question stem and answer options stay visible for context.
Question
While starting up the database on a Monday morning, you get the following error after the database is mounted: ORA-01157: cannot identify/lock data file 9 - see DBWR trace file ORA-01110: data file 9: '/u01/oracle/app/oradata/orcl/users01.dbf' On investigation, you find that the file system, u01, on the operating system is corrupted and you need to recover the data file to a new location. The database is running in ARCHIVELOG mode and the database was backed up on last Friday. You must ensure that the database is not accessible till the data file is recovered. Which two tasks must you have accomplished before applying the archived redo log files? (Choose two.)
Options
- Aupdate the control file by using the ALTER DATABASE RENAME FILE command
- Brestore the data file from the backup to the new location by using an operating system utility
- Crestore a backup control file and then issue the ALTER DATABASE RENAME FILE command
- Ddrop the data file and re-create it by using the ALTER DATABASE CREATE DATAFILE command
- Erecreate the control file by using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
Unlock 1Z0-032 to see the answer
You've previewed enough free 1Z0-032 questions. Unlock 1Z0-032 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.