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.