SQL Entity Relationship Model MCQ

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


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


3. Entity is a _________

A. Object of relation
B. Present working model
C. Thing in real world
D. Model of relation

View Answer


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


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


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


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


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


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


10. Which of the following is a single valued attribute?

A. Register_number
B. Address
C. SUBJECT_TAKEN
D. Reference

View Answer






Also check :


Discussion


* You must be logged in to add comment.