Page 229 - Open Soource Technologies 304.indd

Open Source Technologies

Notes 13.4 Keywords

COMMIT: COMMIT command should be issued so that the changes to all involved tables will
take effect.

Function: A function is a subprogram written to perform certain computations and return a
single value.
ROLLBACK: ROLLBACK command should be issued to return every table referenced in the
transaction to its previous state.
Stored Procedure: A stored procedure is a subroutine available to applications accessing a
relational database system.
Transaction: A transaction is a sequential group of database manipulation operations, which is
performed as if it were one single work unit.

1. Using SQL statements, create stored parameter.

2. Create a database of hospital management.
13.5 Self Assessment Questions

1. _______________ is a sequential group of database manipulation operations, which is
performed as if it were one single work unit.
(a) Stored procedure (b) Transaction
(c) Linux (d) None of these.
2. COMMIT command should be issued to return every table referenced in the transaction
to its previous state.
(a) True (b) False

3. A _______________ is a subroutine available to applications accessing a relational database
system.
(a) Stored procedures (b) Transaction
(c) SQL (d) None of these.
4. Functions must return a value.

(a) True (b) False
5. _______________ are enclosed within parenthesis with the parameter name.
(a) Functions (b) Statements
(c) Parameters (d) None of these.

13.6 Review Questions

1. What do you mean by transactions?
2. Explain the following commands:

(a) COMMIT
(b) ROLLBACK

224 LOVELY PROFESSIONAL UNIVERSITY