Problem Statement

This set contains seven independent multiple-choice questions from the DBMS 2.0 section of the assessment. Each question is self-contained: read the stem, study any data shown, and pick the single best option. How your answer is graded: your program reads no input. Print the option number you chose for each of the seven questions, one per line, in order Q1 … Q7. Q1. In DBMS, which of the following conditions can cause the problem given below? Problem: the Uncommitted Dependency or Dirty Read problem occurs when concurrent transactions run in an uncontrolled environment. It occurs when a transaction is allowed to retrieve or update a record that has been updated by another transaction. Here, the record does not get committed by that other transaction. It occurs when two transactions that access the same database items have their operations interleaved in a way that makes the value of some database items incorrect. It occurs when a transaction reads several values, but a second tr