Examveda

Which among the following tags belong to Data Manipulation language?

A. UPDATE

B. ALTER

C. MODIFY

D. All of the mentioned

Answer: Option D

Solution (By Examveda Team)

This question is about Data Manipulation Language (DML) in MySQL. DML is used to modify the data in your database. Let's break down the options:
Option A: UPDATE
The UPDATE statement is used to change existing data within a table. It's like editing information in a spreadsheet.
Option B: ALTER
The ALTER statement is used to modify the structure of a table. This is like changing the columns or rows in a spreadsheet. It's not about changing the data itself.
Option C: MODIFY
The MODIFY statement is similar to ALTER. It's used to change the structure of a table, but it's often used to specifically change the definition of an existing column.
Option D: All of the mentioned
Since UPDATE deals with changing data, and ALTER and MODIFY are about changing table structure, not data, Option D is incorrect.
The Correct Answer: Option A: UPDATE
Remember, DML is about managing the data itself, not the table's layout.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous