PDA

View Full Version : DB2


  1. What do the initials DDL and DML stand for and what is their meaning
  2. Why we use db2 with COBOL why we cant use any other languages? what the main reason
  3. Explain the use of the WHERE clause. WHERE is used with a relational statement
  4. What are foreign keys
  5. What is normalization and what are the five normal forms
  6. What is a DB2 plan
  7. What is a DB2 access path
  8. What is a DB2 bind
  9. What is an alias and how does it differ from a synonym
  10. What is a NULL value? What are the pros and cons of using NULLS
  11. What is the cascade rule and how does it relate to deletions made with a sub select
  12. Under what circumstances will DB2 allow an SQL statement to update more than one
  13. If the base table underlying a view is restructured, eg. attributes are added, does
  14. What is a LIKE table and how is it created
  15. When can an insert of a new primary key value threaten referential integrity
  16. What are delete-connected tables
  17. What is the self-referencing constraint
  18. What is a clustered index
  19. What is meant by index cardinality
  20. What is a composite index and how does it differ from a multiple index
  21. What are some characteristics of columns that benefit from indexes
  22. How does Db2 use multiple table indexes
  23. In terms of DB2 indexing, what is the root page
  24. What are the three DB2 date and time data types and their associated functions
  25. How is the SUBSTR keyword used in sql
  26. What are some sql aggregates and other built-in functions
  27. What are the three lock types
  28. What is deadlock
  29. What is the SQL Communications Area and what are some of its key fields
  30. What is the significance of the CURSOR WITH HOLD clause in a cursor declaration
  31. What is cursor stability
  32. What is the difference between static and dynamic sql
  33. What is the FREE command
  34. What is DCLGEN
  35. What is the purpose of the WHENEVER statement
  36. What is the difference between IN sub selects and EXISTS sub select
  37. What is meant by isolation level
  38. What is a precompiler
  39. What is the diff bet plan,package,dbrm
  40. By using any condition is there any way to avbend a program?If so how
  41. After bind how can we run a COBOL-db2 program
  42. What is the index set and sequence set in vsam ksds
  43. How to increase table space in db2
  44. What is severity one error in production support
  45. How to Repair the table
  46. What techniques are used to retrieve data from more than one table in a single SQL
  47. What is a packed decimal
  48. After retrieving the elements from production,how can we do the testing before moving
  49. What is diff b/w check pending and copy pending
  50. How to pass return codes from COBOL to jcl
  51. There are two programs say A&B,A is only COBOL program,B is COBOL-db2 program
  52. How to enter in expediter
  53. Explain the Commonly facing errors in DB2
  54. What will happened ,if the subprogram is called second time
  55. What will happened if the file is open in extend mode and corresponding is equal to
  56. Explain File opening modes in COBOL and corresponding dispositions
  57. What is Initial position of cursor of the execution of open statements
  58. When do we use subroutines
  59. At what stage db2 must be up
  60. Can you display the index
  61. What is the index and explain the types of index
  62. What is an intent lock
  63. What is low values and high values
  64. How to read last record in vsam file.,I don't know how many records are there
  65. How many clustering indexes are passing for a table
  66. How to see the status of the table
  67. When we will use courser with hold option
  68. Describe the elements of the SELECT query syntax
  69. What is difference between QMF & Spoof i
  70. How to load data to a table
  71. What is stored in tables under creator SYSTEM
  72. What is the roll of INDEX in a query
  73. When do we need a COLLECTION
  74. How many columns maximum can be created in a table of a inner table of the sub query
  75. Can GROUP BY and ORDERED BY used in a single query
  76. How will you send data from a COBOL file to db2 table
  77. What is a collection ID? What is its significance
  78. How to execute the different versions of a COBOL-DB2 programs (different regions)
  79. What is Mainframe Testing
  80. What is data dictionary in DB2? and how is it handled
  81. What is difference between Collection and Version
  82. How to retrieve n-th row ie n-th record of any table irrespective of the columns
  83. What are Dedicated and Pool Threads
  84. What is maximum number of one storage group
  85. How will the program knows which key has been pressed
  86. How do we see the table definitions (columns, data types of columns, constraints