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

Second Normal Form (2NF) requires full functional dependency on the whole primary key, eliminating partial dependencies.

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

An ER diagram is a visual tool that represents the data model, showing entities, their attributes, and how they relate to each other.

Question 3

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

Accepted Answer

TRUNCATE

Answer

The `TRUNCATE` command deletes all rows from a table quickly and cannot be rolled back in most databases, while preserving the table schema.

Question 4

What is the purpose of a database index?

Accepted Answer

Speed up data retrieval operations on a table

Answer

A database index creates a separate data structure that allows the database engine to find rows much faster without scanning the entire table.

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

A one-to-many relationship is implemented by adding a foreign key column in the child ('many') table that references the parent ('one') table's primary key.

CIW - Certified Internet Web Professional Practice Test

CIW - Certified Internet Web Professional Practice Test

CIW CIW Database Design Specialist 2