Database Management System - DBMS MCQs Quiz Multiple Choice Questions & Answers Page 3

101. Which of the following is NOT a basic element of all versions of the E-R model?

1. Attributes
2. Entities
3. Relationships
4. Primary key

102. Which is a duplicate copy of a file program that is stored on a different storage media than the original location:

1. Backup
2. Concurrency
3. Deadlock
4. Recovery

103. Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:

1. Backup
2. Concurrency
3. Deadlock
4. Recovery

104. Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other:

1. Backup
2. Concurrency
3. Deadlock
4. Recovery

105. This is not a date type in SQL Server 2000

1. Bigint
2. Char
3. String
4. Decimal

106. A DBMS uses a transaction ……………… to keep track of all transactions that update the database

1. block
2. log
3. table
4. Statement

107. ……………… states that primary keys should not be null:

1. Both
2. Entity integrity
3. Referential integrity
4. None

108. In which end is really just any application that runs on top of the DBMS and acts as a user interface:

1. Both
2. Back end
3. Front end
4. None

109. In which the database can be restored up to the last consistent state after the system failure:

1. Both
2. Backup
3. Recovery
4. None

110. The related and interconnected software components of a DBMS are described by the………………

1. Both
2. Logical architecture
3. Physical architecture
4. None

111. Which are the types of data independence:

1. Both
2. Physical
3. Logical
4. All of these

112. Which are the types of integrity rule:

1. Both
2. Entity integrity
3. Referential integrity
4. None

113. Which are the types of physical DBMS architecture can be split :

1. Both
2. Back end
3. Front end
4. None

114. Which calculus is based on specifying a number of tuple variables:

1. Both
2. Tuple relation calculus
3. Domain relational calculus
4. None

115. Which command creates database objects like tables, views and indexes:

1. Both
2. Create command
3. Update command
4. None

116. Which is a DBMS keeps back-up copies of the database:

1. Both
2. Backup
3. Recovery
4. None

117. Which is incorporated to create an appropriate physical database that is transformed by a logical data model:

1. Both
2. SDL
3. VDL
4. None

118. Which is relation calculus:

1. Both
2. Tuple relational calculus
3. Domain relational calculus
4. None

119. Which mapping exists between the conceptual and internal levels:

1. Both
2. Conceptual
3. Internal
4. None

120. Which mapping exists between the external and conceptual levels:

1. Both
2. Conceptual
3. External
4. None

121. The primary key must be

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

122. BCNF stands for:

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

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

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

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

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

125. A Database Management System (DBMS) is

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

133. The SQL command to creating a table is:

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

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

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

135. Which of the following is not a Schema?

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

136. DCL stands for

1. Data Console Level
2. Data Control Language
3. Data Console Language
4. 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

1. Data Control
2. Data Security
3. Domain access
4. Domain Integrity

138. DFD stands for

1. Data Flow Diagram
2. Data Flow Document
3. Data File Diagram
4. Non of the above

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

1. Data integration
2. Data model
3. Data consistency
4. Data sharing

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

1. Data integration
2. Data independence
3. Data consistency
4. Data sharing

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

1. Data integration
2. Data independence
3. Data consistency
4. Data sharing

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

1. Data integrity
2. Data definition
3. Data manipulation
4. Database schema

143. Disadvantages of File systems to store data is:

1. Data isolation
2. Data redundancy and inconsistency
3. Difficulty in accessing data
4. All of the above

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

1. Data sharing
2. Data consistency
3. Data integration
4. Data manager

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

1. Database
2. Data files
3. Data dictionary
4. Data administrator

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

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

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

1. Database
2. Data files
3. Data dictionary
4. Data administrator

148. In an Entity-Relationship Diagram Rectangles represents

1. Database
2. Entity sets
3. Attributes
4. Tables

149. DBA stands for:

1. Database backup
2. Database maintenance
3. Database administrator
4. Database designer

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

1. DBA
2. DDL
3. DBMS
4. SDL