What is abc in the following SQL statement?
DELETE FROM xyz WHERE abc = 5;
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.

Join The Discussion