Which scenarios require DBA intervention to perform recovery?

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?

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.
1, 3, and 6

B.
4, 5, and 6

C.
3, 4, and 5

D.
1, 2, and 6



Leave a Reply 2

Your email address will not be published. Required fields are marked *


vjawkar

vjawkar

why not 6?

vjawkar

vjawkar

oh ok got it.. thats instance recovery automatically does by oracle instance.. DBA does not need to do any recovery..:-)