Database Management System - DBMS Objective Question and Answer
Database Management System - DBMS MCQ Multiple Choice Questions - Page 6 for Practice
151. Who interact with the system by invoking one of the permanent application program:
Correct Answer is: Naïve users
152. Who interact with the system without writing a program:
Correct Answer is: Sophisticated user
153. …………………… is the process of organizing data into related tables.
Correct Answer is: Normalization
154. ………………… is a full form of SQL.
Correct Answer is: Structured query language
155. FDs are the types of constraints that are based on………………
Correct Answer is: Key
156. ……………… table store information about database or about the system.
Correct Answer is: System
157. What is a virtual table
Correct Answer is: View
158. SQL outputs a single table known as the………………
Correct Answer is: Result set
159. What SQL structure is used to limit column values of a table?
Correct Answer is: The CHECK constraint
160. A ................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
Correct Answer is: Third
161. A .................normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute.
Correct Answer is: Third
162. In the ..........normal form, a composite attribute is converted to individual attributes.
Correct Answer is: First
163. In the.......... Normal form, a composite attribute is converted to individual attributes.
Correct Answer is: First
164. Which one is based on multi-valued dependency:
Correct Answer is: Fourth
165. In decomposition technique of splitting a relation into ……………… relation:
Correct Answer is: TWO or MORE
166. ………………… is preferred method for enforcing data integrity
Correct Answer is: Constraints
167. Which are the dependencies types:
Correct Answer is: All of these
168. The number of entities associated in relationship is called as its.....................
Correct Answer is: Degree
169. A relation is considered a:
Correct Answer is: Two dimensional table
170. Identify the criteria for designing database from the point of view of user
Correct Answer is: All of the above
171. Identify the criteria for designing database from the point of view of user
Correct Answer is: All of the above
172. The ........... operator preserves unmatched rows of the relations being joine
Correct Answer is: Outer join
173. The DML is called:
Correct Answer is: Sublanguages
174. The DROP TABLE statement:
Correct Answer is: Deletes the table structure along with the table data
