Q263
What is the meaning of "Temporary Tables" in Mysql?
A.
Rows returned by sub query
AnswerB.
Permanent tables
C.
Virtual tables
D.
All of the mentioned
Answer: Option A
Solution
Answer: Option A
Solution:
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.