?
What is the meaning of "Temporary Tables" in Mysql?
Answer & Solution
Correct Answer:
Option
A
Temporary tables are like temporary storage spaces in MySQL.
Imagine you're working on a complex calculation and need to store some intermediate results.
Instead of creating a permanent table, you can use a temporary table to hold these results temporarily.
Let's break down the options:
Option A: Rows returned by subquery - Subqueries return rows, but they don't create temporary tables.
Option B: Permanent tables - These tables are permanent and stored in the database. They're not temporary.
Option C: Virtual tables - These tables don't actually store data, but rather provide a view of data from other tables. They're not temporary.
Option D: All of the mentioned - This is incorrect. Only temporary tables are temporary storage spaces.
Therefore, the correct answer is None of the mentioned.
Temporary tables are a unique type of table in MySQL. They are used for temporary storage and are deleted automatically when the session ends.
Imagine you're working on a complex calculation and need to store some intermediate results.
Instead of creating a permanent table, you can use a temporary table to hold these results temporarily.
Let's break down the options:
Option A: Rows returned by subquery - Subqueries return rows, but they don't create temporary tables.
Option B: Permanent tables - These tables are permanent and stored in the database. They're not temporary.
Option C: Virtual tables - These tables don't actually store data, but rather provide a view of data from other tables. They're not temporary.
Option D: All of the mentioned - This is incorrect. Only temporary tables are temporary storage spaces.
Therefore, the correct answer is None of the mentioned.
Temporary tables are a unique type of table in MySQL. They are used for temporary storage and are deleted automatically when the session ends.
Join the Discussion
Login to post a comment or share your explanation.
Login