DBMS Questions – Set 1
1. A collection of conceptual tools for describing data, relationships, semantics and constraints is
referred to as ……….
(A) Data Model
(B) E-R Model
(C) DBMS
(D) All of the above
Answer
(A) Data Model
2. Dr.E.F. Codd represented ……. rules that a database must obey if it has to be considered truly
relational.
(A) 10
(B) 15
(C) 14
(D) 12
Answer
(D) 12
3. In E-R Diagram, weak entity is represented by…….
(A) Rectangle
(B) Square
(C) Double Rectangle
(D) Circle
Answer
(C) Double Rectangle
4. An entity that is related with itself is known as…….
(A) binary relationship
(B) recursive relationship
(C) ternary relationship
(D) None of the above
Answer
(B) recursive relationship
5. ……. 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
Answer
(C) Generalization
6. 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
Answer
(B) Weak entity set
7. Which SQL command delete all the records and does not remove the structure?
(A) Drop
(B) Insert
(C) Truncate
(D) None of the above
Answer
(C) Truncate
8. Which of the following is a Data Definition Language (DDL) command?
(A) Delete
(B) Insert
(C) Drop
(D) Merge
Answer
(C) Drop
9. In …….. database, data is organized in the form of trees with nodes.
(A) Hierarchical
(B) Relational
(C) Network
(D) None of the above
Answer
(A) Hierarchical
10. Which command is used to retrieve records from one or more table?
(A) Delete
(B) Insert
(C) Drop
(D) Select
Answer
(D) Select
0 Comments