Vidyalelo
MySQL · Q995

MySQL

Programming · MySQL · question 995

Q995

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

A.
column name
Answer
B.
table name
C.
row name
D.
database name

Answer: Option A

Solution

Answer: Option A
Solution:
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.