A.It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

B.It returns an error because all the aggregate functions used in the HAVING clause must be specified in the SELECT list.

C.It returns an error because the HAVING clause should be specified after the GROUP BY clause.

D.It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

A.SELECT TO_DATE(TO_CHAR('11-oct-2007'), 'fmDdspth "of" Month, Year'))FROM DUAL;

B.SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year')FROM DUAL;

C.SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year')FROM DUAL;

D.SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year')FROM DUAL;

A.A table name can be specified just once when selecting data from a table having a selfreferencing relationship

B.A Relationship can be mandatory for both entities

C.A one-to-many relatonship in one direction is a one-to-one relationship in the other direction

D.A one-to-one relationship is always a self-referencing relationship

E.A many-to-many relationship can be implemented only by using foreign keys

A.It can be an outer join.

B.The on clause can be used.

C.It must be an equijoin.

D.It must be an inner join.

E.The on clause must be used.

F.The query must use two different aliases for the table.

A.+25-00, +54-02, +00 11:12:10.123457

B.+00-300, +54-02, +00 11:12:10.123457

C.+25-00, +00-650, +00 11:12:10.123457

D.+00-300, +00-650, +00 11:12:10.123457