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 MCQ Questions and Answers Quiz

1. How many levels of abstraction in DBMS:

  1. 4
  2. 2
  3. 3
  4. 5

2. There are ................ number of Normal forms that has been defined

  1. 4
  2. 5
  3. 6
  4. 3

3. E. F. Codd developed the normalization process in the which early:

  1. 1971
  2. 1969
  3. 1970
  4. 1972

4. Which forms are based on the concept of functional dependency

  1. 3NF
  2. 1NF
  3. 2NF
  4. 4NF

5. Which forms every non-prime attribute is fully dependent functionally on the candidate key of a relational schema:

  1. 3NF
  2. 1NF
  3. 2NF
  4. 5NF

6. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:

  1. 3NF
  2. 1NF
  3. 2NF
  4. All of these

7. Which of the following is/are the DDL statements?

  1. Alter
  2. Create
  3. Drop
  4. All of the above

8. Which of the following is NOT a type of SQL constraint?

  1. ALTERNATE KEY
  2. PRIMARY KEY
  3. FOREIGN KEY
  4. UNIQUE

9. Which of the following is not a binary operator in relational algebra?

  1. Assignment
  2. Join
  3. Semi-Join
  4. Project

10. Which of the following is NOT a basic element of all versions of the E-R model?

  1. Attributes
  2. Entities
  3. Relationships
  4. Primary key
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Trivia Questions and Answers PDF

Database Management System - DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....