describe and contrast a trigger and a procedure.
Answer / Rishi Kumar Lohiya
A trigger is a database object that automatically executes in response to certain events such as insert, update, or delete operations. Triggers are used for data consistency and integrity checking, whereas procedures are a set of SQL statements that can be called and executed multiple times with different parameters. Procedures are used for complex tasks such as calculations, conversions, and error handling.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you export a table along with partition?
Where is the data stored in a database?
Define union all operator and union.
What is different keys in dbms?
Mention some disadvantages of query?
What are the steps in creating a database?
How do you copy a database?
Dept wise avrage salary
What is a distributed database system?
Define view, sequence and index in DBMS.
What's the difference between star and snow flake schema?
When is a .FMB file extension is created in Forms 4.5 ?
Oracle (3253)
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)