Q909
What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5;
A.
column name
B.
table name
AnswerC.
row name
D.
database name
Answer: Option B
Solution
Answer: Option B
Solution:
This SQL statement is used to delete data from a table. Let's break it down:
DELETE FROM - This part tells the database we want to remove data.
xyz - This is the name of the table where we want to delete data.
WHERE abc = 5 - This is a condition that specifies which data to delete. It means we'll delete only the rows where the column named 'abc' has the value 5.
So, the answer is Option B: table name
xyz represents the name of the table from which data will be deleted.