Database Management System - DBMS Multiple Choice Questions and Answers

111. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

1. Normalization
2. Functional dependency
3. Database modeling
4. Decomposition

112. Which is the process of breaking a relation into multiple relations:

1. Normalization
2. Functional dependency
3. Database modeling
4. Decomposition

113. …………… is used to determine whether of a table contains duplicate rows.

1. Null predicate
2. Unique predicate
3. Like Predicate
4. In predicate

114. Which of the following is a Data Model?

1. Object-Based data model
2. Entity-Relationship model
3. Relational data model
4. All of the above

115. The main interface that a naive user uses is a form interface using………………

1. OLAP
2. DDL
3. GUI
4. DML

116. In a ……………… lock, the DBMS will lock an entire disk page.

1. page-level
2. database-level
3. table-level
4. row-level

117. PJNF stands form:

1. Pages –join normal form
2. Practically –join normal form
3. Project –join normal form
4. programming –join normal form

118. …………….is the complex search criteria in the where clause.

1. Predict
2. Substring
3. Drop Table
4. Predicate

119. …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

1. Program
2. Instance
3. Schema
4. Super Key

120. DBMS is a collection of ………… that enables user to create and maintain a database.

1. Programs
2. Keys
3. Translators
4. Language Activity