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

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. If every non-key attribute is functionally dependent primary key, then the relation will be in

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

A

Admin • 833.24K Points
Coach

Q. The term for information that describes what type of data is available in a database is:

  • (A) data dictionary
  • (B) data repository
  • (C) index data
  • (D) metadata

A

Admin • 833.24K Points
Coach

Q. A data type that creates unique numbers for key columns in Microsoft Access is:

  • (A) autonumber
  • (B) boolean
  • (C) sequential key
  • (D) sequential number

A

Admin • 833.24K Points
Coach

Q. A dependency exist between two columns when

  • (A) together they constitute a composite key for the table
  • (B) knowing the value in one column determines the value stored in another column
  • (C) the table is in 3nf
  • (D) together they constitute a foreign key

A

Admin • 833.24K Points
Coach

Q. In the normal form, a composite attribute is converted to individual attributes.

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

A

Admin • 833.24K Points
Coach

Q. A table on the many side of a one to many or many to many relationship must:

  • (A) be in second normal form (2nf)
  • (B) be in third normal form (3nf)
  • (C) have a single attribute key
  • (D) have a composite key

A

Admin • 833.24K Points
Coach

Q. Functional Dependencies are the types of constraints that are based on

  • (A) key
  • (B) key revisited
  • (C) superset key
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. A relation is in if an attribute of a composite key is dependent on an attribute of other composite key.

  • (A) 2nf
  • (B) 3nf
  • (C) bcnf
  • (D) 1nf

A

Admin • 833.24K Points
Coach

Q. What are the desirable properties of a decomposition

  • (A) partition constraint
  • (B) dependency preservation
  • (C) redundancy
  • (D) security

A

Admin • 833.24K Points
Coach

Q. R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

  • (A) a->b, b->cd
  • (B) a->b, b->c, c->d
  • (C) ab->c, c->ad
  • (D) a->bcd

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.