Mention the location where the output received from explain statement is stored.


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

Post New Answer

More DB2 Interview Questions

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


Explain the function of data manager.

0 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,


explain about index with examples

2 Answers   Syntel,


what is a trigger and types of triggers

3 Answers   HSBC,


Give a brief description of db2 isolation levels?

0 Answers  


what is a corelated subquerry?

0 Answers   IBM,


What is a Cartesian product?

2 Answers  


I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,


what is a collection?

2 Answers  


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 ?

0 Answers   IBM,


How is the value function used?

0 Answers  


Categories