DA0-001 · Question #423
DA0-001 Question #423: Real Exam Question with Answer & Explanation
The correct answer is A: Temporary tables are dropped automatically when the query session is closed.. A temporary table is designed to store intermediate results or data for the duration of a database session or a specific query. It is automatically dropped when the session is closed, ensuring that the table does not persist beyond its intended use. This is a key feature that dis
Question
Which of the following is a key feature of a temporary table?
Options
- ATemporary tables are dropped automatically when the query session is closed.
- BTemporary tables are automatically normalized.
- CTemporary tables possess greater storage capacity than permanent tables.
- DTemporary tables are indexed automatically.
Explanation
A temporary table is designed to store intermediate results or data for the duration of a database session or a specific query. It is automatically dropped when the session is closed, ensuring that the table does not persist beyond its intended use. This is a key feature that distinguishes temporary tables from permanent tables.
Topics
Community Discussion
No community discussion yet for this question.