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.
