Question 1

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

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