Which of the following statements does not modify the table?
A. INSERT
B. UPDATE
C. DELETE
D. SELECT
Answer: Option D
Solution (By Examveda Team)
This question asks about what Data Manipulation Language (DML) commands are used to change data in a table.DML commands are like tools that let you add, change, or remove data from a database.
Here's a breakdown of each option:
* Option A: INSERT: This command adds new rows of data to a table. So it does modify the table.
* Option B: UPDATE: This command changes the existing data in a table. So it does modify the table.
* Option C: DELETE: This command removes rows of data from a table. So it does modify the table.
* Option D: SELECT: This command retrieves data from a table, but it doesn't change anything in the table.
Therefore, the answer is Option D: SELECT.
SELECT is used to read data, not to modify it.

Join The Discussion