ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

How are identifiers quoted in MySQL?

Answer & Solution
Correct Answer: Option C
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.