Managing Multiuser Databases MCQ

Test your knowledge with important Managing Multiuser Databases MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Managing Multiuser Databases MCQs on Bissoy. Bissoy App

• An exclusive lock locks the item from change but not from read.
  ক

  True

  খ

  False
• A point of synchronization between the database and the transaction log is generally referred to as a stop point.
  ক

  True

  খ

  False
• A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.
  ক

  True

  খ

  False
• A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.
  ক

  True

  খ

  False
• The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
  ক

  True

  খ

  False
• Locks placed by command are implicit locks.
  ক

  True

  খ

  False
• Database administration refers to a function that applies to the entire organization.
  ক

  True

  খ

  False
• The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.
  ক

  True

  খ

  False
• The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.
  ক

  True

  খ

  False
• Two transactions that run concurrently and generate results that are consistent with the results that would have occurred if they had run separately are referred to as serializable transactions.
  ক

  True

  খ

  False
• In optimistic locking, the assumption is made that conflict will occur.
  ক

  True

  খ

  False
• Locks placed by the DBMS are explicit locks.
  ক

  True

  খ

  False
• When two transactions are being processed against the database at the same time they are termed concurrent transactions.
  ক

  True

  খ

  False
• The size of a lock is referred to as lock sizing.
  ক

  True

  খ

  False
• When one transaction reads a changed record that has not been committed to the database a filthy read occurs.
  ক

  True

  খ

  False
• An ACID transaction is one that is atomic, consistent isolated, and durable.
  ক

  True

  খ

  False
• A durable transaction is one in which all committed changes are permanent.
  ক

  True

  খ

  False
• The size of the lock is referred to as the lock granularity.
  ক

  True

  খ

  False
• The overall responsibility of the DBA is to facilitate the development and use of the database.
  ক

  True

  খ

  False
• Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.
  ক

  True

  খ

  False
• Locks placed by the DBMS are called ________ .
  ক

  implicit locks

  খ

  explicit locks

  গ

  exclusive locks

  ঘ

  shared locks
• What is the overall responsibility of the DBA?
  ক

  Facilitate the development and use of the database

  খ

  Create and populate tables

  গ

  Development, operation, and maintenance of the database and its applications

  ঘ

  Both the first and third answers above are correct.
• A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
  ক

  forward only

  খ

  static

  গ

  keyset

  ঘ

  dynamic
• The size of a lock is called:
  ক

  implicit lock

  খ

  lock granularity

  গ

  exclusive lock

  ঘ

  shared lock
• Which of the following locks the item from access of any type?
  ক

  Implicit lock

  খ

  Explicit lock

  গ

  Exclusive lock

  ঘ

  Shared lock
• Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
  ক

  Read committed

  খ

  Read uncommitted

  গ

  Repeatable read

  ঘ

  Serializable
• Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
  ক

  Nonrepeatable read

  খ

  Phantom read

  গ

  Dirty read

  ঘ

  Consistent read
• A cursor type in which the application can only move forward through the recordset is called:
  ক

  forward only.

  খ

  static.

  গ

  keyset.

  ঘ

  dynamic.
• A transaction in which either all of the database actions occur or none of them do is called:
  ক

  atomic.

  খ

  consistent.

  গ

  isolated.

  ঘ

  durable.
• Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
  ক

  Read committed

  খ

  Read uncommitted

  গ

  Repeatable read

  ঘ

  Serializable