tags:

views:

23

answers:

1

When a table is dropped using a simple DROP statement, SQL performs some more operations simultaneously, select all the valid operations?

a.  Removes all rows from the table
b.  Drops all the table's indexes
c.  Removes all dependent views
d.  Removes all dependent procedures
+2  A: 

DROP will do (a) and (b), but not (c) and (d) which can lead to trouble later if care isn't taken.

Brian Hooper