CPA Database Administration 4

Question 1

Which SQL statement is used to add a new column to an existing table?

Accepted Answer

ALTER TABLE ... ADD

Answer

ALTER TABLE followed by ADD allows you to add one or more new columns to an existing table without recreating it.

Question 2

What is a deadlock in a database context?

Accepted Answer

Two or more transactions each waiting for the other to release a lock

Answer

A deadlock occurs when two or more transactions are mutually blocking each other, each waiting for a lock held by the other to be released.

Question 3

Which SQL function returns the current date and time on the database server?

Accepted Answer

NOW()

Answer

NOW() is the standard SQL function that returns the current date and time as reported by the database server at query execution.

Question 4

In database design, what does ERD stand for?

Accepted Answer

Entity Relationship Diagram

Answer

An Entity Relationship Diagram visually models the entities in a system, their attributes, and the relationships between them.

Question 5

What is the difference between TRUNCATE and DELETE in SQL?

Accepted Answer

TRUNCATE removes all rows without logging individual deletions; DELETE logs each row removal

Answer

TRUNCATE is a DDL operation that quickly removes all rows by deallocating data pages, while DELETE is a DML operation that logs each row deletion individually.

(CPA) Certified Associate Programmer Practice Test

(CPA) Certified Associate Programmer Practice Test

CPA Database Administration 4