“CREATE VIEW …” command is used to create which type of table in Mysql?
A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. All of the mentioned
I have been asked this question in an international level competition.
My question comes from The from Clauses topic in division Select Statement of MySQL
The correct answer is B. Virtual tables
Explanation: CREATE VIEW is used to create virtual tables.