Exam 1z0-071 topic 1 question 207 discussion

Actual exam question from Oracle's 1z0-071

Question #: 207
Topic #: 1

The ORDERS table has a primary key constraint on the ORDER_ID column.

The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.

The constraint is defined with ON DELETE CASCADE.

There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000.

Which three DELETE statements execute successfully? (Choose three.)

A. DELETE order_id FROM orders WHERE order_total < 1000;
B. DELETE orders WHERE order_total < 1000
C. DELETE * FROM orders WHERE order_total < 1000;
D. DELETE FROM orders;
E. DELETE FROM orders WHERE order_total < 1000;

Show Suggested Answer

Suggested Answer: BDE 🗳️

by jfc1 at Feb. 16, 2023, 3:04 p.m.

Comments

Submit Cancel

HUGO2024

8 months, 3 weeks ago

Selected Answer: BDE

BDE is correct

upvoted 1 times

...

yaya32

1 year, 4 months ago

Selected Answer: BDE

BDE correct

upvoted 1 times

...

Mcromeo

1 year, 5 months ago

Selected Answer: BDE

BDE is correct

upvoted 1 times

...

lucemqy

1 year, 6 months ago

Selected Answer: BDE

BDE is correct

upvoted 1 times

...

x33

1 year, 7 months ago

why is option D right? It delete every rows from the table. It does not consider the condition "order_total < 1000."

upvoted 1 times

mrcsp

1 year, 3 months ago

The question asks which ones: "execute successfully" it executes and successfully, there is nothing saying the condition except in other alternativas.

upvoted 2 times

...