ALIT TEST-1


DB2

1. Is it required to run any other utility after running REORG utility? If so, give reasons.

2. Explain Denormalization with example.

3. Explain Impedance Mismatch. How would you overcome the same?

4. Explain different Data types available in DB2

JCL

1. How are datasets concatenated? Explain with Example.

2. What are the ‘normal’ dispositions of the DISP parameter.

3. When should DISP = MOD used.

4. What is the difference between JOBLIB and STEPLIB statements

CICS

1. What is the difference between EXEC CICS XCTL and an EXEC CICS START command?

2. How can you start a CICS transaction other than keying in the Transaction ID on the terminal?

3. What CICS command is used to obtain the user logon-id?

4. What is the usage of RESP Option in a CICS command?

COBOL

1. Write Record Description entries for the following

Transaction Record

Invoice

Number

Location

Product Description

Ware

House

City

Job Lot

No. of Items

Item Name

Size

Model

2. What if anything is wrong with the following routines. Correct all errors.

PERFORM 300-ALIT-PARA VARYING A FROM 1 BY 1 UNTIL A> 20

:

:

:

300-ALIT-PARA

ADD C TO B

ADD 1 TO A

3. If PERFORM UNTIL END-OF-FILE = ‘YES’ . . . . . . . . END-PERFORM is coded in the main module. What will be the first instructon following the PERFORM.

4. Write a Single Statement to execute 500-ALIT-PARA if A is between 2 and 10 exclusive of end points using an EVALUATE statement.

ALIT TEST-2

DB2

1. Explain the functions of BIND in Program preparation.

2. What are the differences of DB2 Indexes. Explain briefly.

3. Explain DB2 catalogs with examples.

4. Explain Static and Dynamic SQL.

JCL

1. Write a JCL to Create a VSAM dataset.

2. How is a Symbolic Parameter coded?

3. How is dataset is passed from one step to another.

4. How and where is LASTCC and MAXCC used in JCL’s.

CICS

1. Suppose that an application Program uses the HANDLE AID ENTER(PARA1) and HANDLE CONDITION ERROR(PARA2) commands, if the Program issued a RECEIVE MAP and a MAPFAIL condition occurred, which process will take control , PARA1 or PARA2?

2. Write some of the informations available in the EIB area.

3. Explain different Cursor positioning techniques?

4. What are the different macros used in map creation?

COBOL

1. What if anything is wrong with the following routines. Correct all errors.

PERFORM 300-ALIT-PARA 8 TIMES.

:

:

:

300-ALIT-PARA.

IF A= B GO TO 400-ALIT-PARA

ADD A TO B.

400-ALIT-PARA.

ADD 5 TO B.

2. What if anything is wrong with the following. Correct all errors.

IF A < a="21" a="5"> 5 PERFORM 100-ALIT-PARA

3. Using COMPUTE stmt. Find –

Total wages = rate * 40 + (1.5 * rate * overtime hours)

Two fields are supplied RATE and HRS-WORKED. Overtime hrs worked is calculated in excess of 40 hrs (assume everyone works at least 40 hrs.)

4. Assume the following statements are executed

MOVE HIGH-VALUES TO PART-NO OF TRANS-REC

Suppose the following is then executed

IF PART-NO OF MASTER-REC <>

PERFORM 500-ALIT

ELSE

PERFORM 600-ALIT

END-IF.

Which routine is going to be executed after this.

ALIT TEST-3

DB2

1. Explain the usage of the following BIND parameters

a) REPLACE

b) REBIND

2. Is it possible to improve performance with the use of Clustering Index? Explain.

3. Explain the different DELETE Rules.

4. What is an ALIAS and SYNONYM and differences between them.

JCL

1. What return code is issued if a job or job step exceeded the time limit?

2. What is the default for the TIME parameter if it is not coded on the EXEC statement?

3. What does parameter MSGLEVEL on the JOB statement mean and what is the advantage of using it?

4. What is the purpose of the JOB statement?

CICS

1. What would cause a MAPFAIL when issuing a RECEIVE MAP command?

2. What CICS command does the application have to issue to update an existing record in a TSQ?

3. What are the differences between TSQ and TDQ?

4. In what way can the application programmer use the information - EIBCALEN=0 for effective programming?

COBOL

1. What if anything is wrong with the following routines. Correct all errors.

PERFORM 300-ALIT-PARA UNTIL CNTR = 8.

:

:

:

300-ALIT-PARA.

ADD A TO B.

ADD 1 TO CNTR

IF CNTR = 8

STOP RUN.

2. What if anything is wrong with the following routines. Correct all errors.

IF A IS NOT EQUAL TO 3 OR

A IS NOT EQUAL TO 4

PERFORM 500-ALIT-PARA

END-IF.

3. Write a Single Statement to execute 500-ALIT-PARA if A is between 2 and 10 exclusive of end points using an IF statement.

4. Code a simple SORT to read a file called IN-FILE , sort it into ascending name sequence

(S-NAME). Create an out file called OUT-FILE.

ALIT TEST-4

DB2

1. How can you keep the CURSOR open even after giving COMMIT.

2. What is READ-ONLY cursor?

3. What are the COLUMN functions available in SQL?

