1)You must retrieve worker details from the work
table and process them in a PL/SQL block. Which variable type must be created in the PL/SQL block to
retrieve all rows and columns using a single SELECT statement from the work
table?
ans)PL/SQL table of records.
2)GROUP BY dept_no
3)
a SELECT divisionno, AVG(sal)
FROM work
WHERE divisionno IN(3,6)
GROUP BY divisionno
HAVING AVG (sal)>=3100;
4)d.HAVING COUNT (*)>10
5)
Select inventory, NVL(TO=CHAR(shipdate) 'Not
NVL (To char(total), 'not available')Shipped'')
FROM order.
6)
d Select last name, first name.
FROM work
WHERE LOWER(lastname)=('smith');
7)
a.SELECT custid, orderdate, shipdate,
ROUND(MONTHS-BETWEEN(shipdate,orderdate))
''Time Taken''
FROM ord;
8)a. The first name values in the database are in
lower case.
9)c. An index is created for the purchase_no column.
10)b. Use the ALTER TABLE command with the ADD clause
on the EMP table.
