Examveda

What is abc in the following SQL statement?
DELETE FROM xyz WHERE abc = 5;

A. column name

B. table name

C. row name

D. database name

Answer: Option A

Solution (By Examveda Team)

This SQL statement is used to delete rows from a table. Let's break it down:

DELETE FROM xyz : This part tells the database to delete rows from the table named xyz.
WHERE abc = 5 : This part specifies which rows to delete. It means "delete the rows where the column named abc has a value of 5".

So, abc in this statement represents the column name in the table xyz.

Therefore, the correct answer is Option A: column name.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous