Database Management System - DBMS MCQ Questions and Answers Quiz

21. Which are the types of integrity rule:

  1. Both
  2. Entity integrity
  3. Referential integrity
  4. None

22. Which are the types of physical DBMS architecture can be split :

  1. Both
  2. Back end
  3. Front end
  4. None

23. Which calculus is based on specifying a number of tuple variables:

  1. Both
  2. Tuple relation calculus
  3. Domain relational calculus
  4. None

24. Which command creates database objects like tables, views and indexes:

  1. Both
  2. Create command
  3. Update command
  4. None

25. Which is a DBMS keeps back-up copies of the database:

  1. Both
  2. Backup
  3. Recovery
  4. None

26. Which is incorporated to create an appropriate physical database that is transformed by a logical data model:

  1. Both
  2. SDL
  3. VDL
  4. None

27. Which is relation calculus:

  1. Both
  2. Tuple relational calculus
  3. Domain relational calculus
  4. None

28. Which mapping exists between the conceptual and internal levels:

  1. Both
  2. Conceptual
  3. Internal
  4. None

29. Which mapping exists between the external and conceptual levels:

  1. Both
  2. Conceptual
  3. External
  4. None

30. The primary key must be

  1. Both A & B
  2. Unique
  3. Not Null
  4. None of these
Tags

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

Database Management System - DBMS Question and Answer