InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
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 |
|
Answer» 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. |
|