CIW CIW Database Design Specialist

Question 1

What is the primary purpose of a primary key in a relational database table?

Accepted Answer

Uniquely identify each row in the table

Answer

A primary key uniquely identifies every record in a database table and cannot contain NULL values.

Question 2

Which SQL statement is used to retrieve data from a database?

Accepted Answer

SELECT

Answer

The SQL `SELECT` statement queries a database and returns a result set of matching rows.

Question 3

What does normalization in database design primarily aim to eliminate?

Accepted Answer

Data redundancy and update anomalies

Answer

Normalization restructures tables to minimize data redundancy and prevent insertion, update, and deletion anomalies.

Question 4

Which type of SQL 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 5

In relational database terminology, what is a foreign key?

Accepted Answer

A column that references the primary key of another table

Answer

A foreign key is a column (or set of columns) that establishes a link between data in two tables by referencing the primary key of another table.

CIW - Certified Internet Web Professional Practice Test