Infosys Certified L1 Junior Mainframe Programmer
Practice with real exam-pattern questions for Infosys Certified L1 Junior Mainframe 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 L1 Junior Mainframe Programmer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified L1 Junior Mainframe Programmer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Consider the below EMP table data:
EMPNO ENAME JOB SAL COMM
------ ------------------------------ --------------- ---------- ----------
7369 Smith Clerk 800 NULL
7499 Allen Salesman 1600 300
7521 Ward Salesman 1250 500
7654 Martin Salesman 1250 1400
7844 Turner Salesman 1500 0
7876 Adams Clerk 1100 NULL
7934 Miller Clerk 1300 NULL
What will be the OUTPUT of the below query?
SQL> DELETE FROM EMP WHERE SAL>1500 OR COMM IS NULL;
- ✓ 4 rows will be deleted Correct
- B Delete all the rows
- C 3 rows will be deleted
- D Error in the query
- Question 2
Assume there is a table named EMP with below data:
EMPNO EMPNAME LOCATION SALARY (in thousands)
1111 ROHAN BLR 4
1112 SEETHA CHN NULL
1113 YASINI TVM 3
1114 UMA TVM 3
1115 KIRAN PUN NULL
1116 REENA PUN NULL
Identify the correct query to select the employees whose salary is null.- ✓ SELECT * FROM EMP WHERE SALARY = NULL; Correct
- B SELECT * FROM EMP WHERE SALARY IS NULL;
- C SELECT * FROM EMP WHERE SALARY NOT > 0;
- D None of the options
- Question 3
Assume there is a table name ITEM with below data:
ITEMNO ITEMNAME VENDORID
IT111 RULER V1111
IT112 GEOMETRY BOX V1112
IT113 NOTES V1111
IT114 COLOR BOOK V1112
IT115 CLAY BOX V1113
What will be the output of the following query?
SELECT COUNT(ITEMNO) FROM ITEM GROUP BY VENDORID;- ✓
2
2
1 Correct - B 5
- C
2
2 - D None of the options
- ✓
2
- Question 4
Assume there are 2 entities named STUDENT and CLASS. Each student will be associated with one class.
Which relationship does it satisfy?- ✓ One to Many relationship Correct
- B One to One relationship
- C Many to One relationship
- D Many to Many relationship
- Question 5
For every row of the outer query, the inner query gets executed. This is true in the case of ___________
- ✓ Correlated sub query Correct
- B Independent sub query
- C Inner Join
- D Outer Join
- Question 6
Assume there is a table named EMP with below data:
EMPNO EMPNAME LOCATION SALARY (in thousands)
1111 ROHAN BLR 4
1112 SEETHA CHN 5
1113 YASINI TVM 3
1114 UMA TVM 3
1115 KIRAN PUN NULL
1116 REENA PUN 2
What will be the output of the following query?
SELECT SUM(SALARY) FROM EMP;- ✓ ERROR IN DATA, Sum cannot be performed Correct
- B 15
- C ERROR IN QUERY
- D 17
- Question 7
Which of the following is a z/OS Subsystem?
(i) TSO
(ii) CICS
(iii) RACF
(iv) VTAM- ✓ only (i), (ii) and (iii) Correct
- B (i), (ii), (iii) and (iv)
- C only (i), (iii) and (iv)
- D only (i), (ii) and (iv)
- Question 8
What will be the total size of physical blocks in case of non VSAM datasets with fixed unblocked and variable unblocked record formats respectively, if the size of the logical record is 10 bytes?
- ✓ 50 bytes, 74 bytes Correct
- B 10 bytes, 14 bytes
- C 14 bytes, 10 bytes
- D 74 bytes, 50 bytes
- Question 9
Consider a Non-VSAM dataset with fixed blocked record format, in which a block contains 2 records each of length 10 bytes. What will be the total size of the block?
- ✓ 20 bytes Correct
- B 28 bytes
- C 32 bytes
- D 10 bytes
- Question 10
SPOOL is an acronym for __________.
- ✓ Simultaneous Peripheral Operations OnLine Correct
- B similar Program Operations OnLine
- C Simultaneous Peripheral Output OnLine
- D Simultaneous Program Output OnLine
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.