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

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. Who developed normalization process?

  • (A) C.J. Date
  • (B) E.F. Codd
  • (C) Donald Chamberlain
  • (D) Boyce and Codd

A

Admin • 833.24K Points
Coach

Q. Who developed the BCNF?

  • (A) Boyd and Cromwell
  • (B) Date and Codd
  • (C) Date and White
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. What is the expansion of BCNF?

  • (A) Boyd-Cromwell Normal Form
  • (B) Boyce-Codd Normal Form
  • (C) Boyd-Codd Normal Form
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is the result of a transitive dependency?

  • (A) Insertion anomaly
  • (B) Modification anomaly
  • (C) Deletion anomaly
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is true?

  • (A) Normalized data is the best representation of data.
  • (B) Data stored non-redundantly will be accessed faster than data stored many times.
  • (C) Normalized tables are the best way to store data.
  • (D) 7

A

Admin • 833.24K Points
Coach

Q. How many inference rules are there for functional dependencies?

  • (A) 4
  • (B) 5In t
  • (C) 6
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?

  • (A) Dependency preservation property
  • (B) Fully Functional dependency
  • (C) Lossless Join
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. A table that contains one or more repeating groups is in which normal form?

  • (A) 1NF
  • (B) 2NF
  • (C) 3NF
  • (D) Unnormalized Form

A

Admin • 833.24K Points
Coach

Q. A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency

  • (A) i and iii
  • (B) i and iv
  • (C) i and ii
  • (D) ii and iv

A

Admin • 833.24K Points
Coach

Q. Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address)

  • (A) it is not in 2 NF
  • (B) it does not have composite key
  • (C) non-key attributes course no and course max. marks are functionally dependent
  • (D) it has more than 3 non-key attributes

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.