DA0-001 · Question #423
Which of the following is a key feature of a temporary table?
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…
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.
How the community answered
(17 responses)- A88% (15)
- B6% (1)
- D6% (1)
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.