View the Exhibit and examine the description of the ORDER_ITEMS and
PRODUCT_INFORMATION tables. The ORDER_ITEM table has records pertaining to
details for each product in an order. The PRODUCT_INFORMATION table has records for
all the products available for ordering. Evaluate the following SOL statement: SELECT
oi.order_id, pi.product_id FROM orderjtems oi RIGHT OUTER JOIN product_information pi
ON (oi. product_id=pi. Product_id); Which statement is true regarding the output of this SOL
statement?
A.
The query would return the ORDER_ID and PRODUCT_ID for those products that are
ordered as well as for the products that have never been ordered, and for the products that
are not listed in the PRODUCT INFORMATION table.
B.
The query would return the ORDER_ID and PRODUCT_ID for the products that are
ordered but not listed in the PRODUCT_INFORMATION table.
C.
The query would return the ORDER_ID and PRODUCT_ID for the products that are
ordered as well as for the products that have never been ordered.
D.
The query would return the ORDER_ID and PRODUCT_ID for only those products that
are ordered.
Answer: C