Group functions

From: BigLearner <Small.Learner_at_gmail.com>
Date: 2 Dec 2006 21:08:15 -0800
Message-ID: <1165122495.458864.55640@j44g2000cwa.googlegroups.com>

Haiiiiii everyone!

I am a new member to this group.

I have doubt on a this question. I got the answer wrong and wonder how it could be.

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

Received on Sat Dec 02 2006 - 23:08:15 CST