1. Locks placed by command are called ________ . A. implicit locks B. explicit locks C. exclusive locks D. shared locks Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
2. Which of the following locks the item from change but not from read? A. Implicit lock B. Explicit lock C. Exclusive lock D. Shared lock Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option D No explanation is given for this question Let's Discuss on Board
3. Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read? A. Nonrepeatable read B. Phantom read C. Dirty read D. Consistent read Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
4. A transaction for which all committed changes are permanent is called: A. atomic. B. consistent. C. isolated. D. durable. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option D No explanation is given for this question Let's Discuss on Board 5. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. A. Read committed B. Read uncommitted C. Repeatable read D. Serializable Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board 1 2 3 4 5 6 7 8
4. A transaction for which all committed changes are permanent is called: A. atomic. B. consistent. C. isolated. D. durable. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option D No explanation is given for this question Let's Discuss on Board
5. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed. A. Read committed B. Read uncommitted C. Repeatable read D. Serializable Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
