首先申明，如果分不够可以另开贴给分（总上限1000分以内，避免破产哈），只要求能帮偶解释明白即可，偶现在糊了
SG书上第四章的复习题：
6. Which of the following methods should you use for creating a control file(choose all that apply)
a, Dump the control file information to a trace file.
b, Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
c, Use the CREATE CONTROLFILE command
d, None of the above.
给出的答案是 AB
偶咋觉得 BC 比较恰当, confusing -_-
7. What are the two cases defined in the backup control file?
a, ALTER DATABASE OPEN
b, ALTER DATABASE OPEN RESETLOGS
c, ALTER DATABASE OPEN NORESETLOGS
d, ALTER DATABASE OPEN NOREST
给出的答案是 BC
偶觉得咋是 AB，确实trace file 中控制文件的生成脚本有两份，一份是resetlogs的，适用于incomplete recovery;一份是noresetlogs的，适用于完全恢复，可是alter database open 和LTER DATABASE OPEN NORESETLOGS 有什么区别的，哪位大大能举个实际例子说明一下，要是哪位大大能把alter database open, noresetlog, resetlogs, database incarnation 都放一块讲讲多好，顺便再说说数据库的跨resetlogs恢复（以上要求可以另外给分）
8. Which files need to be available and in the marching location of the ASCII control file in order to rebuild the control file? (Choose all that apply)
a, Server file, PFILE, or SPFILE
b, Datafiles
c, Control files
d, Redo files
给出的答案是 AB
偶很困惑为啥有A，B是肯定需要的，CD则是需要被重建的，为啥A也需要
------解决方案--------------------------------------------------------
关注!
晚了,先休息,明天再仔细看看!
------解决方案--------------------------------------------------------
虽然是在最顶上了,我还是帮顶.
------解决方案--------------------------------------------------------
期待高手，关注ing
------解决方案--------------------------------------------------------
6. Which of the following methods should you use for creating a control file(choose all that apply)
a, Dump the control file information to a trace file.
b, Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
c, Use the CREATE CONTROLFILE command
d, None of the above.
答案AB没问题,说的是同一个事情,注意审题,should you use for creating
8. Which files need to be available and in the marching location of the ASCII control file in order to rebuild the control file? (Choose all that apply)
a, Server file, PFILE, or SPFILE
b, Datafiles
c, Control files
d, Redo files
选A可能是考虑了控制文件的存储位置吧
------解决方案--------------------------------------------------------
6. Which of the following methods should you use for creating a control file(choose all that apply)
a, Dump the control file information to a trace file.
b, Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command