DS0-001 · Question #142
DS0-001 Question #142: Real Exam Question with Answer & Explanation
The correct answer is D: CREATE TRIGGER. CREATE TRIGGER (D) is correct because a trigger is a database object that automatically fires in response to a specific event on a table - such as an INSERT - making it the ideal tool to notify the business whenever a new client row is added to the client table. CREATE PROCEDURE
Question
A business wants to be notified when new clients are added to the client list that is stored in the client table. Which of the following SQL statements should the database administrator use to perform this task?
Options
- ACREATE PROCEDURE
- BCREATE INDEX
- CCREATE VIEW
- DCREATE TRIGGER
Explanation
CREATE TRIGGER (D) is correct because a trigger is a database object that automatically fires in response to a specific event on a table - such as an INSERT - making it the ideal tool to notify the business whenever a new client row is added to the client table.
- CREATE PROCEDURE (A) defines a stored routine that must be explicitly called by a user or application; it cannot fire automatically on its own when data changes.
- CREATE INDEX (B) improves query performance by creating a lookup structure on a column - it has no event-driven or notification capability.
- CREATE VIEW (C) creates a virtual table based on a
SELECTquery, useful for simplifying data access but completely passive - it never reacts to data changes.
Memory tip: Think of a trigger like a security alarm - it watches for a specific event (someone entering/inserting) and automatically sets off a response, without anyone having to manually "check" the door.
Community Discussion
No community discussion yet for this question.