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

Answer: a
Explanation: The extension of the entity set is an actual collection of entities belonging to that entity set.

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

Answer: a
Explanation: A relationship is an association among several entities. A relationship specifies how two entities are related.

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

Answer: c
Explanation: A relationship may also have attributes. These attributes are called as descriptive attributes.
advertisement
advertisement

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

Answer: b
Explanation: Composite attributes are the ones which can be further divided into other attributes whereas simple attributes cannot be divided into other attributes.

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

Answer: b
Explanation: Let E be an entity set in a relationship set R. If every entity in E participates in at least one relation in R, then the participation of E in R is total.

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

Answer: a
Explanation: 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 partial.

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

Answer: b
Explanation: Keys can be specified in the entity-relationship model to uniquely identify the entity in the entity set.
advertisement

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

Answer: a
Explanation: A primary key is an attribute or a set of attributes that can uniquely identify a tuple in a relation. So, this means that multiple attributes can be combined to uniquely identify a tuple in a relation.

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

Answer: b
Explanation: Removing redundant attributes from a relation makes data extraction more efficient and faster. Thus, it is a good database management technique.
advertisement

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.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.