Schedule in DBMS
Schedule ( Meaning:- program/event/task:-, a plan for carrying out a process or procedure, giving lists of intended events and times. ) A series or set of instructions that perform specific operations. Maintain the order of the operation according to time in each transaction. Example: Schedule involving two transactions T 1 and T 2 . …
Read more
DBMS Transaction Management: Introduction (ACID properties )
DBMS Transaction Management: Introduction (ACID properties ) Introduction · A database transaction: - · A set of logically related operation Involve in one or more database access operation. · Contains a group of tasks. · Represent real-world events of any enterprise. · All database operation held between the…
Read more
PL/SQL Trigger
PL/SQL Trigger Triggers are stored programs, which are automatically executed or fired when some events occur. Triggers are executed in response to any of the following events − · A database manipulation (DML) statement (DELETE, INSERT, or UPDATE) · A database definition (DDL) statement (CREATE, ALTER, or DROP). · A d…
Read more
Social Plugin