CPA Database Administration 2

Question 1

Which SQL clause is used to filter rows after aggregation has been applied?

Accepted Answer

HAVING

Answer

HAVING filters groups produced by GROUP BY, whereas WHERE filters individual rows before aggregation.

Question 2

A table has no primary key defined. Which term best describes such a table?

Accepted Answer

Heap table

Answer

A heap table is a table stored without any ordered index or defined primary key, resulting in unordered row storage.

Question 3

Which isolation level prevents dirty reads but still allows non-repeatable reads?

Accepted Answer

Read Committed

Answer

Read Committed prevents dirty reads by only seeing committed data, but another transaction can modify the row between two reads in the same transaction.

Question 4

What does the SQL keyword DISTINCT do in a SELECT statement?

Accepted Answer

Removes duplicate rows from the result

Answer

DISTINCT eliminates duplicate rows from the query result so each unique combination of selected columns appears only once.

Question 5

Which type of database index is most efficient for range queries on a column?

Accepted Answer

B-tree index

Answer

B-tree indexes maintain sorted order, making them ideal for range queries using operators like BETWEEN, <, and >.

(CPA) Certified Associate Programmer Practice Test

(CPA) Certified Associate Programmer Practice Test

CPA Database Administration 2