Which of the following commands should the administrator use?

A systems administrator wants to return results for a time range within a database.

Which of the following commands should the administrator use?
A . SELECT
B . INSERT
C . DELETE
D . UPDATE

View Answer

Answer: A

Explanation:

A SELECT command is a SQL (Structured Query Language) statement that is used to return results for a time range within a database. A SELECT command can specify the columns and rows to be retrieved from one or more tables based on certain criteria or conditions. A SELECT command can also use functions or operators to manipulate or filter the data. For example, a SELECT command can use the BETWEEN operator to specify a time range for a date column89.

Reference: = CompTIA IT Fundamentals (ITF+) Study Guide, 2nd Edition, Chapter 5: Database Fundamentals3; SQL SELECT

Statement – W3Schools10