01 DBMS MCQ 1

1. Rows of a relation are called ______________
 (A) Entity
 (B) Degree
 (C) tuples
 (D) None of the above
2. In SQL, Which of the following is a Data Manipulation Language
 (DML) Command?
 (A) Create
 (B) Alter
 (C) Merge
 (D) Drop
3. Which of the following categories of the data integrity RDBMS
 will enforce specific business rules?
 (A)Entity Integrity
 (B)Domain Integrity
 (C)User-Defined Integrity
 (D)None of the above
4. The number of tuples in a relation is termed as_____________
(A) Cardinality
(B) Entity
(C) Column
(D) None of the above

5. Rows of a relation are called ______________
 (A) Entity
 (B) Degree
 (C) tuples
 (D) None of the above
6. In SQL, Which of the following is a Data Manipulation Language
 (DML) Command?
 (A) Create
 (B) Alter
 (C) Merge
 (D) Drop
7. Which of the following categories of the data integrity RDBMS
 will enforce specific business rules?
 (A)Entity Integrity
 (B)Domain Integrity
 (C)User-Defined Integrity
 (D)None of the above
8. The number of tuples in a relation is termed as_____________
(A) Cardinality
(B) Entity
(C) Column
(D) None of the above
9. ……. is a top- down approach in which one higher level entity can
 be divided into two lower level entities
(A) Aggregation
(B) Specialization
(C) Generalization
(D) None of the above
10. E-R modeling technique is a ___________
(A) top-down approach
(B) bottom-up approach
(C) User –Defined
(D) None of the above

Read More