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 581 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: Uppsc Polytechnic Lecturer 2025 Cs

Loading lesson…