02 DBMS MCQ 2

1. ……is a bottom –up approach in which two lower level entities
combine to form a higher level entity.
 (A) Aggregation
 (B) Specialization
 (C) Generalization
 (D) None of the above
2. An entity set that does not have sufficient attributes to form a
primary key, is a …..
(A) Primary entity set
(B) Weak Entity set
(C)Strong Entity set
(D) None of the above
3. An entity that is related with itself is known as …….
 (A) Binary relationship
 (B) Recursive relationship
 (C)Ternary relationship
 (D) None of the above
4. Which SQL command delete all the records and does not remove
 the structure?
(A) Drop
(B) Insert
(C)Truncate
(D) None of the above
5. In …. Database, data is organized in the form of trees with
nodes.
(A) Hierarchical
(B) Relational
(C) Network
(D) None of the above
6. Which command is used to retrieve records from one or more
table?
(A) Delete
(B)Insert
(C)Drop
(D) Select
7. Which of the following constraint is used to limit the value range
that can be placed in a column?
(A) Check
(B) Default
(C) Unique
(D) None of the above
8.Which of the following is a data definition language (DDL)
Command?
 (A) Delete
 (B) Insert
 (C) Drop
 (D) None of these
9._________ allows a unique number to be generated when a new
Record is inserted into a table.
 (A) Insert into select
 (B) Insert into
 (C) Select Into
 (D) Auto increment
10. This method of online analytical processing stores data in both a relation and a multi-dimensional database.
(A) HOLAP
(B) ROLAP
(C) OLAP
(D) UDA
11.Which concept would a data model NOT be expected to know?
A Class
(B) Object
(C) UML
(D) FMP
12. A Foreign key in one table points to a ________________key in another table .
(A) Alternate
(B) Default
(C) Primary Key
(D) None of the above