View the Exhibit and examine the structure of the PRODUCTINFORMATION and
INVENTORIES tables. You want to display the quantity on hand for all the products
available in the PRODUCTINFORMATION table that have the PRODUCT_STATUS as
‘orderable’ QUANTITY_ON_HAND is a column in the INVENTORIES table. The following
SQL statement was written to accomplish the task: SELECT pi. Product_id,
pi.product_status, sum(i.quantity_on_hand) FROM product_information pi LEFT OUTER
JOIN inventories i ON (pi. Product_id = i. product_id) WHERE (pi.product_status =
‘orderable”) GROUP BY pi.product_id, pi.product_status; Which statement is true regarding
the execution of this SQL statement?
A.
The statement would execute and produce the desired output.
B.
The statement would not execute because the WHERE clause is used before the
GROUP BY clause.
C.
The statement would not execute because prefixing table alias to column names is not
allowed with the ON clause.
D.
The statement would not execute because the WHERE clause is not allowed with LEFT
OUTER JOIN.
Explanation:
Tested in Oracle SQL Developer:
correct answer is “The statement would execute and produce the desired output”.
correct answer : A) The statement would not execute because prefixing table alias to column names is not
allowed with the ON clause.
A.
The statement would execute and produce the desired output.
The answer should be A
Yes, the answer should be A
Excellent article. I’m facing many of these issues as well..|