Multiple choice technology databases

When SET QUOTED_IDENTIFIER is ON which will be true?

  1. Identifiers can be delimited by double quotation marks, and literals can not be delimited by single quotation marks

  2. Identifiers can be delimited by double quotation marks, and literals must be delimited by single quotation marks

  3. Identifiers can not be delimited by double quotation marks, and literals must be delimited by single quotation marks

  4. Identifiers can not be delimited by double quotation marks, and literals can not be delimited by single quotation marks
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When SET QUOTED_IDENTIFIER is ON, double quotation marks are used to delimit identifiers (such as table or column names), whereas single quotation marks must be used to delimit literal strings. Other options incorrectly describe double quotes for literals or restrict identifier delimiting.

Keep practicing — related questions