ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.