You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE

Post by answerhappygod »

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;Which two statements are true about the effect of the command? (Choose two.)

A. No flashback is possible to bring back the ITEM table
B. The ORDERS table is dropped along with the ITEM table
C. The dependent referential integrity constraints in the ORDERS table are disabled
D. The dependent referential integrity constraints in the ORDERS table are removed E. The table definition of the ITEM table and associated indexes are placed in the recycle bin
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply