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

Sort rows alphabetically

Answer

Encrypt the table data

Answer

Define the table's default sort order

Question 2

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

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

FETCH

Question 3

What does normalization in database design primarily aim to eliminate?

Accepted Answer

Data redundancy and update anomalies

Answer

Indexes

Answer

NULL values

Answer

Foreign keys

Question 4

Which type of SQL JOIN returns only rows where there is a match in both tables?

Accepted Answer

INNER JOIN

Answer

LEFT JOIN

Answer

RIGHT JOIN

Answer

FULL OUTER JOIN

Question 5

In relational database terminology, what is a foreign key?

Accepted Answer

A column that references the primary key of another table

Answer

An encrypted primary key

Answer

A key used for remote database access

Answer

A composite key with two columns

Question 6

What does the SQL `GROUP BY` clause do?

Accepted Answer

Groups rows with the same values so aggregate functions can be applied per group

Answer

Sorts the result set in ascending order

Answer

Filters rows before aggregation

Answer

Joins two tables together