nerdexam
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

1Z0-074 question #74 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)
  • A
    9% (3)
  • B
    3% (1)
  • D
    86% (30)
  • E
    3% (1)

Explanation

Explanation/Reference:

Topics

#SQL expressions#arithmetic operators#date arithmetic#valid syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice