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 action does the % operator accomplish in MySQL?

Options :

A : Raises a numeric value to the power of another

B : Compares two numeric values for equality

C : Divides two numeric values and returns the remainder

D : Subtracts a numeric value from another

Answer: C

Question 3

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 4

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

Question 5

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