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.
- IT Notes
- Data Model
- Logical Data Model
- Physical and Relational Data Model
- Data Normalization
- Managing the RDBMS
- Performance Issue
- MS SQL
- URL Rewrite
- Project Management