Oracle Exam 1Z0-071 Topic 16 Question 3 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 3
Topic #: 16

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.

ORDER_ID is the primary key in the ORDERS table and the foreign key of the ORDER_ITEMS table, whose constraint is defined with the ON DELETE CASCADE option.

Which DELETE statement would execute successfully?

ADELETE orders o, order_items iWHERE o.order_id = i.order_id;

BDELETEFROM ordersWHERE (SELECT order_idFROM order_items);

CDELETE ordersWHERE order_total < 1000;

DDELETE order_idFROM ordersWHERE order_total < 1000;

Show Suggested Answer

Suggested Answer: C

by Timothy at May 06, 2022, 03:28 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!