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 command that the database administrator should use for this task is SELECT. The SELECT command is a SQL statement that retrieves data from one or more tables or views in a database. The SELECT command can also use various clauses or options to filter, group, sort, or aggregate data according to specific criteria or conditions. By using the SELECT command, the database administrator can obtain information about the performance of users in the sales department, such as their sales volume, revenue, commission, etc. The other options are either not related or not suitable for this task. For example, DROP is a SQL command that deletes an existing table or object from a database; UPDATE is a SQL command that modifies existing data in one or more rows of a table; DELETE is a SQL command that removes existing data from one or more rows of a table. References: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.2 Given a scenario, execute database tasks using scripting and programming languages.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit