Question { Evalueserve, 12975 }

what is the cursor life span?

Answer

hi friends this is answer as per me,

when static cursor used the cursor lifespan is within
the program only(pl/sql program).its life end when it comes
outside the program
when dynamic cursor is used the cursor is accessable by
outside other programs with in same connection ,not another
connection.i.e its lifespan is with in connection

Question { TCS, 13990 }

what is a cursor

Answer

cursor acts as datatype for holding composite
variable.composite variable hold more than one value at a
time.

when ever u declare a cursor it tells to sqlserver that
memory is create for that cursor
whenever u open the cursor it executes select statement in
declare section and reserves memory stored the result of
execution in this memory.and reserves pointer to the before
first

Question { 7617 }

what is namespace?

Answer

namespace is collection of different types of classes

Question { HP, 46377 }

What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table

Answer

in first query 1=1 always true,then it retrives all columns
in a table.
so,there is no difference in between these two

Question { TCS, 96664 }

Advantages and Disadvantages of Cursor?

Answer

as per my Knowledge cursor is data type which is used to
define multivalue variable.if u take int a ,here a is
static variable which hold only one value at a time.in some
situvations we need data type variable which hold
multivalues


if any one find new answer ,send me
nag.mca08@gmail.com

Question { eXensys, 16960 }

What are the Different layers in ADO.Net?

Answer

1.
2.business logic layer
3.data access layer