Answer Posted / nishi
Database trigger is a stored procedure that invokes automatically when a predefined event occurs.The usage of database trigger is to audit the data modification.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain do view contain data?
How to insert a new row into a table in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is SQL access advisor in Oracle?
Difference between pre-select and pre-query
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is a dead lock in oracle?
What are the attributes that are found in a cursor?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the difference between I and G in Oracle?
What is control file used for?
What is connection pool in oracle?
What is truncate oracle?
How to define default values for formal parameters?
How to call a sub procedure?