Database Management System - DBMS Multiple Choice Questions and Answers

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