Which isolation level provides maximum concurrency?
No Answer is Posted For this Question
Be the First to Post Answer
What is query_cache_limit?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is reorg in database?
How can you get the number of rows impacted by the last executed query?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
Mention the downsides of page level lock.
In which column of which DB2 catalog would you find the length of the rows for all tables?
How many types of page locks can be held in db2?
Is there any advantage to denormalizing DB2 tables?
What is access path in db2?
Explain the function done by data manager?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?