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. Trigger
B. Stored Procedure
C. Cursor
D. View
Answer: Option A
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.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What is the purpose of the SQL GROUP BY ... HAVING combination?
A. To filter groups based on aggregate values
B. To select individual rows
C. To sort groups
D. To join groups

Correct Answer: Option A


Explanation:
HAVING is used in conjunction with GROUP BY to filter groups based on conditions applied to aggregate functions.

This question belongs to: Computer Database Management System (DBMS)
Question #2
In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?
A. Relation Schema
B. Relation Card
C. Relation Instance
D. Relation Domain

Correct Answer: Option A


Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a valid SQL string function?
A. REPLACE
B. All of the above
C. CONCAT
D. SUBSTRING

Correct Answer: Option B


Explanation:
SUBSTRING, CONCAT, and REPLACE are common string functions in SQL.

This question belongs to: Computer Database Management System (DBMS)