Oracle
1Z0-074 · Question #74
Examine the description of the PRODUCTS table: Which three queries use valid expressions? (Choose three.)
The correct answer is D. SELECT product_id, unit_price, unit_price + surcharge FROM products; F. SELECT product_id, expiry_date * 2 FROM products. Explanation/Reference:
New Features for Manageability
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;
- 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
(35 responses)- A9% (3)
- B3% (1)
- D86% (30)
- E3% (1)
Explanation
Explanation/Reference:
Topics
#SQL expressions#arithmetic operators#date arithmetic#valid syntax
Community Discussion
No community discussion yet for this question.
