The DROP TABLE statement:
A. deletes the table structure only.
B. deletes the table structure along with the table data.
C. works whether or not referential integrity constraints would be violated.
D. is not an SQL statement.
Answer: Option B
A. to simplify a result only.
B. to prevent the display of sensitive data only.
C. to accomplish both of the above.
D. None of the above are reasons for using an SQL view.
A. To save users from having to write an expression.
B. To ensure that the results are consistent.
C. To accomplish both of the above.
D. None of the above is correct - computations cannot be placed in a view.