Interested to Buy Any Domain ? << Click Here >> for more details...
define different types of trigger. : Sql dba
- 1 Answers
- 1252 Views
- I also Faced
- E-Mail Answers
Answer / kiran r
Triggers are classified as follows
1. Based on Trigger level
Row level Trigger and Statement level trigger
2. Based on time
Before, after, Instead
3. Based on Event
DDL, DML,Database Trigger
| Is This Answer Correct ? | 0 Yes | 0 No |
What is sql and db2?
What is break?
When do we use triggers?
What is correlated sub-query?
i need department wise top 2 employees salary.which logic i will use
What is difference between nchar and nvarchar?
how will be date change into string
What is pl/sql table? Why it is used?
Do stored procedures prevent sql injection?
What is the difference between nested table and varray?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.
-
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)
