A database object that automatically executes or fires in response to specific events (like INSERT, UPDATE, or DELETE) on a table is known as a what? MCQ with Answer and Explanation
A database object that automatically executes or fires in response to specific events (like INSERT, UPDATE, or DELETE) on a table is known as a what?
A. Stored Procedure
B. Cursor
C. Trigger
D. View
Answer: Option C
Solution (By JKSSB Mock Tests)
A Trigger is a named database object containing procedural code that automatically runs or fires when a specific DML statement occurs on a designated table.
Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.
No comments yet. Be the first to start the discussion!