A.They can be used on columns or expressions.

B.They can be passed as an argument to another group function.

C.They can be used with a SQL statement that has a GROUP BY clause.

D.They can be used only on one column in the SELECT clause.

E.They can be used together with the single-row functions in the SELECT clause.

A.A SELECT statement cannot contain a WHERE clause when querying a view containing a WHERE clause in its defining query.

B.Views have no segment.

C.A view can be created that refers to a non-existent table in its defining query.

D.Rows inserted into a table using a view are retained in the table if the view is dropped.

E.Views have no object number.

F.Views can join tables only if they belong to the same schema.

A.SYSDATEcan be used in expressions only if the default date format is DD-MON-RR.

B.SYSDATEcan be queried only from the DUALtable.

C.SYSDATEand CURRENT_DATEreturn the current date and time set for the operating system of the database server.

D.CURRENT_TIMESTAMPreturns the same date and time as SYSDATEwith additional details of fractional seconds.

E.CURRENT_TIMESTAMPreturns the same date as CURRENT_DATE.

F.CURRENT_DATEreturns the current date and time as per the session time zone.

A.A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.

B.A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.

C.A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.

D.A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.

E.A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######.

A.UPDATE ordersSET order_date = '12-mar-2007',AND order_total = TO_NUMBER(NULL)WHERE order_id = 2455;

B.UPDATE ordersSET order_date = TO_DATE('12-mar-2007','dd-mon-yyyy'),SET order_total = TO_NUMBER (NULL)WHERE order_id = 2455;

C.UPDATE ordersSET order_date = '12-mar-2007',order_total IS NULLWHERE order_id = 2455;

D.UPDATE ordersSET order_date = '12-mar-2007',order_total = NULLWHERE order_id = 2455;