Interested to Buy Any Domain ? << Click Here >> for more details...
Maximum how many triggers can be updated in table ?
- 5 Answers
- 16244 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / khushal
The oracle table can have the 12 Trigger associated with it.
-- before constraints are applied
1) BEFORE INSERT STATEMENT LEVEL
2) BEFORE INSERT ROW LEVEL
3) BEFORE UPDATE STATEMENT LEVEL
4) BEFORE UPDATE ROW LEVEL
5) BEFORE DELETE STATEMENT LEVEL
6) BEFORE DELETE ROW LEVEL
7) AFTER INSERT STATEMENT LEVEL
8) AFTER INSERT ROW LEVEL
9) AFTER UPDATE STATEMENT LEVEL
10) AFTER UPDATE ROW LEVEL
11) AFTER DELETE STATEMENT LEVEL
12) AFTER DELETE ROW LEVEL
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / ora
System Privileges Related To Table Triggers
create trigger
create any trigger
administer database trigger
alter any trigger
drop any trigger
Table Trigger Firing Options
-- before constraints are applied
BEFORE INSERT
BEFORE UPDATE
BEFORE DELETE
-- after constraints are applied
AFTER INSERT
AFTER UPDATE
AFTER DELETE
| Is This Answer Correct ? | 5 Yes | 2 No |
What are the logical operations?
How to create a single index for multiple columns?
Give the different types of rollback segments.
What are ACID properties in databases?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
When a form is invoked with call_form, Does oracle forms issues a save point ?
What is a read write transaction in oracle?
What is a trigger and what are its types?
How do you bind variables in oracle?
what happened to the global index when I truncate the data in one of the partition?
How to retrieve first and last records from a table?
Oracle General 
