ER Model Quiz 2

DBMS Basics and Entity-Relationship Model - Quiz 2

1. Execution of a Data Definition Language (DDL) statement will

Create a Table
Update Data Dictionary
Both Create a Table and Update Data Dictionary
Define the User Privileges

2. ________________ need an user to specify in a query "What data are required and how to retrieve the required data?"

Procedural DML
Declarative DML
Non-Procedural DML
Transaction Control Language

3. Which of the following users interact with the database directly using Query languages?

Naive Users
Specialized Users
Sophisticated Users
Applicaton Programmers

4. Which of the following is one of the main tasks of Database Administrator (DBA)?

Interface Program Development
Writing DML Precompilers
Schema Definition
None of the above

5. The number of entity sets linked through a single relationship set is

Degree of Relationship set
Degree of Entity set
Degree of Attribute set
All of the above

6. If single record in relation R is associated with zero or more number of records in relation S, and single record in S is associated with any number of records in R, then the relationship is

One-to-One
One-to-Many
Many-to-One
Many-to-Many

7. If single record in relation R is associated with zero or more number of records in relation S, and any single record in S is associated with only one record in R, then the relationship is

One-to-One
One-to-Many from R to S
Many-to-One from R to S
Many-to-Many

8. A minimal super key (i.e, one of the super keys for which no proper subset is a super key) is called

Super Key
Candidate Key
Primary Key
Both Candidate and Primary key

9. An entity set which does not have enough attributes to form a Primary key is

Strong Entity Set
Weak Entity Set
Strong Relationship Set
Weak Relationship Set

10. In an ER Diagram, a double ellipse is used to represent

Simple Attribute
Composite Attribute
Descriptive Attribute
Multi-valued Attribute

Score =

Correct answers: