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

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. How many types of keys in Database Design?

  • (A) foreign key
  • (B) all of the options
  • (C) candidate key
  • (D) primary key

A

Admin • 833.24K Points
Coach

Q. Which of the following is based on Multi Valued Dependency?

  • (A) third
  • (B) fourth
  • (C) first
  • (D) second

A

Admin • 833.24K Points
Coach

Q. Which of the following is the structure of the Database?

  • (A) table
  • (B) none of these
  • (C) schema
  • (D) relation

A

Admin • 833.24K Points
Coach

Q. The minimal set of super key is called

  • (A) primary key
  • (B) secondary key
  • (C) foreign key
  • (D) candidate key

A

Admin • 833.24K Points
Coach

Q. ______________ is a classical approach to database design?

  • (A) bottom – up approach
  • (B) top – down approach
  • (C) left – right approach
  • (D) right – left approach

A

Admin • 833.24K Points
Coach

Q. _____________ refers to the correctness and completeness of the data in a database?

  • (A) data independence
  • (B) data integrity
  • (C) data security
  • (D) data constraint

A

Admin • 833.24K Points
Coach

Q. A table that displays data redundancies yields ____________ anomalies

  • (A) insertion
  • (B) deletion
  • (C) update
  • (D) all of the options

A

Admin • 833.24K Points
Coach

Q. A lock that allows concurrent transactions to access different rows of the same table is known as a

  • (A) row-level lock
  • (B) database-level lock
  • (C) field-level lock
  • (D) table-level lock

A

Admin • 833.24K Points
Coach

Q. A type of query that is placed within a WHERE or HAVING clause of another query is called

  • (A) multi-query
  • (B) sub query
  • (C) super query
  • (D) master query

A

Admin • 833.24K Points
Coach

Q. A form defined

  • (A) none of the options
  • (B) where data is placed on the screen
  • (C) the width of each field
  • (D) both where data is placed on the screen and the width of each field

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.