CIW CIW Database Design Specialist 2

Question 1

Which normal form requires that every non-key attribute be fully functionally dependent on the entire primary key?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 2

What is an entity-relationship (ER) diagram used for in database design?

Accepted Answer

Visually model data entities, attributes, and their relationships

Answer

Document SQL query execution plans

Answer

Monitor database server performance

Answer

Generate automatic backups

Question 3

Which SQL command permanently removes all rows from a table but keeps the table structure?

Accepted Answer

TRUNCATE

Answer

DROP TABLE

Answer

DELETE

Answer

REMOVE

Question 4

What is the purpose of a database index?

Accepted Answer

Speed up data retrieval operations on a table

Answer

Encrypt sensitive columns

Answer

Enforce data validation rules

Answer

Compress table storage

Question 5

In a one-to-many relationship, how is the relationship typically implemented in a relational database?

Accepted Answer

By placing a foreign key in the 'many' side table referencing the 'one' side

Answer

By duplicating the table

Answer

By merging both tables into one

Answer

By using a junction table

Question 6

Which SQL aggregate function returns the number of rows that match a specified condition?

Accepted Answer

COUNT()

Answer

SUM()

Answer

AVG()

Answer

TOTAL()