Multiple choice technology databases

_____ is dropped when the table or tablespace is dropped

  1. SYNONYM

  2. ALIAS

  3. All of the above

  4. None of the above

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In DB2, an alias is defined on a table. If the underlying table or its tablespace is dropped, the alias is not automatically dropped; it remains but becomes invalid. Conversely, a synonym is automatically dropped when its underlying table is dropped.