Infosys Certified Mainframe DB2 Developer
Practice with real exam-pattern questions for Infosys Certified Mainframe DB2 Developer. 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 DB2 Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Mainframe DB2 Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
User Defined Functions can be nested upto __________ layers.
- ✓ 16 Correct
- B 15
- C 18
- D 17
- Question 2
Which of the following is true about Cascading triggers?
(i) Activating a trigger on execution of another trigger statement is called cascading of triggers
(ii) SQL error of -724 occurs when cascading reaches 17 and all the SQL changes made till this point will be rolled back
(iii) SQL error of -724 occurs when cascading reaches 17 and all the SQL changes made till this point will be committed
(iv) BEFORE triggers cannot be cascaded
(v) AFTER triggers cannot be cascaded- ✓ (i), (ii) and (iv) Correct
- B (i), (iii) and (iv)
- C (i), (ii) and (V)
- D (i), (iii) and (v)
- Question 3
The following is an example of which kind of function?
CREATE FUNCTION AVG_S(T2)
RETURNS T2
SOURCE SYSIBM.AVG(DECIMAL(8,2));- ✓ SCALAR UDF Correct
- B SOURCED UDF
- C EXTERNAL UDF
- D None of the above
- Question 4
Which of the following operation on the table CANNOT activate the trigger?
- ✓ INSERT Correct
- B DELETE
- C SELECT
- D UPDATE
- Question 5
Which of the following statements can be coded inside body of a trigger?
- ✓ CALL Correct
- B SET
- C SIGNAL
- D All the above
- Question 6
_______________ option can be specified with the UDFs in case the UDF is invoked multiple times.
- ✓ STAY RESIDENT NO Correct
- B STAY RESIDENT YES
- C NO COLLID
- D EXTERNAL NAME
- Question 7
What are the possible operations that a trigger can perform?
- ✓ Submit a JCL Correct
- B Display error or information messages
- C Send an email
- D All the options
- Question 8
Which of the following is/are FALSE about CASCADING triggers?
(i) In DB2, AFTER triggers can not be cascaded.
(ii) In DB2, BEFORE triggers can not be cascaded.
(iii) The CASCADING of triggers is possible upto 16 levels only.- ✓ (i), (ii), (iii) Correct
- B Only (ii), (iii)
- C Only (i), (iii)
- D Only (i)
- Question 9
Which option should be specified to indicate that apart from the actual parameters and return values,some additional information like indicator variables and error routines will also be returned by the User Defined Function?
- ✓ PARAMETER STYLE DB2SQL Correct
- B NO SQL
- C NO COLLID
- D FENCED
- Question 10
Which option should be used in order to make the User Defined Function re-entrant?
- ✓ FENCED Correct
- B STAY RESIDENT NO
- C PARAMETER STYLE DB2SQL
- D STAY RESIDENT YES
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.