CPA Database Administration 3

Question 1

What is a database view?

Accepted Answer

A virtual table defined by a stored SELECT query

Answer

A view is a named, stored SQL query that behaves like a virtual table; it does not store data itself unless it is a materialized view.

Question 2

Which normal form eliminates transitive dependencies?

Accepted Answer

Third Normal Form (3NF)

Answer

3NF requires that every non-key attribute depend only on the primary key, eliminating transitive dependencies between non-key columns.

Question 3

What does an INNER JOIN return?

Accepted Answer

Only rows where there is a match in both tables

Answer

INNER JOIN returns only the rows where the join condition is satisfied in both tables, excluding non-matching rows from either side.

Question 4

Which constraint ensures that a column value in one table exists as a primary key in another table?

Accepted Answer

FOREIGN KEY constraint

Answer

A FOREIGN KEY constraint enforces referential integrity by requiring that the column value matches a primary key in the referenced table.

Question 5

What is the purpose of the ROLLBACK statement in SQL?

Accepted Answer

Undo all changes made since the last COMMIT or SAVEPOINT

Answer

ROLLBACK undoes all data modifications made within the current transaction, restoring the database to its state before the transaction began.

(CPA) Certified Associate Programmer Practice Test