Which operation is used to retrieve data by listing the fields to include?

• A. Update
• B. Add
• C. Select
• D. Text

Answer: (C)

Retrieving data by listing the fields to include is done with a SELECT statement. In SQL, you specify exactly which columns you want in the result by listing them after SELECT, like: SELECT id, name FROM customers;. If you want every column, you’d use SELECT * FROM table. The list after SELECT decides which fields appear in the output.

The other terms don’t fit because Update changes existing data in rows, not the fields returned; Add isn’t a data-retrieval operation in SQL ( INSERT adds new rows, or ALTER can add structures); Text isn’t a SQL command for retrieving data.