Multiple choice technology databases

SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This SQL statement has multiple syntax errors: mismatched parentheses and incorrect quote types. The statement starts with SELECT( but the closing parenthesis is after NVL. Also, the quotes around 'INVALID' are curly quotes instead of straight quotes, which are invalid in SQL.