What are the various locking levels available?
Answers were Sorted based on User's Feedback
Answer / ram
Cursor Stability, Read Stability, Uncommited Read and Repeatable Read
| Is This Answer Correct ? | 0 Yes | 2 No |
select 100 records from million records ?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is load replace in db2?
What is catalog database in db2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How many databases are there?
What is auditing?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
Write a query to extract first 5 characters of a name in the column Stud_Name?
What else is there in the PLAN apart from the access path?
What is a synonym ?
What is a view? Why use it?