Saturday, June 7, 2008

-paper 21

1) I give a jcl code with

Programmer name: smith

Jobname:ABC

Jobclass=c

Message class = a

All messages are to be displaced code it in a JCL.



A) //ABC,smith,class=c,message class=a,message level=(2,1)

B) //ABC,smith,class=c,message class=a,message level =(!,1)

C) //ABC,smith,class=c,message class=a,message level=(0,1)

D) none of these.

2) for a cobol program



Move 5 to work-sd.

A statement which says that the value of work-st is 0.

perform Para1.

……………

Para1.

Add 3 to work-sd

Add 2 to work-st

If work-st <11 go to main-para.

………………



go to para1.



Wat wud b the value of work-sd?

a) 15

b) 18

c) 10

d) none



3) given 2 tables T1 and T2.



T1 T2

A 1

B 2

3

u make a query



SELECT * FROM T1,T2.

Wat is the no: of rows that are fetched frm this query?

a) 4

b) 5

c) 6

d) 9

4) wat is the full form of RACF?
5) who is the data base manager of db2?

a) buffer register

b) runtime suprivisor

c) DBRM

d) None



5)u have a file with DISP=SHR, when u open the file in output mode

a) the records get appended

b) the records gets overwritten

c) the job abbends

d) none of these



6) u open a file with disp= MOD, when u open the file in output mode

(same options as the above question)

7) to exclude some records while sorting which parameter do we use?

a) OMIT

b) EXCLUDE

c) ….d)….



8)when u insert into db2 with cics, it works as

a) foreground

b) a job working in background

c) ..

d) …..



9)u have a dataset TIME.WORK.OCT88, u want to concatenate other datasets

like TIME.WORK.JUL88, TIME.WORK.APR88, TIME.WORK.MAY88. how do u do that?



a)//DDname DD DSN = TIME.WORK.OCT88, DISP = SHR

DD DSN = TIME.WORK.JUL88, DISP = SHR

DD DSN = TIME.WORK.APR88, DISP = SHR

DD DSN = TIME.WORK.MAY88, DISP = SHR

b)//DDname DD DSN = TIME.WORK.JUL88, DISP = SHR


DD DSN = TIME.WORK.OCT88, DISP = SHR

DD DSN = TIME.WORK.APR88, DISP = SHR

DD DSN = TIME.WORK.MAY88, DISP = SHR

c)//DDname DD DSN = TIME.WORK.APR88, DISP = SHR

DD DSN = TIME.WORK.JUL88, DISP = SHR

DD DSN = TIME.WORK.MAY88, DISP = SHR

DD DSN = TIME.WORK.OCT88, DISP = SHR

e) none of these



10) when db2 entries are made while working in cics, the enteries

should be made in

a) TCT

b) PCT

c) DCT

d) RCT



11) find the odd one out

a) KSDS

b) RRDS

c) LDS

d) PDS



12) full form of VTOC

13) question based on SKIP and COUNT parameter

No comments: