Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Dbms Quiz 1

Total questions: 48

Worksheet time: 24mins

Name
Class
Date
1.

In an ER diagram, which symbol is typically used to represent an entity?

a)

Oval

b)

Diamond

c)

Rectangle

d)

Triangle

2.

Which element in an ER diagram represents a relationship?

a)

Diamond

b)

Rectangle

c)

Oval

d)

Hexagon

3.

In an ER diagram, an attribute is usually represented by:

a)

Oval

b)

Rectangle

c)

Diamond

d)

Parallelogram

4.

Which attribute type can have multiple values?

a)

Derived attribute

b)

Composite attribute

c)

Multivalued attribute

d)

Primary attribute

5.

Which attribute type is calculated from other attributes?

a)

Derived attribute

b)

Composite attribute

c)

Multivalued attribute

d)

Simple attribute

6.

In ER diagrams, a weak entity is represented by:

a)

Dashed diamond

b)

Double rectangle

c)

Single rectangle

d)

Bold diamond

7.

The relationship between a weak entity and its owner entity is represented by:

a)

Dashed line

b)

Double diamond

c)

Single diamond

d)

Wavy line

8.

A relationship that involves more than two entities is called:

a)

Binary relationship

b)

Unary relationship

c)

Ternary relationship

d)

Strong relationship

9.

In ER diagrams, a one-to-many relationship is represented by:

a)

1:1

b)

1:N

c)

N:1

d)

M:N

10.

Which of the following is an example of a unary relationship?

a)

Employee manages Employee

b)

Student enrolled in Course

c)

Doctor treats Patient

d)

Supplier supplies Product

11.

Which notation shows total participation in ER diagrams?

a)

Single line

b)

Double line

c)

Dashed line

d)

Wavy line

12.

Which cardinality represents “many-to-many” relationship?

a)

1:1

b)

1:N

c)

N:M

d)

1:0

13.

What is used to uniquely identify an entity in an ER diagram?

a)

Attribute

b)

Primary key

c)

Relationship

d)

Participation

14.

A relationship where an entity is related to itself is called:

a)

Recursive relationship

b)

Weak relationship

c)

Binary relationship

d)

Derived relationship

15.

Which ER model element can have a composite structure?

a)

Entity

b)

Attribute

c)

Relationship

d)

Cardinality

16.

A key attribute in ER diagram is represented by:

a)

Bold oval

b)

Oval with underline

c)

Double oval

d)

Dotted oval

17.

Which of these is NOT a valid type of attribute in ER diagrams?

a)

Simple

b)

Composite

c)

Conditional

d)

Multivalued

18.

In an ER diagram, partial participation means:

a)

All entities participate

b)

Some entities participate

c)

No entities participate

d)

Weak entities participate only

19.

Which of these is a weak entity example?

a)

OrderItem

b)

Customer

c)

Product

d)

Department

20.

The degree of a relationship refers to:

a)

Number of attributes

b)

Number of entities in the relationship

c)

Number of relationships an entity has

d)

Number of keys

21.

Which type of relationship connects two different entity sets?

a)

Binary relationship

b)

Unary relationship

c)

Ternary relationship

d)

Quaternary relationship

22.

Which of these is represented by a double oval?

a)

Multivalued attribute

b)

Derived attribute

c)

Key attribute

d)

Weak entity

23.

Which constraint specifies the number of instances in a relationship?

a)

Participation

b)

Cardinality

c)

Degree

d)

Attribute

24.

Which is true for a weak entity?

a)

Has its own primary key

b)

Depends on a strong entity

c)

Cannot have attributes

d)

Represents only relationships

25.

Which of the following is an identifying relationship?

a)

Connects weak entity to its owner

b)

Connects two strong entities

c)

Connects derived attributes

d)

Connects composite attributes

26.

In ER diagram, a derived attribute is represented by:

a)

Oval with underline

b)

Oval with dashed border

c)

Double oval

d)

Oval with thick border

27.

Which symbol represents an associative entity?

a)

Rectangle inside diamond

b)

Double diamond

c)

Circle

d)

Dotted rectangle

28.

Which is an example of ternary relationship?

a)

Student-Course-Teacher

b)

Student enrolls Course

c)

Doctor treats Patient

d)

Employee manages Employee

29.

An entity that can exist without depending on another entity is called:

a)

Strong entity

b)

Weak entity

c)

Derived entity

d)

Recursive entity

30.

Which of the following is NOT represented in an ER diagram?

a)

Entities

b)

Attributes

c)

SQL queries

d)

Relationships

31.

An ER diagram has 2 entities connected by a one-to-one relationship. After conversion, how many tables are generally created (assuming no merging)?

a)

1

b)

2

c)

3

d)

4

32.

An ER diagram has 3 entities connected by a one-to-many relationship. How many tables will be created?

a)

2

b)

3

c)

4

d)

5

33.

If there are 2 entities with a many-to-many relationship, how many tables will be created?

a)

2

b)

3

c)

4

d)

5

34.

An ER diagram has 4 entities connected in a chain of one-to-one relationships. How many tables will be created without merging?

a)

2

b)

3

c)

4

d)

5

35.

If a weak entity set is present with its owner in a one-to-many identifying relationship, how many tables are needed?

a)

1

b)

2

c)

3

d)

4

36.

For 3 entities connected by binary many-to-many relationships between each pair, how many tables will be created?

a)

3

b)

6

c)

4

d)

5

37.

In a ternary relationship between 3 strong entities, how many tables will be created?

a)

3

b)

4

c)

5

d)

6

38.

If 5 entities are all connected by one-to-one relationships, and no merging is done, how many tables are created?

a)

1

b)

3

c)

5

d)

6

39.

In a one-to-many relationship, where the “many” side is a weak entity, how many tables are required?

a)

1

b)

2

c)

3

d)

4

40.

If there are 2 entities and 1 multivalued attribute in one entity, how many tables will be created?

a)

2

b)

3

c)

4

d)

5

41.

For 4 entities each having a many-to-many relationship with every other entity, how many relationship tables will be added?

a)

6

b)

5

c)

4

d)

3

42.

If 2 entities are connected with a one-to-one relationship and merged into one table, how many tables are created?

a)

1

b)

2

c)

3

d)

4

43.

In a one-to-many relationship, how many separate relationship tables are created?

a)

0

b)

1

c)

2

d)

3

44.

If there is a ternary relationship with all sides having total participation, how many tables are created?

a)

3

b)

4

c)

5

d)

6

45.

If an entity has 2 multivalued attributes, how many tables will be created for that entity alone?

a)

1

b)

2

c)

3

d)

4

46.

If there are 3 strong entities with one many-to-many relationship between two of them and a one-to-many relationship between the other two, how many tables are created?

a)

3

b)

4

c)

5

d)

6

47.

In a binary many-to-many relationship, the number of tables created is:

a)

1

b)

2

c)

3

d)

4

48.

If you have a weak entity with a composite key derived from its owner, how many tables are required for owner and weak entity together?

a)

1

b)

2

c)

3

d)

4

Similar Resources on Wayground

AP Environmental Science Final Exam Review

49 questions

AP Environmental Science Final Exam Review

quiz

Worksheet

•

10th Grade - University

Ch1 - Interrelationships

50 questions

Ch1 - Interrelationships

quiz

Worksheet

•

University

MatSci Prelims

50 questions

MatSci Prelims

quiz

Worksheet

•

University

NUR2474 Module 7 Review

45 questions

NUR2474 Module 7 Review

quiz

Worksheet

•

University

GE ELEC 1 Final Exam

50 questions

GE ELEC 1 Final Exam

quiz

Worksheet

•

University

Transistor &Semiconductor

46 questions

Transistor &Semiconductor

quiz

Worksheet

•

11th Grade - University

Science 10 Diagnostic Test

48 questions

Science 10 Diagnostic Test

quiz

Worksheet

•

10th Grade - University

GE ELEC 1 - Envi Sci

50 questions

GE ELEC 1 - Envi Sci

quiz

Worksheet

•

University