Question 1

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 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

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

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 5

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