Which of the following command is correct to disable a trigger named “ emp_dept”?

Options
- ALTER TRIGGER emp_dept DISABLE;
- UPDATE TRIGGER emp_dept DISABLE;
- MODIFY TRIGGER emp_dept DISABLE;
- None of the above

CORRECT ANSWER : ALTER TRIGGER emp_dept DISABLE;

Discussion Board
ALTER TRIGGER emp_dept DISABLE;

Once you have created a Trigger in Oracle, you might find that you are required to disable the trigger. You can do this with the ALTER TRIGGER statement.

Syntax : ALTER TRIGGER trigger_name DISABLE;
where,
trigger_name: The name of the trigger that you wish to disable.

Prajakta Pandit 02-22-2017 05:38 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