HomeInterview QuestionsSql, Identifiers, Quoting

Column names should be kept in double quotes.

🟢 Easy Conceptual Fresher level
1 Times asked
Mar 2026 Last seen
Mar 2026 First seen

💡 Model Answer

In SQL, identifiers such as table names, column names, and aliases can be quoted to preserve case sensitivity, allow spaces, or use reserved words. Double quotes ("identifier") are the standard ANSI SQL quoting mechanism. For example, "User" is a valid column name even though USER is a reserved keyword. Quoted identifiers are case-sensitive in many databases (e.g., PostgreSQL), so "User" and "user" are distinct. Unquoted identifiers are usually folded to upper case (in Oracle) or lower case (in MySQL) and cannot contain spaces or special characters. Therefore, when you need to use a name that conflicts with a keyword or contains special characters, wrap it in double quotes.

This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.

🎤 Get questions like this answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.

Get Assisting AI — Starts at ₹500