Question discussion

In SQL, which of the following is correct command for schema evolution, if the RESTRICT option is chosen than the schema is dropped only if…

3551Medium DSSSB TGT Computer Science 0 replies 1 views
0

In SQL, which of the following is correct command for schema evolution, if the RESTRICT option is chosen than the schema is dropped only if schema has no element in it?

  • ADELETE
  • BUPDATE
  • CALTER
  • DDROP
Correct answer: D

Explanation

DROP SCHEMA with RESTRICT drops the schema only if it contains no elements.

Discussion 0

Nobody has replied yet. Start the discussion!