Database - Managing Multiuser Databases

Exercise : Managing Multiuser Databases - General Questions
1.
Locks placed by command are called ________ .
implicit locks
explicit locks
exclusive locks
shared locks
Answer: Option
Explanation:
No answer description is available. Let's discuss.

2.
Which of the following locks the item from change but not from read?
Implicit lock
Explicit lock
Exclusive lock
Shared lock
Answer: Option
Explanation:
No answer description is available. Let's discuss.

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?
Nonrepeatable read
Phantom read
Dirty read
Consistent read
Answer: Option
Explanation:
No answer description is available. Let's discuss.

4.
A transaction for which all committed changes are permanent is called:
atomic.
consistent.
isolated.
durable.
Answer: Option
Explanation:
No answer description is available. Let's discuss.

5.
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Read committed
Read uncommitted
Repeatable read
Serializable
Answer: Option
Explanation:
No answer description is available. Let's discuss.