Database Management System (DBMS) MCQs with answers Page - 144

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. A functional dependency of the form X→Y is trivial if

  • (A) YC= X
  • (B) Y C X
  • (C) X C =Y
  • (D) X C Y and Y C X

A

Admin • 833.24K Points
Coach

Q. The concept of locking can be used to solve the problem of

  • (A) Lost update
  • (B) Uncommitted dependency
  • (C) Inconsistent data
  • (D) Deadlock

A

Admin • 833.24K Points
Coach

Q. A schedule S of n transactions is serializable if it is equivalent to some

  • (A) Serial schedule of the same n transactions.
  • (B) Non-serial schedule of the same n transactions.
  • (C) Serial schedule of different n transactions.
  • (D) Non-serial schedule of different n transactions.

A

Admin • 833.24K Points
Coach

Q. In two-phase locking protocol.

  • (A) All unlocking operations precede the first lock operation.
  • (B) All locking operations precede the first unlock operation.
  • (C) Locking and unlocking takes place simultaneously.
  • (D) None of the above.

A

Admin • 833.24K Points
Coach

Q. Transaction timestamp is:

  • (A) Not unique for each transaction
  • (B) Larger for older transaction
  • (C) Unique identifier assigned to each transaction.
  • (D) None of the above.

A

Admin • 833.24K Points
Coach

Q. The granularity of a database item can be chosen to be

  • (A) A whole file
  • (B) A database record
  • (C) The whole database
  • (D) All of the above.

A

Admin • 833.24K Points
Coach

Q. If the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:

  • (A) Isolation
  • (B) Durability
  • (C) Consistency preservation
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is not the state that the transaction undergoes?

  • (A) Failed
  • (B) Active
  • (C) Partially committed
  • (D) Non active

A

Admin • 833.24K Points
Coach

Q. Timestamp can be generated by:

  • (A) Counter
  • (B) Current date/time
  • (C) None of the above
  • (D) Both (a) and (b)

A

Admin • 833.24K Points
Coach

Q. Which of the following is the formal process for deciding which attributes should be grouped together in a relation?

  • (A) Normalization
  • (B) Performance Tuning
  • (C) Optimization
  • (D) None of the above

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.