ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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

Answer & Solution
Correct Answer: Option B
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.