Capgemini Walk-in - September 8, 2012

Experience: 2-10 years

Interview Rounds: 1st Round: Test 2nd Round: Interview 3rd Round: Offer

Following questions were asked in the mainframe test:

1. Condition code for duplicate records in VSAM?
2. IS NULL or = NULL in a SELECT statement?
3. Maximum size of a Control Interval (CI)?
4. What happens after a CI is full?
5. Questions on the COND parameter?
6. Which of the following cannot be rolled back? a) DELETE TABLE b) DROP TABLE c) UPDATE d) INSERT
7. GROUP BY and ORDER BY SQL queries?
8. Maximum extents in a VSAM file?
9. Questions on DPRTY=(1,10)?
10. Range of condition codes in COBOL?
11. OCCURS clause cannot be used at which level?
12. Delimiter in JCL?
13. SORT card for a file in PGM=SORT?
14. Is a PIC(6) value of 120056 possible?
15. Questions on BLKSIZE: Is (20,20) and (20,10) possible?
16. Number of bytes in RDF?
17. Can we use an index in WS-SECTION or LK-SECTION?
18. What is the VERIFY command in IDCAMS used for?
19. Question on Alternate Index?
20. Return code for file attribute mismatch?
21. In which format are COBOL variables stored?
22. What is an alternate for HANDLE?
23. Can SUM, AVG, MIN, ROUND be used with numeric and character data types?
24. What is the data type of FILE STATUS codes in WS-SECTION?

select queries