Question

During recovery from a failure

(a) each pair of physical block is examined

(b) specified pair of physical block is examined

(c) first pair of physical block is examined

(d) none of the mentioned

This question was addressed to me in an online interview.

Query is from Tertiary Storage in chapter Storage and File Structures of Database Management

Answer 1

The correct choice is (a) each pair of physical block is examined

For explanation: Tertiary storage involves a robotic mechanism which will mount (insert) and dismount removable mass storage media into a storage device according to the system’s demands; this data is often copied to secondary storage before use.