How are identifiers quoted in MySQL?
A. single quotes
B. double quotes
C. backticks
D. can't be quoted
Answer: Option C
Solution(By Examveda Team)
In MySQL, identifiers such as table names, column names, database names, etc., are quoted using backticks.Using backticks is optional for identifiers unless the identifier matches a reserved word or contains special characters.
Option A, single quotes, is incorrect because single quotes are used to denote string literals, not identifiers, in MySQL.
Option B, double quotes, is incorrect because double quotes are also used to denote string literals, not identifiers, in MySQL.
Option D, can't be quoted, is incorrect because identifiers can indeed be quoted in MySQL, especially when they contain special characters or match reserved words.
Join The Discussion