Database Management System - DBMS Questions and Answers in Quiz Form 8 for Practice

106. A DBMS uses a transaction ……………… to keep track of all transactions that update the database

1. block
2. log
3. table
4. Statement

107. ……………… states that primary keys should not be null:

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

108. In which end is really just any application that runs on top of the DBMS and acts as a user interface:

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

109. In which the database can be restored up to the last consistent state after the system failure:

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

110. The related and interconnected software components of a DBMS are described by the………………

1. Both
2. Logical architecture
3. Physical architecture
4. None

111. Which are the types of data independence:

1. Both
2. Physical
3. Logical
4. All of these

112. Which are the types of integrity rule:

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

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

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

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

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

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

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

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

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

117. 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

118. Which is relation calculus:

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

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

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

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

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