RDBMS Questions and Answers – Entity Relationship Model

This set of RDBMS Questions and Answers for Experienced people focuses on “Entity Relationship Model”.

1. The _________ of the entity set is an actual collection of entities belonging to that entity set.
a) Extension
b) Intention
c) Description
d) Availability
View Answer

2. A ___________ is an association among several entities.
a) Relationship
b) Association
c) Set
d) Combination
View Answer

3. The attributes of a relationship are called as _________ attributes
a) Relational
b) Conjunctive
c) Descriptive
d) None of the mentioned
View Answer

4. What are composite attributes?
a) They are those attributes which cannot be further divided into other attributes
b) They are those attributes which can further be divided into other attributes
c) They are those attributes which are essentially the primary keys of the relation
d) None of the mentioned
View Answer

5. Let E be an entity set in a relationship set R. If every entity in E participates in at least one relationships in R, then the participation of E in R is __________
a) Partial
b) Total
c) Complete
d) Incomplete
View Answer

6. Let E be an entity set in a relationship set R. If only some entities in E participate in relationships in R, then the participation of E in R is __________
a) Partial
b) Total
c) Complete
d) Incomplete
View Answer

7. State true or false: We cannot specify keys in the Entity-Relationship model
a) True
b) False
View Answer

8. State true or false: Multiple attributes combined together can be primary keys
a) True
b) False
View Answer

9. Which of the following is a good database management practice?
a) Adding redundant attributes
b) Removing redundant attributes
c) Not specifying primary keys
d) None of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – RDBMS.

To practice all areas of RDBMS for Experienced people, here is complete set of 1000+ Multiple Choice Questions and Answers.