A.The first column in the last SELECT of the compound query

B.The first column in the first SELECT of the compound query

C.The first VARCHAR2 column in the first SELECT of the compound query

D.The first NUMBER column in the first SELECT of the compound query

E.The first NUMBER or VARCHAR2 column in the last SELECTof the compound query

A.They return a single result row per table.

B.They can be nested to any level.

C.They can accept only one argument.

D.They can be used only in the where clause of a select statement.

E.The date type returned can be different from the data type of the argument.

F.The argument can be a column name, variable, literal or an expression.

A.The on clause can be used.

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

C.The on clause must be used.

D.It must be an equijoin.

E.It can be an outer join.

F.It must be an inner join.

A.SELECT TO _ DATE (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

B.SELECT TO_ CHAR (SYSDATE, ' FMDD, DAY MONTH, YYYY') FROM DUAL;

C.SELECT TO_ CHAR (SYSDATE, ' FMDAY, DDTH MONTH, YYYY') FROM DUAL;

D.SELECT TO _ CHAR (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

A.It can display multiple rows but only a single column.

B.It consists of a single row and single column of VARCHAR2 data type.

C.It can be accessed by any user who has the SELECT privilege in any schema

D.It can display multiple rows and columns.

E.It can be accessed only by the SYS user.

F.It can be used to display only constants or pseudo columns.