Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous