Q876
"CREATE TABLE ..." command is used to create which type of table in Mysql?
A.
Permanent Tables
AnswerB.
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.