多項(xiàng)選擇題

Which two statements are true regarding the ORDER BY clause? （）

A.It is executed first in the query execution
B.It must be the last clause in the SELECT statement
C.It cannot be used in a SELECT statement containing a HAVING clause
D.You cannot specify a column name followed by an expression in this clause
E.You can specify a combination of numeric positions and column names in this clause

你可能感興趣的試題

多項(xiàng)選擇題

To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?（）

A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME

多項(xiàng)選擇題

Which two statements are true regarding views?（）

A.A subquery that defines a view cannot include the GROUP BY clause
B.A view that is created with the subquery having the DISTINCT keyword can be updated
C.A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated
D.A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table