Computer Science - Database Systems - Discussion

40. 

In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

[A]. ALTER TRIGGERS
[B]. ALTER TABLE
[C]. MODIFY TRIGGERS IN TABLE
[D]. All of the above
[E]. None of the above

Answer: Option B

Explanation:

No answer description available for this question.

Shirisha said: (Feb 20, 2012)  
The triggers are on a table , hence the ALTER TRIGGER seems the right answer. Please clarify

Vaibhav said: (Nov 10, 2013)  
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.

Samee Marwat said: (Sep 12, 2015)  
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.

Sanjith said: (Jan 12, 2020)  
Alter trigger is the correct answer.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.