1)c. UPDATE worker
SET job = ‘Administrative Assistant’
WHERE UPPER(job) = ‘Secretary’;
2)c. TRUNCATE TABLE color.
3)b. Execution.
4)b. A variable defined in the outer block is visible in the inner blocks.
5)d. Insert the statement:
DBMS_OUTPUT .PUT_LINE (I ||’’|| TO_CHAR(v_date));
Between lines 8-9
6)c. IF (v_sal.GT.10000) THEN
7)c. Last name and first name of all workers with the same salary as workers in divisions 3 and 5.
8)c. Equal operators.
9)a. Updates on the table will be slower.
10)d. The need to qualify object names with the schema is eliminated for all users.
