Infosys Certified Mainframe COBOL-DB2 Programmer
Practice with real exam-pattern questions for Infosys Certified Mainframe COBOL-DB2 Programmer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Mainframe COBOL-DB2 Programmer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Mainframe COBOL-DB2 Programmer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
What does the value of -2 in NULL INDICATOR associated with host variable in a SQL statement signify?
- ✓ The host variable has a NULL value Correct
- B The column was set to null as a result of a data conversion error and hence the host variable has an invalid value
- C The host variable has a NOT NULL value
- D None of the options
- Question 2
Which of the following is used to communicate information describing the success or failure of the execution of an embedded SQL statement?
- ✓ DCLGEN Correct
- B SQLCA
- C SPUFI
- D None of the options
- Question 3
Consider an EMPLOYEE table with the below structure:
ID Decimal(5,0)
NAME Char(10)
Assume there are no syntax errors in the below snippet and there are no rows in the table.
PROCEDURE DIVISION.
MAIN-PARA.
EXEC SQL
SELECT MAX(ID) INTO :WS-ID FROM EMPLOYEE
END-EXEC
DISPLAY ' ID: ' WS-ID
STOP RUN.
Which of the following is correct?- ✓
ID:
will be displayed Correct - B there will be a compilation error
- C ID: 00000 will be displayed and an error stating that null values cannot be assigned to a host variable
- D A bind error for missing null value INDICATOR Variable
- ✓
ID:
- Question 4
Which of the following is an optional step in preparation of a COBOL-DB2 program for execution?
- ✓
Precompile
Correct - B
Bind package
- C
Bind Plan
- D
None of the options
- ✓
- Question 5
What will be the result of the following embedded SQL statement?
EXEC SQL
SELECT EMPID, EMPNAME FROM EMPLOYEE --WHERE EMPID=10000
END-EXEC.- ✓ The EMPID and EMPNAME of the employee with EMPID as '10000' are fetched from the table EMPLOYEE. Correct
- B The EMPID and EMPNAME of all the employees are fetched from the table EMPLOYEE.
- C Gives a compilation error.
- D Gives a precompilation error.
- Question 6
WITH HOLD clause is specified in DECLARE CURSOR step to
(i) Prevent cursor from implicit closing
(ii)To update a row using cursor
(iii)To delete a row using cursor- ✓
Only (i)
Correct - B
Only (ii)
- C
Only (iii)
- D
All of these
- ✓
- Question 7
Which of these conditions can be checked in a COBOL Host program to identify that there are no more rows to be read from a DB2 CURSOR?
- ✓ SQLCODE=+100 Correct
- B SQLCODE=0
- C Host Variable value = NULL
- D Host variable value = ZEROES for numeric data and Host variable value = SPACES for alphanumeric data
- Question 8
Where is an embedded SQL statement coded in a COBOL program?
- ✓ Between columns 1 and 72 Correct
- B Between column 12 and 72
- C Between column 8 and 72
- D None of the options
- Question 9
Which of the following is/are used in the program using the INCLUDE statement?
- ✓ SQLCA Correct
- B DCLGEN MEMBER
- C Both SQLCA and DCLGEN member
- D None of the options
- Question 10
What is the COBOL equivalent of the DB2 datatype 'INTEGER' ?
- ✓ S9(9) USAGE COMP-3 Correct
- B S9(9) USAGE COMP
- C S9(4) USAGE COMP
- D S9(9)V USAGE COMP-3
More in Mainframe
Infosys Certified Mainframe Batch Application Programmer
Infosys Certified Mainframe REXX Automation Tools Developer
Infosys Certified Mainframe Rehosting Professional
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.