Multiple choice technology databases

select "aa" from dual ?

  1. Error: "aa":invalid identifier

  2. aa

  3. "aa"

  4. Error: invalid character
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle, double quotes are for identifiers like column/table names, not string literals. String literals require single quotes. "aa" with no column named aa causes invalid identifier error. This is standard Oracle SQL behavior.

Keep practicing — related questions