nerdexam
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

1Z0-071 question #352 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)
  • A
    76% (26)
  • B
    15% (5)
  • C
    3% (1)
  • F
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice