Database Management System - DBMS Multiple Choice Questions and Answers

101. Which of the following is not a level of data abstraction?

1. Logical Level
2. Physical Level
3. Critical Level
4. View Level

102. In which ways two tables may be related:

1. Many-many
2. One-one
3. One-many
4. All of these

103. A data dictionary is a repository that manages ………………

1. Metadata
2. Database
3. Memory
4. All of these

104. …………… database is used as template for all databases

1. Model
2. Create
3. Master
4. Tempdb

105. The DBMS utility..................... allows reconstructing the correct state of database from the backup and history of transactions.

1. Monitoring
2. Backup
3. Recovery
4. Data loading

106. The DBMSutility,………………allows to reconstruct the correct state of database from the backup and history of transactions.

1. Monitoring
2. Backup
3. Recovery
4. Data loading

107. An outstanding functionality of SQL is its support for automatic ………… to the target data.

1. Navigation
2. Programming
3. Functioning
4. Notification

108. A ……………… does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.

1. Non attributes entity
2. Weak entity
3. Strong entity
4. Dependent entity

109. Which is proper subset designed to support ‘views belonging to different classes of users in order to hid or protect information:

1. Non-schema
2. Schema
3. Subschema
4. None-subschema

110. For some relations, changing the data can have undesirable consequences called:

1. Normal forms.
2. Referential integrity constraints.
3. Modification anomalies.
4. Transitive dependencies.