"CREATE VIEW ..." command is used to create which type of table in Mysql?

Solution (By Examveda Team)

The "CREATE VIEW ..." command in MySQL is used to create a special kind of table called a virtual table.

Here's a simple way to understand:

Imagine a view as a window that shows you a specific part of a real table. It doesn't store any data itself; it just points to the original table. When you query a view, MySQL actually runs the query on the underlying table.

So the answer is Option B: Virtual tables.

Let's break down the other options:

* Option A: Permanent Tables: These are regular tables that store data permanently in the database.
* Option C: Temporary Tables: These tables exist only for the duration of a connection or session. They are used for temporary calculations or data storage.
* Option D: All of the mentioned: This is incorrect because views are not permanent, temporary, or regular tables.