Question 1

What is the second step in the implement relationships stage of database design?

Options :

A : Implement weak entities

B : Implement one-one relationships

C : Implement subtype entities

D : Specify cascade

Answer: B

Question 2

Which clause is used to specify the join columns when performing a join in MySQL?

Options :

A : AS

B : JOIN

C : ON

D : AND

Answer: C

Question 3

What is the last step in the logical design process for designing a database?

Options :

A : Analyze data requirements

B : Apply a normal form

C : Determine cardinality

D : Discover entities

Answer: B

Question 4

Which main characteristic is used to differentiate between strong and weak entities in the process of database design?

Options :

A : Association

B : Primary key

C : Foreign key

D : Cardinality

Answer: B

Question 5

Which phase of entity-relationship modeling refers to the maxima and minima of relationships and attributes?

Options :

A : Cardinality

B : Physical design

C : Attribute minimum

D : Partition

Answer: A

Free Data-Management-Foundations Mock Exam – Practice Online Confidently