Home »
MCQs »
Oracle MCQs
Oracle Trigger MCQs
Oracle Trigger MCQs: This section contains multiple-choice questions and answers on trigger in Oracle.
Submitted by Anushree Goswami, on June 16, 2022
1. ____ statements against an Oracle table can execute procedures implicitly.
- INSERT
- UPDATE
- DELETE
- All of the above
Answer: D) All of the above
Explanation:
INSERT, UPDATE, and DELETE statements against an Oracle table can execute procedures implicitly.
2. Database triggers are the _____.
- Functions
- Procedures
- Databases
- None
Answer: B) Procedures
Explanation:
Database triggers are the procedures.
3. ___ CREATE TRIGGER statements are present in accordance with their firing points.
- Five
- Six
- Seven
- Eight
Answer: B) Six
Explanation:
Six CREATE TRIGGER statements are present in accordance with their firing points.
4. Which of the following is the FIRING POINT: BEFORE?
- BEFORE INSERT TRIGGER
- BEFORE UPDATE TRIGGER
- BEFORE DELETE TRIGGER
- All of the above
Answer: D) All of the above
Explanation:
The following are the FIRINT POINT: BEFORE -
- BEFORE INSERT TRIGGER
- BEFORE UPDATE TRIGGER
- BEFORE DELETE TRIGGER
5. Which of the following is not the FIRING POINT: AFTER?
- AFTER INSERT TRIGGER
- AFTER UPDATE TRIGGER
- BEFORE DELETE TRIGGER
- AFTER DELETE TRIGGER
Answer: C) BEFORE DELETE TRIGGER
Explanation:
BEFORE DELETE TRIGGER is not the FIRING POINT: AFTER.
6. In Oracle BEFORE INSERT/UPDATE/DELETE trigger statement, Oracle specifies that the trigger will be fired BEFORE _____ operations are executed.
- INSERT
- UPDATE
- DELETE
- All of the above
Answer: D) All of the above
Explanation:
In Oracle BEFORE INSERT/UPDATE/DELETE trigger statement, Oracle specifies that the trigger will be fired BEFORE INSERT, UPDATE, or DELETE operations are executed.
7. What are the parameters in the Oracle BEFORE INSERT/UPDATE/DELETE trigger statement?
- OR REPLACE
- Trigger_name
- Table_name
- All of the above
Answer: D) All of the above
Explanation:
The parameters in the Oracle BEFORE INSERT/UPDATE/DELETE trigger statement are OR REPLACE, trigger_name and table_name.
8. Which of the following is an optional parameter in Oracle BEFORE INSERT/UPDATE/DELETE trigger statement?
- Trigger_name
- Table_name
- OR REPLACE
- None
Answer: C) OR REPLACE
Explanation:
OR REPLACE is an optional parameter in Oracle BEFORE INSERT/UPDATE/DELETE trigger statement.
9. A trigger is re-created by using OR REPLACE if it already exists.
- Created
- Re-created
- Added
- Deleted
Answer: B) Re-created
Explanation:
A trigger is re-created by using OR REPLACE if it already exists.
10. A ____ statement cannot be used to change the trigger definition if the OR REPLACE parameter is specified.
- DROP TRIGGER
- ADD TRIGGER
- REPLACE TRIGGER
- None
Answer: A) DROP TRIGGER
Explanation:
A DROP TRIGGER statement cannot be used to change the trigger definition if the OR REPLACE parameter is specified.
11. The trigger name is specified by ____.
- Name
- Time
- Address
- Size
Answer: A) Name
Explanation:
The trigger name is specified by Name.
12. The ____ triggers will be fired before the INSERT, UPDATE, or DELETE operation.
- DELETE
- UPDATE
- INSERT
- All of the above
Answer: D) All of the above
Explanation:
The DELETE, UPDATE, and INSERT triggers will be fired before the INSERT, UPDATE, or DELETE operation.
13. The trigger operation will be performed on the _____ specified by the table_name parameter.
- Table
- Field
- Row
- Column
Answer: A) Table
Explanation:
The trigger operation will be performed on the table specified by the table_name parameter.
14. Which of the following is the limitation of using BEFORE INSERT/UPDATE/DELETE trigger?
- A view cannot have a BEFORE trigger.
- The OLD values cannot be updated.
- The NEW values are the only ones that can be updated.
- All of the above
Answer: D) All of the above
Explanation:
The following are the limitations of using BEFORE INSERT/UPDATE/DELETE trigger -
- A view cannot have an BEFORE trigger.
- The OLD values cannot be updated.
- The NEW values are the only ones that can be updated.
15. A trigger statement that specifies that Oracle will fire this trigger ____ the INSERT/UPDATE/DELETE operation is executed specifies that the trigger will be fired AFTER these operations are executed.
- BEFORE
- AFTER
- MIDDLE
- CENTER
Answer: B) AFTER
Explanation:
A trigger statement that specifies that Oracle will fire this trigger AFTER the INSERT/UPDATE/DELETE operation is executed specifies that the trigger will be fired AFTER these operations are executed.
16. If you need to remove a trigger from Oracle, use the ____ TRIGGER statement.
- DELETE
- DROP
- REMOVE
- None
Answer: B) DROP
Explanation:
If you need to remove a trigger from Oracle, use the DROP TRIGGER statement.
17. What is/are the parameter in DROP TRIGGER statement?
- trigger_name
- table_name
- Both A and B
- None of the above
Answer: A) Trigger_name
Explanation:
The parameter in DROP TRIGGER statement is trigger_name.
18. What is the syntax of DROP TRIGGER statement?
- DROP TRIGGER trigger_name;
- DELETE TRIGGER trigger_name;
- REMOVE TRIGGER trigger_name;
- None
Answer: A) DROP TRIGGER trigger_name;
Explanation:
The syntax of DROP TRIGGER statement is DROP TRIGGER trigger_name;.
19. A trigger can be disabled using the ____ TRIGGER statement.
- DISABLE
- ENABLE
- ALTER
- CHANGE
Answer: C) ALTER
Explanation:
A trigger can be disabled using the ALTER TRIGGER statement.
20. What is the syntax of DISABLE Trigger?
- ALTER TRIGGER trigger_name DISBALE;
- ALTER TRIGGER trigger_name ALTER;
- DISABLE TRIGGER trigger_name DISABLE;
- DISBALE TRIGGER trigger_name ALTER;
Answer: A) ALTER TRIGGER trigger_name DISBALE;
Explanation:
Syntax of DISABLE trigger is ALTER TRIGGER trigger_name DISABLE.
21. ALTER TRIGGER is used to ____ trigger.
- Disable
- Enable
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
ALTER TRIGGER is used to Disable and Enable triggers.
22. What is the syntax of ENABLE Trigger?
- ALTER TRIGGER trigger_name ENABLE;
- ALTER TRIGGER trigger_name ALTER;
- ENABLE TRIGGER trigger_name ENABLE;
- ENABLE TRIGGER trigger_name ALTER;
Answer: A) ALTER TRIGGER trigger_name ENABLE;
Explanation:
Syntax of DISABLE trigger is ALTER TRIGGER trigger_name ENABLE.