In SQL, which of the following is correct command for schema evolution, if the…

2024

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?

Answer: D. DROP — With the RESTRICT option, the SQL DROP command drops a schema only when it has no dependent elements. Therefore the command is DROP.

  1. A.

    DELETE

  2. B.

    UPDATE

  3. C.

    ALTER

  4. D.

    DROP

Attempted by 575 students.

Show answer & explanation

Correct answer: D

With the RESTRICT option, the SQL DROP command drops a schema only when it has no dependent elements. Therefore the command is DROP.

Explore the full course: Rssb Senior Computer Instructor

Loading lesson…