nerdexam
Oracle

1Z0-047 · Question #7

View the Exhibit and examine the description of the PRODUCT_INFORMATION table. You want to display the expiration date of the warranty for a product. Which SQL statement would you execute?

The correct answer is A. SELECT product_id, SYSDATE + warranty_period. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the description of the PRODUCT_INFORMATION table. You want to display the expiration date of the warranty for a product. Which SQL statement would you execute?

Exhibit

1Z0-047 question #7 exhibit

Options

  • ASELECT product_id, SYSDATE + warranty_period
  • BSELECT product_id, TO_YMINTERVAL(warranty_period)
  • CSELECT product_id, TO_YMINTERVAL(SYSDATE) + warranty_period FROM product_information;
  • DSELECT product_id, TO_YMINTERVAL(SYSDATE + warranty_period) FROM product_information;

How the community answered

(31 responses)
  • A
    74% (23)
  • B
    13% (4)
  • C
    3% (1)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice