Multiple choice technology databases

The following block statement will run successfully SCOTT.EMP.EMPNO := 1234;

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This statement will fail because you cannot directly assign a value to a table column using the syntax SCOTT.EMP.EMPNO := 1234. To modify data in a table, you must use UPDATE or INSERT statements. Direct assignment like this is only valid for PL/SQL variables, not database table columns.

Keep practicing — related questions