Database Management System - DBMS MCQ Multiple Choice Questions - Page 6 for Practice

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

152. DA stands for:

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

154. Data Manipulation Language enables users to

155. A logical schema

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

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

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

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

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

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

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

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

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

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

166. ……………… joins are SQL server default

167. Which are the three levels of abstraction:

168. Row is synonymous with the term:

169. Table is synonymous with the term:

170. How many types of keys in relation database design:

171. The candidate key is that you choose to identify each row uniquely is called ……………..

172. Which key is referencing a primary key in a table:

173. The primary key is selected from the:

174. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ............... Is needed


Tags

Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Multiple Choice Questions and Answers

Database Management System - DBMS Trivia Quiz

Database Management System - DBMS Question and Answer PDF Online