Just Crack Interview

DB2 interview questions

233 questions. Tap “Show answer” to check yourself.

Advertisement

  1. How can you quickly find out the # of rows updated after an update statement?

  2. What do you mean by NOT NULL?

  3. What is a collection ID? What is its significance?How to execute the diffrent versions of a Cobol-DB2 programs (different regions) from a single jcl?

  4. How do I see the table definitions (columns, data types of columns, constraints or default values set etc) of a table in QMF? I tried 'DESCRIBE TABLE' but didn't work (not able to execute in QMF). I can see the DCLGEN but looking for a way to

  5. When will you use NOT NULL?

  6. What is Mainframe Testing?

  7. How do you select a row using indexes in DB2?

  8. What are the disadvantages of PAGE level lock? - RAMESH www.geocities.com/srcsinc

  9. How do you pull up a query which was previously saved in QMF ? ?

  10. How many columns maximum can be created in a table of a inner table of the subquerry

  11. What is the result of this query if no rows are selected:

  12. What does the IS NUMERIC clause establish ?

  13. Advertisement

  14. How would you find out the total number of rows in a DB2 table?

  15. What is the physical storage length of each of the following DB2 data types:

  16. A userdefined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.

  17. How would you find out the total number of rows in a table? ?

  18. How to execute the diffrent versions of a Cobol-DB2 programs (different regions) from a single jcl?

  19. What are the issues related with correlated subqueries? ????

  20. How do you find the maximum value in a column in db2?

  21. What are difference between version control and debugging tools?

  22. Why we use db2 with cobol why we cant use any other languages? what the main reason?what is disaster recovery?

  23. What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)? - Ramesh

  24. How do you eliminate duplicate values in DB2 SELECT ?

  25. How will u send data from a cobol file to db2 table?

  26. Advertisement

  27. What is filter factor?

  28. What is the COBOL picture clause of the following DB2 data types:

  29. Name some fields from SQLCA.

  30. What is data dictionary in DB2? and how is it handled?

  31. What is a collection ID? What is its significance?

  32. Can GROUP BY and ORDERED BY used in a single query?

Advertisement
Advertisement