Skip to content

Programming

IT Notes → Database @ December 22, 2020

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database


Cursors provide a mechanism by which a database client iterates over the records in a database.

Scrollable and NonScrollable (Forward one step only at a time) cursors are there.


A stored procedure is a subroutine available to applications accessing a relational database system


Two Phase Commit is the process by which a relational database ensures that distributed transactions are performed in an orderly manner. In this system, transactions may be terminated by either committing them or rolling them back.

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x