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

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