ExamGecko
Question list
Search
Search

Question 17 - DS0-001 discussion

Report
Export

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
Answers
A.
Option A
B.
Option B
Answers
B.
Option B
C.
Option C
Answers
C.
Option C
D.
Option D
Answers
D.
Option D
Suggested answer: A

Explanation:

The statement that the administrator should use to remove inactive customers from a database is option A. This statement uses theDELETEcommand to delete all the rows from thecustomertable where thestatuscolumn 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.

asked 02/10/2024
Tim Baas
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first