Oracle
1Z0-071 · Question #352
Examine the description of the PRODUCTS table: Which three queries use valid expressions? (Choose three.)
The correct answer is A. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products; D. SELECT product_id, unit_price, unit_price + surcharge FROM products; E. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products. See the full explanation below for the reasoning.
Question
Examine the description of the PRODUCTS table:
Which three queries use valid expressions? (Choose three.)
Exhibit
Options
- ASELECT product_id, (expiry_date - delivery_date) * 2 FROM products;
- BSELECT product_id, unit_price | | 5 "Discount", unit_price + surcharge - discount FROM products;
- CSELECT product_id, unit_price, 5 "Discount", unit_price + surcharge - discount FROM products;
- DSELECT product_id, unit_price, unit_price + surcharge FROM products;
- ESELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;
- FSELECT product_id, expiry_date * 2 FROM products;
How the community answered
(34 responses)- A76% (26)
- B15% (5)
- C3% (1)
- F6% (2)
Community Discussion
No community discussion yet for this question.
