?
"CREATE TABLE ..." command is used to create which type of table in Mysql?
Answer & Solution
Correct Answer:
Option
A
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.
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.
Join the Discussion
Login to post a comment or share your explanation.
Login