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. View
B. Stored Procedure
C. Trigger
D. Cursor
Answer: Option C
Solution (By JKExamLibrary)
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:
A Database Management System (DBMS) acts as an interface between application software and the underlying physical database, managing data storage, retrieval, and updates.
Explanation:
The UNIQUE constraint prevents duplicate entries in a column. Unlike a Primary Key, a UNIQUE constraint typically allows one or more rows to store NULL values depending on the database engine.
No comments yet. Be the first to start the discussion!