Triggers
Authored by harshali patil
Computers
University
Used 91+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A __________ is a special kind of a stored procedure that executes in response to certain event on the table like insertion, deletion or updation of data.
procedure
function
trigger
package
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Triggers are supported on
procedure
function
cursor
views
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the after triggers?
Triggers generated after a particular operation
These triggers run after an insert, update or delete on a table
These triggers run before an insert, views, update or delete on a table
None of these
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is NOT an Oracle-supported trigger?
BEFORE
AFTER
DURING
INSTEAD OF
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Triggers ________ enabled or disabled
can be
can not be
delete
always
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which prefixes are available to Oracle triggers?
only :new
only :old
both :new and :old
None of these
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
_______ is used to recreate, if trigger already exists.
cursor
trigger
replace
create
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
