nerdexam
Oracle

1Z0-047 · Question #112

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables. ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is…

The correct answer is B. DELETE orders. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables. ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option. Which DELETE statement would execute successfully?

Options

  • ADELETE order_id
  • BDELETE orders
  • CDELETE
  • DDELETE orders o, order_items i

How the community answered

(60 responses)
  • A
    2% (1)
  • B
    83% (50)
  • C
    5% (3)
  • D
    10% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice