DS0-001 · Question #47
A company needs information about the performance of users in the sales department. Which of the following commands should a database administrator use for this task?
The correct answer is D. SELECT. SELECT is the correct choice because it is the SQL command used to retrieve data from a database - exactly what's needed when a manager wants to view or report on user performance. The other options are all Data Manipulation Language (DML) commands that modify data: DROP…
Question
A company needs information about the performance of users in the sales department. Which of the following commands should a database administrator use for this task?
Options
- ADROP
- BUPDATE
- CDELETE
- DSELECT
How the community answered
(17 responses)- A18% (3)
- B6% (1)
- C6% (1)
- D71% (12)
Explanation
SELECT is the correct choice because it is the SQL command used to retrieve data from a database - exactly what's needed when a manager wants to view or report on user performance. The other options are all Data Manipulation Language (DML) commands that modify data: DROP removes entire tables or database objects entirely, DELETE removes rows from a table, and UPDATE changes existing data values. None of those retrieve information - they destroy or alter it.
Memory tip: Think of SELECT as "selecting items off a shelf to look at them" - you're reading, not changing anything. If you remember that the other three (DROP, DELETE, UPDATE) all change the database in some way, SELECT is the only safe, read-only option.
Topics
Community Discussion
No community discussion yet for this question.