group functions

From: BigLearner <Small.Learner_at_gmail.com>
Date: 1 Dec 2006 23:15:35 -0800
Message-ID: <1165043735.389077.226480@73g2000cwn.googlegroups.com>

Dear Budiess,

Another doubt from group functions.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

------------ ------------  ------------------  --------
-----------------  ------- ----------- -------------
7369      SMITH    CLERK          7902  17-DEC-80    800
20
7499      ALLEN    SALESMAN  7698  20-FEB-81   1600     300    30
7521      WARD    SALESMAN  7698  22-FEB-81    1250    500    30
7566      JONES   MANAGER    7839  02-APR-81    2975             20
7654      MARTIN  SALESMAN  7698  28-SEP-81    1250  1400    30
7698      BLAKE   MANAGER    7839  01-MAY-81   2850              30
7782      CLARK   MANAGER    7839  09-JUN-81    2450              10
7788      SCOTT   ANALYST      7566  09-DEC-82   3000              20
7839      KING      PRESIDENT           17-NOV-81   5000
10
7844      TURNER SALESMAN  7698  08-SEP-81   1500       0      30
7876      ADAMS  CLERK         7788  12-JAN-82     1100              20
7900      JAMES   CLERK         7698  03-DEC-81    950
30
7902      FORD     ANALYST     7566  03-DEC-81   3000               20
7934      FILLER   CLERK         7782  23-JAN-82    1300

10

Which of the following choices identifies the value tha would be returned from the following query: select sum(sal) + sum(comm) from emp where job = 'ANALYST' or ename like 'J%'?

1. 6000
2. 9925
3. 9975
4. NULL

Which of the following choices identify the value returned by Oracle whn you issue the following query : select * from emp where hiredate > '23-JAN-82'? (Choose two.)

A. ADAMS
B. MILLER
C. SCOTT
D. SMITH

I got these answers wrong so thought of asking you guys if you know the right answer.

Really expecting a speedy feedbak.

Thank you.

BigLearner Received on Sat Dec 02 2006 - 01:15:35 CST