IndiaBIX

Computer Science - Database Systems - Discussion

Discussion Forum : Database Systems - Section 1 (Q.No. 40)
Database Systems
40.
In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
ALTER TRIGGERS
ALTER TABLE
MODIFY TRIGGERS IN TABLE
All of the above
None of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
4 comments Page 1 of 1.
Sanjith said:   6 years ago
Alter trigger is the correct answer.
Samee marwat said:   10 years ago
Dear student for enable/disable database triggers we use alter triggers and when we enable/disable all triggers on a table than we use the alter table command is used.
Vaibhav said:   1 decade ago
ALTER TABLE 'mytable'
ENABLE ALL TRIGGERS

Since it's for "all" triggers ALTER TABLE will be used.

I think ALTER TRIGGER is used while modifying a single trigger.
Shirisha said:   1 decade ago
The triggers are on a table , hence the ALTER TRIGGER seems the right answer. Please clarify
Post your comments here:

Your comments will be displayed after verification.

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