CIW CIW Database Design Specialist 3

Question 1

What does ACID stand for in the context of database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID stands for Atomicity, Consistency, Isolation, and Durability — the four properties that guarantee reliable database transactions.

Question 2

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

Accepted Answer

HAVING

Answer

The `HAVING` clause filters the result of GROUP BY aggregations, similar to how WHERE filters individual rows.

Question 3

What type of relationship exists when a row in Table A can relate to many rows in Table B, and a row in Table B can also relate to many rows in Table A?

Accepted Answer

Many-to-many

Answer

A many-to-many relationship requires a junction (bridge) table containing foreign keys to both related tables.

Question 4

Which SQL constraint ensures that a column cannot store NULL values?

Accepted Answer

NOT NULL

Answer

The `NOT NULL` constraint prevents a column from accepting NULL values, requiring every row to have a valid value in that column.

Question 5

What is a stored procedure in a relational database?

Accepted Answer

A precompiled set of SQL statements stored in the database that can be executed by name

Answer

A stored procedure is a precompiled collection of SQL statements saved in the database and executed as a single callable unit.

CIW - Certified Internet Web Professional Practice Test

CIW - Certified Internet Web Professional Practice Test

CIW CIW Database Design Specialist 3