🎴 Flashcard Mode

Database Fundamentals and SQL Programming

Card1 / 20
Mastered0
Review0
QuestionClick to flip

When Database A has 5GB of spool space, Database B is created as child of Database A with 3GB of spool space, then Database A will have

AnswerClick to flip back
A
5GB of spool space
💡 Explanation:

In Teradata's hierarchical space management, when a child database is created with a spool allocation, it does not reduce the parent's spool space. The parent (Database A) retains its full 5GB spool allocation. The child's 3GB is a separate allocation, not a subtraction from the parent.

Change Mode