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

Solution (By Examveda Team)

This question asks about how to find views in MySQL that have become unusable because of changes to the tables they are based on.

Imagine you have a view called "CustomerOrders" that shows information from the "Customers" and "Orders" tables. If you make changes to either of those tables, the "CustomerOrders" view might stop working correctly.

Here's how to understand the answer choices:
* Option A: CREATE TABLE - This is used to create a new table, not to check the validity of views.
* Option B: VERIFY TABLE - This is used to check the consistency of a table's data, but it doesn't specifically tell you about invalidated views.
* Option C: DETAILS TABLE - This is not a valid command in MySQL.
* Option D: CHECK TABLE - This is the correct answer! CHECK TABLE is used to check the consistency of a table or view. It will tell you if a view is invalidated because of changes to the underlying tables.

So, the best way to check for invalidated views is to use CHECK TABLE.