Database Management System Quiz

Explain the Union, Group by and Having Clauses.

What does the Group By Clause do?

• It aggregates data rows with the same values.

• It filters data rows based on a condition.

• It combines two tables.

• It sorts the results.

What is the purpose of the Having Clause?

• To filter results after aggregation.

• To sort the results.

• To combine multiple queries.

• To limit the number of results.

What is the syntax for the Group By Clause?

What does the MySQL Union Operator do?

• It combines the results of multiple SELECT statements.

• It filters duplicate results.

• It sorts the results.

• It aggregates data.

What are the rules for the First Normal Form?

What is the Second Normal Form?

What is the Third Normal Form (3NF)?

• A relation in 2NF with no transitive dependencies.

• A relation in 1NF with no partial dependencies.

• A relation that has multiple candidate keys.

• A relation that is not in any normal form.

What must a database be in to achieve Third Normal Form?

• Only in First Normal Form.

• In First and Second Normal Form.

• In Second Normal Form only.

• In Third Normal Form already.

What is an example of a transitive dependency?

• A dependency where one non-prime attribute depends on another non-prime attribute.

• A dependency where a primary key determines a non-prime attribute.

• A dependency where a composite key determines all attributes.

• A dependency that does not exist in a normalized database.