Question 1

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 2

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 3

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

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