Which of the following is an example of a Data Retrieval Language statement?

Which of the following is an example of a Data Retrieval Language statement?

• A. UPDATE
• B. CREATE
• C. SELECT
• D. GRANT

Answer: (C)

Data Retrieval Language is about reading data from the database and returning it as a result set. The statement that does this is the one used to query tables, specify which columns to fetch, and optionally filter or order the results. That retrieval-focused command is what makes it an example of a Data Retrieval Language statement. In contrast, the other options perform different tasks: one updates existing data in a table, another defines new database objects, and the last manages who can access data. So the statement that retrieves data best fits Data Retrieval Language.

Data Retrieval Language is about reading data from the database and returning it as a result set. The statement that does this is the one used to query tables, specify which columns to fetch, and optionally filter or order the results. That retrieval-focused command is what makes it an example of a Data Retrieval Language statement.

In contrast, the other options perform different tasks: one updates existing data in a table, another defines new database objects, and the last manages who can access data. So the statement that retrieves data best fits Data Retrieval Language.