单项选择题
A. It would be created only if a unique index is manually created first.
B. It would be created and would use an automatically created unique index.
C. It would be created and would use an automatically created nonunique index.
D. It would be created and remains in a disabled state because no index is specified in the command.
多项选择题 Whichtwostatementsaretrueregardingtheexecutionofthecorrelatedsubqueries？（）
单项选择题 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？（）