Correct Answer is: Data Control Level

Correct Answer is: Non of the above

Correct Answer is: Database designer

Database Management System - DBMS MCQ Multiple Choice Questions

Q: 121. The primary key must be

Correct Answer is: None of these

Q: 122. BCNF stands for:

Correct Answer is: None of these

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

Correct Answer is: File Manager

Q: 125. A Database Management System (DBMS) is

Correct Answer is: Collection of programs to access data

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

Correct Answer is: Determinants

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

Correct Answer is: add a composite key

Q: 133. The SQL command to creating a table is:

Correct Answer is: Define table

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

Correct Answer is: administrating databases

Q: 135. Which of the following is not a Schema?

Correct Answer is: Logical Schema

121. The primary key must be

Both A & B
Unique
Not Null
None of these

122. BCNF stands for:

Boyce-Codd normal form
Basic -Codd normal form
Build -Codd normal form
None of these

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

Buffer Manager
Transaction Manager
Logical Manager
File Manager

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

Candidate Key
Composite Key
Alternate Key
Foreign Key

125. A Database Management System (DBMS) is

Collection of data describing one particular enterprise
Collection of interrelated data
Collection of programs to access data
All of the above

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

Compiler
Evaluation
Mapping
Precompiler

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

Composite Key
Local Key
Primary Key
Foreign Key

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

Composite Key
Local Key
Primary Key
Foreign Key

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

Composite Keys
Candidate keys
Foreign keys
Determinants

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

consistency
integrity
uniqueness
Design

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

consistent
fixed
complete
Secure

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

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

133. The SQL command to creating a table is:

Create table
Make table
Alter table
Define table

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

creating databases
creating and processing forms
processing data
administrating databases

135. Which of the following is not a Schema?

Critical Schema
Database Schema
Physical Schema
Logical Schema

136. DCL stands for

Data Console Level
Data Control Language
Data Console Language
Data Control Level

137. One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

Data Control
Data Security
Domain access
Domain Integrity

138. DFD stands for

Data Flow Diagram
Data Flow Document
Data File Diagram
Non of the above

139. DML is a language by which user accesses or manipulates the………………

Data integration
Data model
Data consistency
Data sharing

140. Minimal data redundancy means improved………………

Data integration
Data independence
Data consistency
Data sharing

141. The provision of …………….. is a major objective for database system:

Data integration
Data independence
Data consistency
Data sharing

142. The overall description of a database is called………………

Data integrity
Data definition
Data manipulation
Database schema

143. Disadvantages of File systems to store data is:

Data isolation
Data redundancy and inconsistency
Difficulty in accessing data
All of the above

144. Which is the central component of the DBMS software that can also be termed as the database control system?

Data sharing
Data consistency
Data integration
Data manager

145. Data are stored in………………as database:

Database
Data files
Data dictionary
Data administrator

146. Transaction is an action used to perform some manipulation on data stored in the………………

Database
Memory
Record
All of these

147. Which is stored information about description of data in the database:

Database
Data files
Data dictionary
Data administrator

148. In an Entity-Relationship Diagram Rectangles represents

Database
Entity sets
Attributes
Tables

149. DBA stands for:

Database backup
Database maintenance
Database administrator
Database designer

150. Which is the person responsible for overall control f the database system:

DBA
DDL
DBMS
SDL

Database Management System - DBMS MCQ Multiple Choice Questions - Page 5 for Practice

Database Management System - DBMS MCQ Questions for Practice

121. The primary key must be

122. BCNF stands for:

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

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

125. A Database Management System (DBMS) is

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

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

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

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

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

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

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

133. The SQL command to creating a table is:

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

135. Which of the following is not a Schema?

136. DCL stands for

137. One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

138. DFD stands for

139. DML is a language by which user accesses or manipulates the………………

140. Minimal data redundancy means improved………………

141. The provision of …………….. is a major objective for database system:

142. The overall description of a database is called………………

143. Disadvantages of File systems to store data is:

144. Which is the central component of the DBMS software that can also be termed as the database control system?

145. Data are stored in………………as database:

146. Transaction is an action used to perform some manipulation on data stored in the………………

147. Which is stored information about description of data in the database:

148. In an Entity-Relationship Diagram Rectangles represents

149. DBA stands for:

150. Which is the person responsible for overall control f the database system:

Your Score

Related Quiz Topics

Recent Articles

Looking to post on our portal?

Database Management System - DBMS MCQ Multiple Choice Questions - Page 5 for Practice

Database Management System - DBMS MCQ Questions for Practice

121. The primary key must be

122. BCNF stands for:

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

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

125. A Database Management System (DBMS) is

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

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

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

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

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

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

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

133. The SQL command to creating a table is:

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

135. Which of the following is not a Schema?

136. DCL stands for

137. One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as

138. DFD stands for

139. DML is a language by which user accesses or manipulates the………………

140. Minimal data redundancy means improved………………

141. The provision of …………….. is a major objective for database system:

142. The overall description of a database is called………………

143. Disadvantages of File systems to store data is:

144. Which is the central component of the DBMS software that can also be termed as the database control system?

145. Data are stored in………………as database:

146. Transaction is an action used to perform some manipulation on data stored in the………………

147. Which is stored information about description of data in the database:

148. In an Entity-Relationship Diagram Rectangles represents

149. DBA stands for:

150. Which is the person responsible for overall control f the database system:

Your Score

Related Quiz Topics

Recent Articles

Login at Quizforum