Total Pageviews

February 25, 2015

2/25/2015 07:22:00 PM

  • Plsql Questions4

  • 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.