4. What is wrong with the following query

EXEC SQL

SELECT COL1, COL2,AVG(COL3),COL4

FROM TABALIT

GROUP BY COL1,COL2,COL3

END-EXEC.

JCL

1. Use the PROCedure below and code the invoking JCL to:

Step1 add a REGION of 256K

Step2 remove the ACCT parameter

Step3 add a PARM parameter of January

//ABCPROC PROC UN=3380

//STEP1 EXEC PGM=SORT

//SORTIN DD DSN=TIMERCDS,DISP=SHR

//SORTOUT DD DSN=TRANS,DISP=(,PASS,DELETE),

// SPACE=(TRK,(2,1)),UNIT=&UN,VOL=SER=EDPAK2,

// DCB=(LRECL=80,BLKSIZE=8000,RECFM=FB)

//SYSOUT DD SYSOUT=*

//SYSIN DD DSN=TRANS.SORT.CNTL,DISP=SHR

//STEP2 EXEC PGM=PAYROLL,ACCT=1492

//PAYIN DD DSN=MSTRN,DISP=SHR

//PAYTRANS DD DSN=TRANS,DISP=SHR

//REPORT DD SYSOUT=*

//STEP3 EXEC PGM=PAYACCT

//MSTR DD DSN=MSTROUT,DISP=SHR

//REPORT1 DD SYSOUT=*

//REPORT2 DD SYSOUT=*

2. Which system completion code is issued when a program module cannot be found

3. How is a new GDG coded

4. Explain difference between Cataloged and Instream procedures

CICS

1. What is a residential program?

2. Explain difference between DATAONLY and MAPONLY options in EXEC CICS SEND MAP command.

3. How do you suspend and reactivate HANDLE Conditions before and after calling Sub-routines?

4. How can you view the contents of a TDQ or TSQ?

COBOL

1. What are the different ways to sort a file using SORT statement.

2. In the following example how many times 100-ALIT-PARA is going to execute

INITIALIZE WS-VARC

PERFORM 100-ALIT-PARA UNTIL WS-VARX = 10.

:

:

:

100-ALIT-PARA.

MOVE 1 TO WS-CNTR.

MOVE WS-VARA TO WS-VARB.

:

:

:

COMPUTE WS-VARC = WS-VARC + 2.

MOVE WS-VARC TO WS-VARX.

3. What if anything is wrong with the following routines. Correct all errors.

IF A = B OR IF A = C

PERFORM 100-ALIT-PARA

END-IF.

4. Which SECTION will be there in the called Program in which data to be passed to the calling Program.

ALIT TEST-5

DB2

1. Which Tablespace favours I/O Parallelism? Briefly explain the same with example.

2. What are the different physical and logical DB2 objects?

3. Explain the difference between CHAR and LONGVARCHAR .

4. When is WHERE CURRENT OF clause used?

JCL

1. Use the PROCedure below and code the invoking JCL to:

Step1 catalog dataset TRANS and put it in a 3390 Disk EDPAK8

Remove BLKSIZE from Transfile

Step2 remove the ACCT parameter

Step3 add a PARM parameter of January

//ABCPROC PROC UN=3380

//STEP1 EXEC PGM=SORT

//SORTIN DD DSN=TIMERCDS,DISP=SHR

//SORTOUT DD DSN=TRANS,DISP=(,PASS,DELETE),

// SPACE=(TRK,(2,1)),UNIT=&UN,VOL=SER=EDPAK2,

// DCB=(LRECL=80,BLKSIZE=8000,RECFM=FB)

//SYSOUT DD SYSOUT=*

//SYSIN DD DSN=TRANS.SORT.CNTL,DISP=SHR

//STEP2 EXEC PGM=PAYROLL,ACCT=1492

//PAYIN DD DSN=MSTRN,DISP=SHR

//PAYTRANS DD DSN=TRANS,DISP=SHR

//REPORT DD SYSOUT=*

//STEP3 EXEC PGM=PAYACCT

//MSTR DD DSN=MSTROUT,DISP=SHR

//REPORT1 DD SYSOUT=*

//REPORT2 DD SYSOUT=*

2. What are the ‘abnormal’ disposition of the DISP parameter?

3. Name a few Utilities with brief description of each.

4. How and when do you use a RESTART Option?

CICS

1. What happens to the resources allocated in the case of XCTL and LINK commands.

2. Why do we use a NOHANDLE option in a CICS command?

3. How many conditions can you include in a single HANDLE CONDITION command?

4. What are the functions of CICS?

COBOL

1. The PROCEDURE DIVISON entry for the called Program include which clause.

2. What if anything is wrong with the following routines. Correct all errors.

WORKING-STORAGE SECTION.

01 A PIC 9(04).

01 B.

02 C PIC 9(02).

02 D PIC 9(02).

01 E PIC 9(04).

:

:

:

PROCEDURE DIVISION.

:

:

:

MOVE 02 TO A.

MOVE 03 TO D.

COMPUTE E = A + B.

3. What if anything is wrong with the following routines. Correct all errors.

IF B = 3 OR 4

PERFORM 100-ALIT-PARA.

4. What is the last statement in the called Program?

No comments: