多项选择题
A. The nested query executes after the outer query returns the row.
B. The nested query executes first and then the outer query executes.
C. The outer query executes only once for the result returned by the inner query.
D. Each row returned by the outer query is evaluated for the results returned by the inner query.
单项选择题 View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement： SELECT oi.order_id， product_jd， order_date FROM order_items oi JOIN orders o USING （order_id）； Which statement is true regarding the execution of this SQL statement？（）
多项选择题 Whichthreestatementsaretrueregardingsingle-rowfunctions？（）
多项选择题 WhichthreetaskscanbeperformedusingregularexpressionsupportinOracleDatabase10g？（）