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 a private alternative name for a table or view that is automatically dropped when its underlying table or tablespace is dropped. An ALIAS is a public object that remains even if the target is dropped.