define different types of trigger. : Sql dba
- 1 Answers
- 870 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 |
Enlist the advantages of sql.
how does a local variable is defined using t-sql? : Transact sql
Can we use out parameter in function?
What is the sql*loader? : aql loader
How would you convert date into julian date format?
Is nosql relational?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
How do you optimize a stored procedure query?
What is sql architecture?
how many columns can be used for creating index? : Sql dba
What is pl/sql and what is it used for?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
