Database Management System DBMS multiple choice questions and answers on DBMS MCQ questions quiz on DBMS objective type questions with answer for competitive exams and written test preparations for online DBMS quiz Professionals, Teachers, Students and Kids Trivia Quizzes to test your knowledge on the subject.

Database Management System - DBMS Question with Answer

1. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ----------------- is needed

  1. Fourth
  2. DKNF
  3. BCNF
  4. Third

2. A relation is in this form if it is in BCNF and has no multivalued dependencies:

  1. Fourth normal form.
  2. Second normal form.
  3. Third normal form
  4. Domain/key normal form.

3. ……………..specifies a search condition for a group or an aggregate.

  1. FROM Clause
  2. GROUP BY Clause
  3. HAVING Clause
  4. WHERE Clause

4. ……………..specifies a search condition for a group or an aggregate.

  1. FROM Clause
  2. GROUP BY Clause
  3. HAVING Clause
  4. WHERE Clause

5. ………………….operator is basically a join followed by a project on the attributes of first relation.

  1. Full Join
  2. Join
  3. Semi-Join
  4. Inner Join

6. FD stands for:

  1. Functional data
  2. Functional dependency
  3. Facilitate dependency
  4. Facilitate data

7. The different classes of relations created by the technique for preventing modification anomalies are called:

  1. Functional dependencies.
  2. Normal forms.
  3. Referential integrity constraints.
  4. None of the above

8. ……………… clause is an additional filter that is applied to the result.

  1. Having
  2. Select
  3. Group-by
  4. Order by

9. In which model of database data is stored in tables:

  1. Hierarchical model
  2. Network model
  3. Relational model
  4. None of these

10. The .................... is essentially used to search for patterns in target string.

  1. In Predicate
  2. Like Predicate
  3. Null Predicate
  4. Out Predicate

Tags :

Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Multiple Choice Questions and Answers

Database Management System - DBMS Trivia Quiz

Database Management System - DBMS Question and Answer PDF Online

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....