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

This statement will fail due to syntax errors: there are extra spaces (select, ename, emp) and the string literal Scott is not properly quoted with single quotes. SQL requires single quotes for string literals.

Keep practicing — related questions