IndiaBIX

Computer Science - Database Systems - Discussion

Discussion Forum : Database Systems - Section 2 (Q.No. 4)
Database Systems
4.
In SQL, which command(s) is(are) used to enable/disable a database trigger?
ALTER TRIGGER
ALTER DATABASE
ALTER TABLE
MODIFY TRIGGER
All of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
1 comments Page 1 of 1.
Devindu said:   9 years ago
To enable or disable triggers using the ALTER TABLE statement, you must own the table, have the ALTER object privilege for the table, or have the ALTER ANY TABLE system privilege. To enable or disable an individual trigger using the ALTER TRIGGER statement, you must own the trigger or have the ALTER ANY TRIGGER system privilege.
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers