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.

Related Posts

  1. General ( IT Notes → Database )
  2. RDBMS ( IT Notes → Database )
  3. Data Model ( IT Notes → Database )
  4. Logical Data Model ( IT Notes → Database )
  5. Physical and Relational Data Model ( IT Notes → Database )
  6. Data Normalization ( IT Notes → Database )
  7. Managing the RDBMS ( IT Notes → Database )
  8. Security ( IT Notes → Database )
  9. Performance Issue ( IT Notes → Database )
  10. SQL ( IT Notes → Database → SQL )
  11. Create Table ( IT Notes → Database → SQL )
  12. Import Data ( IT Notes → Database → SQL )
  13. Select ( IT Notes → Database → SQL )
  14. Update ( IT Notes → Database → SQL )
  15. Delete ( IT Notes → Database → SQL )
  16. Join ( IT Notes → Database → SQL )
  17. Create ( IT Notes → Database → SQL )
  18. View ( IT Notes → Database → SQL )
  19. MS SQL ( IT Notes → Database )
  20. Introduction ( IT Notes → Database → Oracle )
  21. Data Definition Language ( IT Notes → Database → Oracle )
  22. Data Manipulation Language ( IT Notes → Database → Oracle )
  23. Data Control Language ( IT Notes → Database → Oracle )
  24. Transaction Control Language ( IT Notes → Database → Oracle )
  25. Miscellaneous ( IT Notes → Database → Oracle )
  26. Abbreviations ( IT Notes → Abbreviations )
  27. OOP Concepts or Object Oriented Programming Concepts ( IT Notes → Object Oriented Programming )
  28. Basics ( IT Notes → Javascript )
  29. Regex ( IT Notes → Javascript )
  30. Functions ( IT Notes → Javascript )
  31. General ( IT Notes → Javascript )
  32. Debugging ( IT Notes → Javascript )
  33. Data Types ( IT Notes → PHP )
  34. Operators ( IT Notes → PHP )
  35. Design Pattern ( IT Notes → PHP )
  36. XML ( IT Notes → PHP )
  37. Security ( IT Notes → PHP )
  38. Streams and Network Programming ( IT Notes → PHP )
  39. Arrays ( IT Notes → C# )
  40. Namespace ( IT Notes → C# )
  41. Indexers ( IT Notes → C# )
  42. Generics ( IT Notes → C# )
  43. Attributes ( IT Notes → C# )
  44. Anonymous Types ( IT Notes → C# )
  45. Performance Thumb Rules ( IT Notes → C# )
  46. Different Types of Testing ( IT Notes → Testing )
  47. SAS 70 Type II Audit – Data Security ( IT Notes → Testing )
  48. Tracking Defects ( IT Notes → Testing )
  49. General ( IT Notes → SEO )
  50. IT Notes ( IT Notes )
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