多项选择题
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
相关考题
-
多项选择题
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 -
多项选择题
Whichtwostatementsaretrueregardingviews?（）
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 -
单项选择题
What is the default value for the ENABLED attribute of a job or program when it is created? （）
A. TRUE
B. FALSE
C. There is no default. It must be defined at creation time.
D.PENDING
E. NULL
