A SQL & PL/SQL practice question

From: Dino Hsu <dino1_nospam_at_ms1.hinet.net>
Date: Sat, 21 Jul 2001 21:23:30 GMT
Message-ID: <nnp2ktomrsm0e1v9tfkskv1c9j2q1b4lhn@4ax.com>

Dear all,

A practice question is:

Which line in the following select statement will produce an error?

A.there are no errors in this statement
B.from EMPLOYEE
C.group by empid
D.select dept,avg(salary)

I chose D, but the answer is C.

I know that select and group by don't match, but I have to choose one.

Moreover, why do the choices of this kind of fine-SQL-error question come in random sequence? It can lead to confusion without making any good. I know there are many OCP out there, can you comment on this? Thanks in advance.

Dino Received on Sat Jul 21 2001 - 16:23:30 CDT