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 CREATE, ALTER, or DROP commands execute. Index, Package, and Function creation all trigger DDL events. Clusters (B) are schema objects but don't typically fire DDL triggers in most database systems. Database links (D) are created with CREATE DATABASE LINK but are not always caught by DDL triggers depending on the DB system.

Keep practicing — related questions