QUIZ SECTION
Q1. Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Q2. Which of the following gives a logical structure of the database graphically ?
Entity-relationship diagram
Entity diagram
Database diagram
Architectural representation
Q3. The entity relationship set is represented in E-R diagram as
Double diamonds
Undivided rectangles
Dashed lines
Diamond
Q4. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
One to many
One to one
Many to many
Many to one
Q5. An entity set that does not have sufficient attributes to form a primary key is termed a __________ .
Strong entity set
Variant set
Weak entity set
Variable set
Q6. For a weak entity set to be meaningful, it must be associated with another entity set, called the
Identifying set
Owner set
Neighbour set
Strong entity set
Q7. Weak entity set is represented as
Underline
Double line
Double diamond
Double rectangle
Q8. If you were collecting and storing information about your music collection, an album would be considered a(n) _____.
Relation
Entity
Instance
Attribute
Q9. What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
Relation
Instance
Table
Column
Q 10. We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________.
Diamond , diamond
Rectangle, diamond
Rectangle, rectangle
Diamond, rectangle
Your Score :