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


Test Your Skills in Database Management System - DBMS Quiz Online

Database Management System - DBMS Questions with Answers

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

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....