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, a SYNONYM is automatically dropped when its underlying table or tablespace is dropped. An ALIAS, however, is preserved even if the referenced table is dropped.