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 only those products
that are ordered.
B.
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.
C.
The query would return the ORDER_ID and PRODUCT_ID for the products that are
ordered but not listed in the PRODUCT_INFORMATION table.
D.
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