Which of the following is generally a benefit of normalisation? Performance is i

ID: 3607408 • Letter: W

Question

Which of the following is generally a benefit of normalisation?

Performance is improved

Insertion anomalies are avoided

Selection anomalies are avoided

Number of tables is reduced

None of the above

MySQL is ACID compliant.

True

False

Which of the following statement is CORRECT about normalisation?

A database that is not in at least third normal form cannot be implemented with MySQL.

A database that is only is first normal form would breach the CAP theorem.

Normalisation ensures consistent formatting, for example that all the phone numbers would have the same number of digits.

All of the above

None of the above

Performance is improved

Insertion anomalies are avoided

Selection anomalies are avoided

Number of tables is reduced

None of the above

MySQL is ACID compliant.

True

False

Which of the following statement is CORRECT about normalisation?

A database that is not in at least third normal form cannot be implemented with MySQL.

A database that is only is first normal form would breach the CAP theorem.

Normalisation ensures consistent formatting, for example that all the phone numbers would have the same number of digits.

All of the above

None of the above

1 Answer) Insertion anomalies are avoided
2 Answer) True
3 Answer) None of the above

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.