Multiple choice technology databases

Creation of which DB objects will cause a DDL trigger to fire?

  1. Index

  2. Cluster

  3. Package

  4. DB links

  5. Function
Reveal answer Fill a bubble to check yourself
A,C,E Correct answer
Explanation

DDL triggers fire when Data Definition Language commands execute, creating or altering database schema objects. Indexes, packages, and functions are DDL objects that trigger these events when created. Clusters and database links (DB links) may be database objects but typically don't fire DDL triggers in standard implementations. This is a multi-select question requiring knowledge of which database objects trigger DDL events.

Keep practicing — related questions