_____ is dropped when the table or tablespace is dropped
-
SYNONYM
-
ALIAS
-
All of the above
-
None of the above
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.