Interested to Buy Any Domain ? << Click Here >> for more details...
Maximum how many triggers can be updated in table ?
- 5 Answers
- 16474 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between a primary key & a unique key?
Describe an oracle table?
What are the system predefined user roles?
How many types of tables are there in oracle?
Which are the five query types available in oracle?
Explain a synonym?
What are the different types of modules in oracle forms?
How does Oracle guarantee data integrity of data changes?
Explain the use of file option in exp command.
How to use subqueries with the exists operator in oracle?
How do we create privileges in oracle?
What is the relation of a user account and a schema in oracle?
What is oracle rowcount?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is Undo Management Advisor in Oracle?
