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.)
The DELETE statements that execute successfully are: 'DELETE orders WHERE order_total < 1000', 'DELETE FROM orders', and 'DELETE FROM orders WHERE order_total < 1000'. These statements are syntactically correct and will successfully delete rows from the 'orders' table. The first statement uses the correct syntax by specifying the table and condition, the second statement deletes all rows from the table, and the third statement also correctly specifies the table and condition. The other options contain syntax errors such as incorrect usage of 'DELETE' or additional incorrect clauses.
BDE is the correct answer
BDE correct
BDE is correct
BDE is correct
why is option D right? It delete every rows from the table. It does not consider the condition "order_total < 1000."
The question asks which ones: "execute successfully" it executes and successfully, there is nothing saying the condition except in other alternativas.
DELETE FROM TABLE_NAME. 'FROM' IS A OPTION WORD.
a column can be dropped or it can be updated not deleted
BDE is correct