DB2 Quiz 11-20

• • Q11 - What does SQLCA stands for?
  • A - SQL Communications Area
  • B - SQL Control Area
  • C - SQL Connection Area
  • D - SQL Control Access
  • Answer : A - SQL Communications Area
  View Answer
• • Q12 - Failure to use null indicator variable when referencing a nullable column will give the following SQLCODE
  • A - +150
  • B - –100
  • C - +276
  • D - -305
  • Answer : D - -305
  View Answer
• • Q13 - When there is no data available to satisfy the FETCH condition DB2 places a return code
  • A - +000
  • B - –001
  • C - +904
  • D - +100
  • Answer : D - +100
  View Answer
• • Q14 - Which SQLCODE is used to check for duplicate index on a column?
  • A - –811
  • B - –803
  • C - –805
  • D - -865
  • Answer : B - –803
  View Answer
• • Q15 -
  • A -
  • B -
  • C -
  • D -
  • Answer :
  View Answer
• • Q16 - A Plan is
  • A - Is an executable module containing access path logic provided by the DB2 optimizer
  • B - In an non executable module containing access path logic provide by the DB2 optimizer
  • C - Is just a module containing DBRM
  • D - Is a module containing DCLGEN
  • Answer : A - Is an executable module containing access path logic provided by the DB2 optimizer
  View Answer
• • Q17 - Which of the following are valid fields from SQLCA
  • A - SQLCODE
  • B - SQLERRM
  • C - SQLERRD
  • D - All of above
  • Answer : D - All of above
  View Answer
• • Q18 - Which of the following is invalid data type in DB2
  • A - SMALLINT
  • B - FLOAT
  • C - DATE
  • D - LONGINT
  • Answer : D - LONGINT
  View Answer
• • Q19 - When you COMMIT, is the cursor closed?
  • A - Yes
  • B - No
  • Answer : A - Yes
  View Answer
• • Q20 - How do you find the maximum value in a column?
  • A - Use SELECT BIG(...
  • B - Use SELECT HIGHEST(...
  • C - Use SELECT MAX(...
  • D - None of above
  • Answer : C - Use SELECT MAX(...
  View Answer