Outputs of explain are with matchcols = 0. What does this signify?


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

Post New Answer

More DB2 Interview Questions

Return code 100 means?

6 Answers   Cap Gemini,


What is a clustering index ?

3 Answers  


What is load replace in db2?

0 Answers  


What is reorg and runstats in db2?

0 Answers  


How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  






How is the value function used?

0 Answers  


What is dbrm? When it will be created?

0 Answers  


What is the self-referencing constraint?

2 Answers  


Who uses db2?

0 Answers  


What is IMAGECOPY ?

6 Answers  


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 .

2 Answers   Cognizant,


What is a dbrm in db2?

0 Answers  


Categories