Correct Answer is: Data Control Language

Correct Answer is: Data Flow Diagram

Correct Answer is: Database administrator

Database Management System - DBMS MCQ Multiple Choice Questions

Q: 122. BCNF stands for:

Correct Answer is: Boyce-Codd normal form

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

Correct Answer is: Logical Manager

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

Correct Answer is: Composite Key

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

Correct Answer is: All of the above

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

Correct Answer is: Foreign keys

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

Correct Answer is: split the relation into two relations, each with a single theme

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

Correct Answer is: Create table

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

Correct Answer is: creating and processing forms

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

Correct Answer is: Critical 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