Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
Correct Answer: A. a unique increasing identifier used to order log records and relate pages to logs
Explanation:
This statement is correct because log sequence number means that a unique increasing identifier used to order log records and relate pages to logs.
Choose an option to check your answer.
Correct Answer: B. a unique increasing identifier used to order log records and relate pages to logs
Explanation:
log sequence number is used in Advanced DBMS because a unique increasing identifier used to order log records and relate pages to logs.
Choose an option to check your answer.
Correct Answer: D. a unique increasing identifier used to order log records and relate pages to logs
Explanation:
The correct answer explains log sequence number in the context of Recovery.
Choose an option to check your answer.
Correct Answer: C. a recovery technique that keeps old pages unchanged and switches page tables at commit
Explanation:
This statement is correct because shadow paging means that a recovery technique that keeps old pages unchanged and switches page tables at commit.
Choose an option to check your answer.
Correct Answer: B. a recovery technique that keeps old pages unchanged and switches page tables at commit
Explanation:
shadow paging is used in Advanced DBMS because a recovery technique that keeps old pages unchanged and switches page tables at commit.
Choose an option to check your answer.
Correct Answer: B. a recovery technique that keeps old pages unchanged and switches page tables at commit
Explanation:
The correct answer explains shadow paging in the context of Recovery.
Choose an option to check your answer.
Correct Answer: A. a recovery algorithm based on analysis, redo, and undo phases
Explanation:
This statement is correct because ARIES recovery means that a recovery algorithm based on analysis, redo, and undo phases.
Choose an option to check your answer.
Correct Answer: D. a recovery algorithm based on analysis, redo, and undo phases
Explanation:
ARIES recovery is used in Advanced DBMS because a recovery algorithm based on analysis, redo, and undo phases.
Choose an option to check your answer.
Correct Answer: A. a recovery algorithm based on analysis, redo, and undo phases
Explanation:
The correct answer explains ARIES recovery in the context of Recovery.
Choose an option to check your answer.
Correct Answer: D. rolls back effects of incomplete or aborted transactions
Explanation:
This statement is correct because undo operation means that rolls back effects of incomplete or aborted transactions.
Choose an option to check your answer.
Correct Answer: A. rolls back effects of incomplete or aborted transactions
Explanation:
undo operation is used in Advanced DBMS because rolls back effects of incomplete or aborted transactions.
Choose an option to check your answer.
Correct Answer: D. rolls back effects of incomplete or aborted transactions
Explanation:
The correct answer explains undo operation in the context of Recovery.
