What is query_cache_limit?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is an asychronous write?

1 Answers  


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  


What is phantom read in db2?

0 Answers  


How many types of page locks can be held in db2?

0 Answers  


i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,


What is an instance database?

0 Answers  


What is buffer pool in the db2 database?

0 Answers  


how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,


db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,


What is a DB2 bind?

3 Answers  


Why might full image copies be faster to implement than an incremental image copy?

4 Answers  


When is the access path determined for dynamic SQL?

2 Answers  


Categories