ICT Database Management Concepts 2

Question 1

Which SQL clause is used to filter records after a GROUP BY operation?

Accepted Answer

HAVING

Answer

HAVING filters grouped results, while WHERE filters rows before grouping occurs.

Question 2

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID properties ensure reliable database transactions: Atomicity, Consistency, Isolation, and Durability.

Question 3

Which type of join returns only rows where there is a match in both tables?

Accepted Answer

INNER JOIN

Answer

An INNER JOIN returns only the rows that have matching values in both joined tables.

Question 4

What is a foreign key in a relational database?

Accepted Answer

A column that references the primary key of another table

Answer

A foreign key is a field in one table that refers to the primary key in another table, establishing a relationship.

Question 5

Which normal form eliminates transitive functional dependencies?

Accepted Answer

Third Normal Form (3NF)

Answer

3NF removes transitive dependencies, ensuring non-key attributes depend only on the primary key.

ICT - Information Communication Technology Practice Test