QuestionQ84

VerifiedDatabase Fundamentals

A business needs to be notified when new clients are added to the client list stored in the client table. Which of the following SQL statements should the database administrator use to complete this task?

Explanation

A DML trigger runs automatically when an INSERT, UPDATE, or DELETE event occurs on a table or view. An INSERT trigger on the client table can execute the notification logic whenever a new client record is added.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!