试题详情
- 单项选择题 You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()
A、Start the instance and open the database, instance recovery automatically recovers control files
B、Create a file based on the contents of the trace file and save it to the control file locations and start the database
C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
- D
关注下方微信公众号,在线模考后查看
热门试题
- Which options would
- Which of the followi
- Which three statemen
- You are
- Given: What is
- 假设需要删除数据库中的CUSTOMER表
- Which three statemen
- Inyourdatabase,thefl
- If you l
- TheINV_HISTORYtablei
- You are
- You have enabled th
- Which of
- When an
- You observe
- Examinethesectionoft
- Which two statements
- Evaluate this SQL s
- SQ L*Loader
- You need to calculat