nerdexam
Oracle

1Z0-047 · Question #57

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table. Which…

The correct answer is A. DELETE C. DELETE FROM order_items i. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables. You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table. Which DELETE statements are valid? (Choose all that apply.)

Exhibit

1Z0-047 question #57 exhibit

Options

  • ADELETE
  • BDELETE *
  • CDELETE FROM order_items i
  • DDELETE

How the community answered

(26 responses)
  • A
    77% (20)
  • B
    15% (4)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice