Managing Multiuser Database Questions and Answers

Practice Mode
Showing 10 of 20 questions
Q11
Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
  • A Read committed
  • B Read uncommitted
  • C Repeatable read
  • D Serializable
Answer: Option D
Q12
A transaction in which either all of the database actions occur or none of them do is called:
  • A atomic.
  • B consistent.
  • C isolated.
  • D durable.
Answer: Option A
Q13
A cursor type in which the application can only move forward through the recordset is called:
  • A forward only.
  • B static.
  • C keyset.
  • D dynamic.
Answer: Option A
Q14
Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
  • A Nonrepeatable read
  • B Phantom read
  • C Dirty read
  • D Consistent read
Answer: Option C
Q15
Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
  • A Read committed
  • B Read uncommitted
  • C Repeatable read
  • D Serializable
Answer: Option B
Q16
Which of the following locks the item from access of any type?
  • A Implicit lock
  • B Explicit lock
  • C Exclusive lock
  • D Shared lock
Answer: Option C
Q17
The size of a lock is called:
  • A implicit lock.
  • B lock granularity.
  • C exclusive lock.
  • D shared lock.
Answer: Option B
Q18
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
  • A forward only.
  • B static.
  • C keyset.
  • D dynamic.
Answer: Option B
Q19
What is the overall responsibility of the DBA?
  • A Facilitate the development and use of the database
  • B Create and populate tables
  • C Development, operation, and maintenance of the database and its applications
  • D Both the first and third answers above are correct.
Answer: Option D
Q20
Locks placed by the DBMS are called ________ .
  • A implicit locks
  • B explicit locks
  • C exclusive locks
  • D shared locks
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test