nerdexam
Oracle

1Z0-071 · Question #210

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 B. DELETE D. DELETE. 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 two DELETE statements are valid (Choose two.)

Exhibit

1Z0-071 question #210 exhibit

Options

  • ADELETE
  • BDELETE
  • CDELETE FROM order_items i
  • DDELETE

How the community answered

(25 responses)
  • A
    20% (5)
  • B
    72% (18)
  • C
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice