Which SQL statement is used to retrieve data from a database?
- DELETE
- INSERT
- SELECT
- UPDATE
The SQL SELECT statement is used to retrieve data from a database. It allows you to specify which columns you want to retrieve and which table(s) you want to retrieve the data from. Additionally, you can use various clauses like WHERE, ORDER BY, and GROUP BY to filter, sort, and group the retrieved data. In database testing, SELECT statements are commonly used to verify the correctness of data by querying specific tables and comparing the expected results with the actual results obtained from the database.
Loading...
Related Quiz
- What is the primary objective of authentication testing?
- Which of the following is NOT a common authentication method used in applications?
- When testing a database schema, what is the role of normalization?
- When conducting scalability testing, ____________ tools are often used to simulate a large number of concurrent users.
- Which SQL command is used to raise a custom error message in a query?