Question

What can be used to check for views that have been invalidated by DROP or ALTER operations?

(a) CREATE TABLE

(b) VERIFY TABLE

(c) DETAILS TABLE

(d) CHECK TABLE

The question was posed to me in quiz.

I want to ask this question from Using Views topic in division Using SQL to Manage Data of MySQL

Answer 1

The correct answer is (d) CHECK TABLE

For explanation: A ‘View’ is created in MySQL by writing the clause ‘CREATE VIEW’ followed by the view name. Once a view is dropped or altered after being created, it can be checked by the ‘CHECK TABLE’ clause.