Discussion
Home ‣ Database ‣ Managing Multiuser Databases Comments
- Question
The size of a lock is called:
Options- A. implicit lock.
- B. lock granularity.
- C. exclusive lock.
- D. shared lock.
- Correct Answer
- lock granularity.
- 1. Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
- 2. A transaction in which either all of the database actions occur or none of them do is called:
Options- A. atomic.
- B. consistent.
- C. isolated.
- D. durable. Discuss
- 3. Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
- 4. Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Options- A. Forward only
- B. Static
- C. Keyset
- D. Dynamic Discuss
- 5. Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
- 6. Locks placed by the DBMS are called ________ .
Options- A. implicit locks
- B. explicit locks
- C. exclusive locks
- D. shared locks Discuss
- 7. Which of the following refers to a cursor type where changes of any type and from any source are visible?
Options- A. Forward only
- B. Static
- C. Keyset
- D. Dynamic Discuss
- 8. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
- 9. 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?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
- 10. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Options- A. Read committed
- B. Read uncommitted
- C. Repeatable read
- D. Serializable Discuss
Managing Multiuser Databases problems
Search Results
Correct Answer: Serializable
Correct Answer: atomic.
Correct Answer: Repeatable read
Correct Answer: Keyset
Correct Answer: Read uncommitted
Correct Answer: implicit locks
Correct Answer: Dynamic
Correct Answer: Dirty read
Correct Answer: Phantom read
Correct Answer: Read committed
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.