Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. ARIES uses a to identify log records, and stores it in database pages.
a. log sequence number
b. log number
c. lock number
d. sequence
Q. is used to minimize unnecessary redos during recovery.
a. dirty page table
b. page table
c. dirty redo
d. all of the mentioned
Q. scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.
a. fuzzy logic
b. checkpoints
c. fuzzy-checkpoint
d. logical checkpoint
Q. determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
a. analysis pass
b. redo pass
c. undo pass
d. none of the mentioned
Q. starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.
a. analysis pass
b. redo pass
c. undo pass
d. none of the mentioned
Q. rolls back all transactions that were incomplete at the time of crash.
a. analysis pass
b. redo pass
c. undo pass
d. none of the mentioned
Q. Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called
a. logical operation
b. redo operation
c. logical undo operation
d. undo operation
Q. Which of the following is used for undo operations alone?
a. logical logging
b. physical logging
c. physical log records
d. physical logging and physical log records
Q. Redo operations are performed exclusively using
a. logical logging
b. physical logging
c. physical log records
d. both physical logging and physical log records
Q. An operation is said to be if executing it several times in a row gives the same result as executing it once.
a. idempotent
b. changed
c. repetitive
d. all of the above
Q. For correct behaviour during recovery, undo and redo operation must be
a. commutative
b. associative
c. idempotent
d. distributive
Q. If are not obtained in undo operation it will cause problem in undo- phase.
a. higher-level lock
b. lower-level lock
c. read only lock
d. read write
Q. The remote backup site is sometimes also called the
a. primary site
b. secondary site
c. tertiary site
d. none of the mentioned
Q. The backup is taken by
a. erasing all previous records
b. entering the new records
c. sending all log records from primary site to the remote backup site
d. sending selected records from primary site to the remote backup site