DBMS QUIZ on UNIT IV

Which of the following is not a recovery technique?

• Deferred update

• Immediate update

• Two-phase commit

• Recovery management

Checkpoints are a part of

• Recovery measures

• Security measures

• Concurrency measures

• Authorization measures

....... deals with soft errors, such as power failures.

• system recovery

• media recovery

• database recovery

• failure recovery

........... is an essential part of any backup system.

• Filter

• Recovery

• Security

• Scalability

Media recovery deals with ...........

• disk errors

• hard errors

• system errors

• power failures

For a backup/restore system, ............. is a prerequisite for service in a enterprise.

• Filter

• Recovery

• Security

• Scalability

Failure recovery and media recovery fall under ........

• transaction recovery

• database recovery

• system recovery

• value recovery

The .......... consists of the various applications and database that play a role in a backup and recovery strategy.

• Recovery Manager environment

• Recovery Manager suit

• Recovery Manager file

• Recovery Manager database

In which the database can be restored up to the last consistent state after the system failure?

• Backup

• Recovery

• Both

• None

A ........... is a block of Recovery Manager(RMAN)job commands that is stored in the recovery catalogue.

• recovery procedure

• recovery block

• stored block

• stored script