CompTIA Data+ (DA0-001) — Question 323

Which of the following is a key feature of a temporary table?

Answer options

• A. Temporary tables are dropped automatically when the query session is closed.
• B. Temporary tables are automatically normalized.
• C. Temporary tables possess greater storage capacity than permanent tables.
• D. Temporary tables are indexed automatically.

Correct answer: A

Explanation

The correct answer is A because temporary tables are designed to be session-specific and are automatically dropped once the session that created them is closed. Options B, C, and D are incorrect as temporary tables do not have inherent normalization, do not offer greater storage capacity than permanent tables, and indexing is not automatically applied to temporary tables.