Total Pageviews

February 25, 2015

2/25/2015 01:16:00 AM



  • Plsql Questions-2





  • 1)a. SELECT * FROM ANN_SAL
    2)b. 500
    3)d. The results will be the same, but will be displayed differently
    4)d. DECLARE
    TYPE worker-table is TABLE of worker%ROWTYPE
    INDEX BY BINARY INTEGER.
    worker-table  worker-table-type;
    5)d. A cursor that uses parameters.
    6)d. You do not explicitly open, fetch, or close a cursor within a cursor for loop.
    7)b. DBMS.OUTPUT.PUT_LINE(house-rec-loc);
    8)a. They are declared implicitly only for DML statements
    9)a. 0
    10)a. Select statement does not return a row.
       b. Select statement returns more than one row.
    11)c. DECLARE
    v-hiredate DATE:=SYSDATE:
    BEGIN
    INSERT INTO worker(workernp, wname, hiredate)
    VALUES(workerno-sequence.nextval, ‘and name’, v_hiredate and               divisionno);
    END;
    12)d. 8
    13)d. The need to qualify the object name with its schema is eliminated for all users.
    14)b. WHERE, GROUPBY, HAVING
    15)b. A WHERE clause cannot be used to restrict groups.
    16)c. The first statement will display a result for each part; the second statement will display a result for each product
    17)b. Executable
    18)c. START welcome.sql
    19b. A variable defined in the outer block is visible in the inner block
    20)c. SELECT wname,sal
       INTO w_ename,w_sal
       FROM worker
       WHERE
       workno=106;
    21)b. SPOOL LOG.LST
    22)b. The results provide more information than management requested.
    23)c. SELECT distinct divisionno, job
    FROM worker;
    24)a. All employees have a manager.


     
    Related Posts Plugin for WordPress, Blogger...