Vidyalelo
MySQL · Q289

MySQL

Programming · MySQL · question 289

Q289

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

A.
Permanent Tables
B.
Virtual tables
Answer
C.
Temporary tables
D.
All of the mentioned

Answer: Option B

Solution

Answer: Option B
Solution:
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.