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

Access, Control, Integrity, Data

Answer

Atomicity, Concurrency, Index, Durability

Answer

Authorization, Consistency, Integrity, Deployment

Question 2

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

Accepted Answer

HAVING

Answer

WHERE

Answer

FILTER

Answer

AND

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

One-to-one

Answer

One-to-many

Answer

Self-referencing

Question 4

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

Accepted Answer

NOT NULL

Answer

UNIQUE

Answer

DEFAULT

Answer

CHECK

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 saved SELECT query only

Answer

An automatic backup routine

Answer

A data encryption method

Question 6

In database design, what is denormalization?

Accepted Answer

Intentionally introducing redundancy to improve read performance

Answer

Removing all indexes from a database

Answer

Converting a relational database to flat files

Answer

Encrypting database columns