Database Management System - DBMS Multiple Choice Questions and Answers

151. ………... is a translates into low-level instruction that a query processor understands:

1. DBS
2. DBA
3. DBMS
4. DDL compiler

152. DA stands for:

1. Define application
2. Data administrator
3. Database active
4. All of these

153. Which command enables alteration the data stored in existing records:

1. Deletion command
2. Create command
3. Update command
4. All of these

154. Data Manipulation Language enables users to

1. Deletion of information from the database
2. Retrieval of information stored in database
3. Insertion of new information into the database
4. All of the above

155. A logical schema

1. describes how data is actually stored on disk.
2. is the entire database
3. is a standard way of organizing information into accessible parts.
4. All of the above

156. Which of the following is a group of one or more attributes that uniquely identifies a row?

1. Determinant
2. Key
3. Tuple
4. Relation

157. To eliminate duplicate rows ……………… is used

1. DISTINCT
2. NODUPLICATE
3. ELIMINATE
4. None of these

158. Which is installs, configures, troubleshoots and maintains a database system:

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

159. Centralizing the integrity checking directly under the DBMS ………… duplication and ensures the consistency and validity of the database.

1. Does not reduce
2. Increases
3. Skips
4. Reduces

160. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

1. Domain Integrity Constraints
2. Entity Integrity Constraints
3. Referential Integrity Constraints
4. Key Constraints