61.Given below is a list of scenarios: 1) A user terminates his session abnormally. 2) The connectio

来源:互联网 发布:ltp1端口 编辑:程序博客网 时间:2024/05/21 22:34
61.Given below is a list of scenarios:
1) A user terminates his session abnormally.
2) The connection between the server and the client application terminates because of a network failure.
3) A schema is accidentally dropped.
4) The tablespace is accidentally dropped from the database.
5) The hard disk gets corrupted and the data files in the disk are lost.
6) The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
A.4 and 5
B.1, 3, and 6
C.4, 5, and 6
D.3, 4, and 5
E.1, 2, and 6
答案:D
1:用户会话被kill,这个是不需要recovery的
2:这个和A一样,不需要recovery
3: schema这个删除了,是需要进行恢复的
4:tablespace删除了,也是需要进行恢复的
5:磁盘都坏了数据文件也给丢失了,这个肯定的恢复的
6:异常关机,这个也需要恢复的,但是它是后台进程smon自动完成的,不需要dba干预
因此选择D
0 0