Database Management System Quiz

In an E-R diagram an entity set is represent by a

• rectangle

• ellipse

• diamond box

• circle

Relationships among relationships can be represented in an-E-R model using

• Aggregation

• Association

• Weak entity sets

• Weak relationship sets

In an E-R diagram attributes are represented by

• rectangle

• square

• ellipse

• triangle

In an e-r diagram double lines indicate

• Total participation

• Multiple participation

• Cardinality N

• None of the above

In a Hierarchical model records are organized as

• Graph

• List

• Links

• Tree

Which database level is closest to the users?

• External

• Internal

• Physical

• Conceptual

In E-R Diagram relationship type is represented by

• Ellipse

• Dashed ellipse

• Rectangle

• Diamond

Which of the following operation is used if we are interested in only certain columns of a table?

• PROJECTION

• SELECTION

• UNION

• JOIN

Relational Algebra does not have

• A . Selection operator

• B . Projection operator

• C . Aggregation operators

• D . Division operator

In the relational modes, cardinality is termed as:

• Number of tuples

• Number of attributes

• Number of tables

• Number of constraints