How can you get the number of rows impacted by the last executed query?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is meant by the attachment facility?
where can we use index and subscript ? with example ?
what is check point and restart Logic ? why do we go for that ??
What are common abends
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
Explain what are the various isolation levels possible?
What techniques are used to retrieve data from more than one table in a single SQL statement?
What is the physical storage length of date data type?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
When do you specify the isolation level?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?