Interested to Buy Any Domain ? << Click Here >> for more details...
What are triggers?Where are they used?
- 3 Answers
- 6409 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arshi
trigger is autorun query. for example if you perform some
operation that time some operation(insert,delete) shuld be
execute automatically that time you have to use trigger
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vamsi krishna
triggers are the named pl/sql blocks which are executed
automatically at the specified events.the event at which
triggers are executed is called as the triggering
event.there are 3 types of triggers
(i) dml triggers:
these triggers are executed either before or after any dml
events(i.e insert or update or delete)
(ii) ddl triggers:
these triggers are executed either before or after any ddl
events(i.e create or alter or rename or truncate or drop)
(iii) database triggers
these trigger are executed either before or after any
database events(i.e logon or logoff or startup or shutdown)
database triggers can be created only by user having dba
privileges.
using triggers we can perform the following operations
(i) auto managing of data
(ii) auditing of data
(iii) auditing of events
(iv)defining of validations
| Is This Answer Correct ? | 4 Yes | 1 No |
A set of PLSQL statements "automatically" executed when DML
statements are performed and stored parmanently in database.
USES:- used to impose user defined restrictions or business
rules on database table
| Is This Answer Correct ? | 1 Yes | 1 No |
Define 'view' advantage ?
What are internal user account in oracle?
Can you assign multiple query result rows to a variable?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Explain integrity constraints?
various types of hints and their usage
What is oracle open database communication (odbc)?
what are the disadvantages of hierarchial database over RDBMS?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to define an anonymous block?
What are the different types of partitions in oracle?
What is cursor
Oracle General 
