Total Pageviews

February 26, 2015

2/26/2015 08:52:00 AM

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

    Related Posts Plugin for WordPress, Blogger...