Oracle
1Z0-047 · Question #150
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID…
The correct answer is C. SELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi JOIN inventories i D. SELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi JOIN inventories i. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five. Which two SQL statements can accomplish the task? (Choose two.)
Exhibit
Options
- ASELECT product_id, quantity_on_hand , supplier_id
- BSELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi JOIN inventories i
- CSELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi JOIN inventories i
- DSELECT i.product_id, i.quantity_on_hand , pi.supplier_id FROM product_information pi JOIN inventories i
How the community answered
(37 responses)- A8% (3)
- B19% (7)
- C73% (27)
Community Discussion
No community discussion yet for this question.