-
What is isolation level?
SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level.
ramanatcs
- Dec 24th, 2008
Isolation Level determines the duration of the lock over a page.3 level are there.1. Cursor Stability : lock is retained when untill the cursor moves from one record in one page to the next reco...
-
What are some sql aggregates and other built-in functions?
The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.
ramanatcs
- Dec 24th, 2008
STDDEV ( Standard Deviation )VARIANCE These are used in stastical calculations.
