Vidyalelo
MySQL · Q876

MySQL

Programming · MySQL · question 876

Q876

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

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

Answer: Option A

Solution

Answer: Option A
Solution:
The "CREATE TABLE ..." command is used to create a permanent table in MySQL.

Here's a breakdown of the options:
* Option A: Permanent Tables - This is the correct answer. Permanent tables are stored on disk and persist even after the database session ends.
* Option B: Virtual tables - Virtual tables are not directly created with the "CREATE TABLE ..." command. They are special tables that represent data from other sources, like views.
* Option C: Temporary tables - Temporary tables are created using the "CREATE TEMPORARY TABLE ..." command and exist only for the duration of the current session.
* Option D: All of the mentioned - This is incorrect because temporary tables are created with a different command.

Therefore, the answer is Option A: Permanent Tables.