Which SQL statement is used to retrieve data from a database?

Which SQL statement is used to retrieve data from a database?

• A. UPDATE
• B. DELETE
• C. SELECT
• D. INSERT

Answer: (C)

Retrieving data from a database is done with a SELECT statement. SELECT asks the database to return a result set, letting you choose which columns to see (or use * for all), and from which table with a FROM clause. You can further refine, sort, or group the results with additional clauses, but the core idea is to read data rather than modify it. Other statements serve different purposes: UPDATE changes existing rows, DELETE removes rows, and INSERT adds new rows. So, when you want to read data, the SELECT statement is the right choice.

Retrieving data from a database is done with a SELECT statement. SELECT asks the database to return a result set, letting you choose which columns to see (or use * for all), and from which table with a FROM clause. You can further refine, sort, or group the results with additional clauses, but the core idea is to read data rather than modify it. Other statements serve different purposes: UPDATE changes existing rows, DELETE removes rows, and INSERT adds new rows. So, when you want to read data, the SELECT statement is the right choice.