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

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

161. ………………… 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

162. To delete a database .................. command is used

1. drop database database_name
2. delete database database_name
3. Delete database_name
4. drop database_name

163. ……………… ensures that once transaction changes are done, they cannot be undone or lost, even in the event of a system failure.

1. Durability
2. Atomicity
3. Consistency
4. Isolation

164. ……………… means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is complete

1. Durability
2. Atomicity
3. Consistency
4. Isolation

165. The ……………… statement is used to end a successful transaction.

1. END
2. COMMIT
3. DONE
4. QUIT