Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are triggers?Where are they used?

Answers were Sorted based on User's Feedback



What are triggers?Where are they used?..

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

What are triggers?Where are they used?..

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

What are triggers?Where are they used?..

Answer / harsha vardhan reddy

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

Post New Answer



More Oracle General Interview Questions

How to rebuild an index in oracle?

0 Answers  


Is primary key indexed by default in oracle?

0 Answers  


How to add a new column to an existing table with a default value?

0 Answers  


How to get execution path reports on query statements?

0 Answers  


How to retrieve first and last records from a table?

7 Answers   DELL, QSmart,






What are triggers?Where are they used?

3 Answers  


How do I recompile a procedure in oracle?

0 Answers  


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

0 Answers   IBM,


What is redo log?

0 Answers  


How to run queries on external tables?

0 Answers  


How to save query output to a local file?

0 Answers  


How to Select second Maximum salary in a Table ?

13 Answers   Oracle,






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)