移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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?()

发布日期:2022-07-18

View the Exhibit and examine the structure of the ...
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.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!