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 499 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: Up Police Computer Operator

Loading lesson…