Examveda

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

A. Permanent Tables

B. Virtual tables

C. Temporary tables

D. All of the mentioned

Answer: Option A

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous