SQL Entity Relationship Model MCQ
Entity Relationship Model MCQs : This section focuses on the "Entity Relationship Model" of the SQL. These Multiple Choice Questions (MCQs) should be practiced to improve the SQL skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.
1. A many to many relationship between two entities usually results in how many tables?
A. One
B. Two
C. Three
D. Four
View Answer
Ans : C
Explanation: A many to many relationship between two entities usually results in Three tables.
2. An ________ is a set of entities of the same type that share the same properties, or attributes.
A. Entity set
B. Attribute set
C. Relation set
D. Entity model
View Answer
Ans : A
Explanation: An entity is a "thing" or "object" in the real world that is distinguishable from all other objects.
3. Entity is a _________
A. Object of relation
B. Present working model
C. Thing in real world
D. Model of relation
View Answer
Ans : C
Explanation: For example, each person in a university is an entity.
4. Every weak entity set can be converted into a strong entity set by:
A. using generalization
B. adding appropriate attributes
C. using aggregation
D. none of the above
View Answer
Ans : B
Explanation: Every weak entity set can be converted into a strong entity set by adding appropriate attributes.
5. E-R modeling technique is a :
A. Top-down approach
B. Bottom-up approach
C. Left-right approach
D. None of the above
View Answer
Ans : A
Explanation: E-R modeling technique is a Top-down approach.
6. Every weak entity set can be converted to a strong entity set by :
A. Using generalization
B. Simply adding appropriate attribute
C. Using aggregation
D. Repeating the entity set several times
View Answer
Ans : A
Explanation: Every weak entity set can be converted to a strong entity set by Using generalization
7. In ER model the details of the entities are hidden from the user. This process is called :
A. generalization
B. specialization
C. abstraction
D. none of these above
View Answer
Ans : C
Explanation: In ER model the details of the entities are hidden from the user. This process is called abstraction.
8. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
A. Single valued
B. Multi valued
C. Composite
D. Derived
View Answer
Ans : D
Explanation: The value for this type of attribute can be derived from the values of other related attributes or entities.
9. Which of the following can be a multivalued attribute?
A. Phone_number
B. Name
C. Date_of_birth
D. All of the mentioned
View Answer
Ans : A
Explanation: Name and Date_of_birth cannot hold more than 1 value.
10. Which of the following is a single valued attribute?
A. Register_number
B. Address
C. SUBJECT_TAKEN
D. Reference
View Answer
Ans : A
Explanation: Register_number is a single valued attribute.
Also check :
Discussion