ICC Database Management 3

Question 1

Which backup strategy captures only the data changed since the last full backup, minimizing backup time?

Accepted Answer

Incremental backup

Answer

An incremental backup captures only changes made since the last backup of any type, making it faster and smaller than a differential backup.

Question 2

A permit database administrator wants to audit all changes to the inspections table. Which database feature should be implemented?

Accepted Answer

Database triggers

Answer

Database triggers automatically execute defined actions in response to INSERT, UPDATE, or DELETE events, enabling comprehensive audit logging.

Question 3

What does a database deadlock occur when two or more transactions are each waiting for the other to release?

Accepted Answer

Lock

Answer

A deadlock occurs when transactions hold locks on resources the other needs, creating a circular wait that prevents both from proceeding.

Question 4

In a building permit system, which query optimization technique stores the results of a frequently executed subquery?

Accepted Answer

Common Table Expression (CTE)

Answer

A CTE defines a named temporary result set that can be referenced multiple times within the same query, improving readability and sometimes performance.

Question 5

Which database object provides a virtual table based on a stored SELECT query, simplifying complex joins for code enforcement reports?

Accepted Answer

View

Answer

A view is a stored query that presents data from one or more tables as if it were a single virtual table, simplifying access to complex data.

(ICC) International Code Council Practice Test

(ICC) International Code Council Practice Test

ICC Database Management 3