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, spool space is not pre-allocated but is defined as an upper limit. Creating a child database with a portion of spool space does not reduce the spool space limit of the parent database; hence, Database A retains its 5GB limit.

Keep practicing — related questions