DB2 Interview Questions

On By In Interview Faqs

DB2 Interview Questions

  1. What is DCLGEN?
  2. What is a DB2 plan?
  3. At what stage db2 must be up?
  4. What is COPY PENDING status?
  5. How to increase table space in DB2?
  6. What is performance tuning in DB2?
  7. What are the various locks available?
  8. How to know other person job status?
  9. How do you select a row using indexes?
  10. What are the 2 sqlcodes that are returned?
  11. How does Db2 use multiple table indexes?
  12. How is a typical DB2 batch pgm executed?
  13. When you will use cursor with hold option?
  14. How do we unload the DB2 tables using JCL?
  15. What happens when you say OPEN CURSOR?
  16. What are the various locking levels available?
  17. What are the isolation levels available in DB2?
  18. What is stored in tables under creator SYSIBM?
  19. What are the disadvantages of PAGE level lock?
  20. How does DB2 determine what lock-size to use?
  21. What is severity one error in production support?
  22. What is diff b/w check pending and copy pending?
  23. How do you insert a record with a null able column?
  24. What is the index set and sequence set in VSAM ksds?
  25. What is the result of this query if no rows are selected?
  26. How will you send data from a COBOL file to DB2 table?
  27. How to access 10th record in a cursor results set query?
  28. What is the picture clause of the null indicator variable?
  29. How many clustering indexes can be defined for a table?
  30. What is the difference between CS and RR isolation levels?
  31. What is difference between 911 and 913 error code in DB2?
  32. Why SELECT * is not preferred in embedded SQL programs?
  33. How would you find out the total number of rows in a table?
  34. How to perform Performance Tunning on COBOL-DB2 program?
  35. What is the COBOL picture clause of the following DB2 data types?
  36. How would you retrieve rows from a DB2 table in embedded SQL?
  37. What is the difference between IN subs elects and EXISTS subselect?
  38. What is the physical storage length of each of the following DB2 data types?
  39. What is the COBOL picture clause for a DB2 column defined as DECIMAL (11, 2)?
  40. What techniques are used to retrieve data from more than one table in a single SQL statement?