Monday, February 06, 2006

Interview Questions

1)How do you resolve SOC 7 errors 2)How will you decide the LRECL for a VB file 3)What is the difference between LINK and XCTL 4)Write an update query/correlated subquery in DB2 5)What is the program used to run a Cobol DB2 pgm 6)Where do you mention the plan in the JCL 7)What are the steps involved in the compilation of a DB2 Cobol pgm? 8)What is timestamp mismatch 9)Have you worked on Xpeditor 10)What are the tools you have used while working with DB2 queries 11)Name some CICS tables and describe what information is stored in it 12)What are the different types of procedures? 13)Differences between instream and catalogued procs 14)Can we use PROC and PEND for a catalogued proc. If so, is it mandatory? 15)Suppose there are 4 input files in a program. If a SOC 7 error occurs, how can we figure out which one of the input files resulted in the error?
16)Suppose a program results in printing four reports for four departments respectively. The client now wants only the report file of one of the departments to be printed as the other three report files are no longer required. How can we achieve this without changing the client code?
17)Explain COND. (i) when used on JOB statement (ii) when used along with EXEC 18)How do we resolve a timestamp mismatch error 19)What are the ways in which data can be passed to the program through a JCL? 20)When data is passed to the program using PARM, how is it received in the COBOL program     21)What is a cursor? Explain its life cycle. Is it mandatory to close a cursor? 22)Write the COBOl definition for VARCHAR. Is it mandatory to use level 49? 23)Spot the error in the code..( The error was COMMIT was used along with a cursor which was not specified with the HOLD option)
24)Write the ENVIRONMENT division of a program which uses an ESDS file. Write the corresponding JCL. 25)Have you used option 3.14 in ISPF? What is it used for? 26)What are the options you have commonly used in ISPF? 27)What are the parameters commonly used while defining a VSAM CLUSTER 28)What is the program used in a COMPILE JCL 29)Have you coded a COMPILE and RUN JCL from scratch? Write a sample RUN JCL. 30)How do you decide whether to go for static linking or dynamic linking? What is the difference between the two? 31)How do you cancel a currently running job? (not purge) 32)How can we pass a return code to the JCL from the program? 33)What is referential integrity? 34)What are the parameters you specify while creating a dataset using ISPF? What do you mean by an extent?