Interested to Buy Any Domain ? << Click Here >> for more details...
What is trigger ?
- 7 Answers
- 11898 Views
- Cap Gemini, SQL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh tankala
Trigeer is like stored procedure which executes
automatically .
Trigger is User defined data integrity
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / piyush
Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / indu bala
trigger is any event which is raised automatically by
database server after any instruction like
update,delete,insert is performed
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / kalyana chakravarthy maddipati
A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramya
Trigger is a server-side progrm used for events(user
actions-click,key press etc..)
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / abdulla
Trigger is Limited form stored procedure associated with tables.
| Is This Answer Correct ? | 0 Yes | 2 No |
What are statistics, under what circumstances they go out of date, how do you update them?
difference between Clustered index and non clustered index ?
Explain the phases a transaction has to undergo?
What is the most common trace flags used with sql server?
How to access the inserted record of an event?
What is @@rowcount in sql?
What is scheduled job and how to create it?
Where are sql server usernames and passwords stored in the sql server?
Are null values the same as that of zero or a blank space?
how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100
What is the difference between Triggers and Stored Procedure?
How to find the second highest salary of an employee?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
