The command to disable all the triggers on the EMP table

technology databases

  1. ALTER TRIGGERS ON TABLE EMP DISABLE

  2. ALTER EMP DISABLE ALL TRIGGERS

  3. NOT POSSIBLE TO DISABLE TRIGGERS

  4. ALTER TABLE EMP DISABLE ALL TRIGGERS

Show answer
Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) ALTER TRIGGERS ON TABLE EMP DISABLE - This option is incorrect because the correct syntax to disable triggers is "ALTER TABLE DISABLE TRIGGERS". The keyword "ON" is not used in this context.

Option B) ALTER EMP DISABLE ALL TRIGGERS - This option is incorrect because the correct syntax to disable triggers is "ALTER TABLE DISABLE TRIGGERS". The keyword "EMP" is not used in this context.

Option C) NOT POSSIBLE TO DISABLE TRIGGERS - This option is incorrect. It is possible to disable triggers using the correct syntax.

Option D) ALTER TABLE EMP DISABLE ALL TRIGGERS - This option is correct because it uses the correct syntax to disable all triggers on the "EMP" table. The "ALTER TABLE" command is used to modify a table, and the "DISABLE ALL TRIGGERS" clause is used to disable all triggers on that table.

The correct answer is D. This option is correct because it uses the correct syntax to disable all triggers on the "EMP" table.

Find more quizzes: