Multiple choice technology databases

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

  1. 2GB of spool space

  2. 5GB of spool space

  3. 2GB of permanent space

  4. 3GB of spool space
Reveal answer Fill a bubble to check yourself
B Correct answer
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.

Keep practicing — related questions