Examveda

What is xyz 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 B

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous