Re: group functions

hpuxrac wrote:

> 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.
>
> Why don't you talk to the person that is teaching the class?

Hai to all who answered,

I am preparing for my OCA and got those questions from the Oracle Ppres's OCA Exam Guide. Thats all the information they gave in the book. So, I can't really ask anyone how it works.

The answers given in the book are D for the 1st question and A& C for the 2nd question. I don't know how that happened.

If you have any clue n whats happening in this scenario do update me.

Thanks a bunch

Big Learner Received on Sun Dec 03 2006 - 22:25:52 CST