Aspire's Library
A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations - NIMCET
Study Stuff for MCA Examinations - NIMCET
Previous Year Question (PYQs)
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a $2\times2\times2$ table as shown below.
Which of the DBMS component ensures that concurrent execution of multiple operations on the database results into a consistent database state?
| toothache | $\neg$toothache | |||
|---|---|---|---|---|
| catch | $\neg$catch | catch | $\neg$catch | |
| cavity | $0.108$ | $0.012$ | $0.072$ | $0.008$ |
| $\neg$cavity | $0.016$ | $0.064$ | $0.144$ | $0.576$ |
Solution
Concurrent execution means many transactions may execute at the same time.The transaction processing system controls concurrency and recovery.
It ensures that even with multiple transactions, the database remains in a consistent state.
Logs help in recovery, buffer manager manages memory pages, and file manager manages storage files.
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
Ask Your Question or Put Your Review.
