Which of the following statements should the administrator use?

A database administrator wants to remove inactive customers from a database.

Which of the following statements should the administrator use?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

View Answer

Answer: A

Explanation:

The statement that the administrator should use to remove inactive customers from a database is option A. This statement uses the DELETE command to delete all the rows from the customer table where the status column is equal to ‘inactive’. The other options either have syntax errors, use incorrect commands, or do not specify the condition correctly.

Reference: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.2 Given a scenario, execute database tasks using scripting and programming languages.