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

121. The primary key must be

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

122. BCNF stands for:

1. Build -Codd normal form
2. None of these
3. Boyce-Codd normal form
4. Basic -Codd normal form

123. Which of the following is not a Storage Manager Component?

1. Logical Manager
2. File Manager
3. Buffer Manager
4. Transaction Manager

124. ……………… is a combination of two of more attributes used as a primary key

1. Alternate Key
2. Foreign Key
3. Candidate Key
4. Composite Key

125. A Database Management System (DBMS) is

1. Collection of programs to access data
2. All of the above
3. Collection of data describing one particular enterprise
4. Collection of interrelated data

126. Which is the transformation of requests and results between different levels of abstraction:

1. Mapping
2. Precompiler
3. Compiler
4. Evaluation

127. Drop Table cannot be used to drop a table referenced by a …………… constraint.

1. Primary Key
2. Foreign Key
3. Composite Key
4. Local Key

128. Drop Table cannot be used to drop a table referenced by a …………… constraint.

1. Primary Key
2. Foreign Key
3. Composite Key
4. Local Key

129. In the relational model, relationships between relations or tables are created by using:

1. Foreign keys
2. Determinants
3. Composite Keys
4. Candidate keys

130. All transactions are controlled and executed by the DBMS (subject to some limitations to guarantee database ………………

1. uniqueness
2. Design
3. consistency
4. integrity

131. A ………………database state is one in which all data integrity constraints are satisfied

1. complete
2. Secure
3. consistent
4. fixed

132. One solution to the multivalued dependency constraint problem is to:

1. Change the theme.
2. add a composite key
3. Create a new theme.
4. split the relation into two relations, each with a single theme

133. The SQL command to creating a table is:

1. Alter table
2. Define table
3. Create table
4. Make table

134. The following are functions of a DBMS except………………

1. processing data
2. administrating databases
3. creating databases
4. creating and processing forms

135. Which of the following is not a Schema?

1. Physical Schema
2. Logical Schema
3. Critical Schema
4. Database Schema