CPA Database Administration 5

Question 1

Which SQL keyword is used to sort query results in descending order?

Accepted Answer

ORDER BY ... DESC

Answer

Adding DESC after a column name in the ORDER BY clause sorts the result set from highest to lowest value for that column.

Question 2

What does the ACID property 'Durability' guarantee?

Accepted Answer

Once committed, a transaction's changes survive system failures

Answer

Durability ensures that once a transaction is committed, its changes are permanently saved even if the system crashes immediately afterward.

Question 3

Which SQL clause is used to combine rows from two SELECT statements into one result set without duplicates?

Accepted Answer

UNION

Answer

UNION combines the results of two SELECT statements and automatically removes duplicate rows; UNION ALL retains duplicates.

Question 4

In relational databases, what is referential integrity?

Accepted Answer

Guaranteeing that foreign key values always reference valid primary keys

Answer

Referential integrity ensures that every foreign key value in a child table corresponds to an existing primary key in the parent table.

Question 5

What is a database schema?

Accepted Answer

The logical structure defining tables, columns, relationships, and constraints

Answer

A schema is the logical blueprint of a database, describing the structure of tables, data types, relationships, and constraints without containing actual data.

(CPA) Certified Associate Programmer Practice Test

(CPA) Certified Associate Programmer Practice Test

CPA Database Administration 5