Re: group functions

BigLearner wrote:
> 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%'?
>
> A. 6000
> B. 9925
> C. 9975
> D. 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

Question B is an invalid question. The answer is SCOTT with 09-DEC-82 or MARTIN with 28-SEP-81. There is insufficient information to know if FILLER could be included - if there is a time component of the HIREDATE that is anything other than midnight, then FILLER could be a possible answer.

Why SCOTT? Why MARTIN? Has the author of this question placed the contents of the date into a VARCHAR2 or a DATE column?

Invalid question.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Sun Dec 03 2006 - 09:40:03 CST