Go back to
1Z0-031 - Oracle9i Database: Fundamentals I
What are the two effects of the following command to drop a table? (Choose two.) SQL> DROP TABLE oe.ordershistory CASCADE CONSTRAINTS;
The extents are released and can be used by other segments in the tablespace.
The contents are moved to the undo segments, thus enabling the user to recover the table.
The dependent tables are truncated.
The referential integrity constraints that refer to primary and unique keys in the ORDERSHISTORY table are dropped.
The dependent tables are dropped along with the ORDERSHISTORY table.
Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ?