---

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？（）
A: The statement would not execute because table aliases are not allowed in the JOIN clause.
B: The statement would not execute because the table alias prefix is not used in the USING clause.
C: The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
D: The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.

---

出自：Oracle认证

显示答案