Multiple choice technology databases

Select ename from emp where ename =”Scott”; This select statement executes successfully.

  1. True

  2. False

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

The SQL statement will fail because string literals in SQL must be enclosed in single quotes, not double quotes. The correct syntax would be: ename = 'Scott'. Double quotes are for identifiers, not string values.