Examveda

Which command is used to create "Temporary tables" in MySQL?

A. CREATE TABLE;

B. CREATE VIEW

C. Both CREATE TABLE; and CREATE VIEW

D. None of the mentioned

Answer: Option D

Solution (By Examveda Team)

This question asks about creating temporary tables in MySQL.
Temporary tables are like regular tables, but they only exist for the duration of your current MySQL session.
Let's look at the options:
Option A: CREATE TABLE; This command is used to create regular tables, not temporary ones.
Option B: CREATE VIEW; This command is used to create views, which are virtual tables based on the results of a query. They are not temporary tables.
Option C: Both CREATE TABLE; and CREATE VIEW; This is incorrect because neither of these commands creates temporary tables.
Option D: None of the mentioned; This is the correct answer. There is a separate command used for creating temporary tables.
The command to create temporary tables in MySQL is CREATE TEMPORARY TABLE.
So the correct answer is Option D: None of the mentioned.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous