首先申明，如果分不够可以另开贴给分（总上限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
c, Use the CREATE CONTROLFILE command
d, None of the above.
我认为ABC都可以,为何不选C不解?我在看书时也看到过控制文件找不到时可以按数据文件和日志文件的路径新建控制文件
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
不明白
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
我认为不该选C,控制文件文件为了重建控制文件吗?理解过不去!
D可以不要,不一定要有日志文件才能重建控制文件,在备份与恢复数据库时,很多情况可以不要日志文件,或把日志离线就可以启动操作
可把日志文件删除后再重建,所以重建控制文件不一定需要用日志文件
这是我的一点点见解,不对请各位不吝指教
------解决方案--------------------------------------------------------
我说下第6个，当然我是菜鸟，错的可能很大
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.