Question

To perform a delete on a single-table, how is the name of a column qualified?

(a) qualification not necessary

(b) column name

(c) table name

(d) database name

This question was addressed to me in final exam.

This interesting question is from Multiple topic in section Using SQL to Manage Data of MySQL

Answer 1

Right option is (a) qualification not necessary

The best I can explain: In MySQL, performing the operations ‘UPDATE’ and ‘DELETE’ on a single-table does not require qualifying the column name of the table in the database with the table name of the database.