(Paper) Latest Xchanging Fresher Job Interview Paper Pattern 6, January 2011

Latest Xchanging Fresher Job Interview Paper Pattern 6, January 2011

Company Name: Xchanging Ltd
Type: Walk-in, Job Interview

Hi.
I am posting the question papers of the main frames technical test paper. It contains only 2 rounds. 1st is technical, written and project manager round.
Totally 60 questions time 50 min. (Multiple Choice). There will be 2 type question papers. it will be asked as

1) COBOL: 10
2) JCL: 10
3) DB2: 15(little bit tough in another type)
4) CICS: 15 (easy in both type)
I am posting 1 type of question paper which I got. question be very easy.

COBOL

1) The association between a filename and corresponding file medium is done in
(a) Date-compiled paragraph, identification division
(b) Object-computer paragraph, configuration section and environment division
(c) File-control paragraph, I-O Section and environment division
(d) I-O control paragraph, I-O Section and environment division.

2) The following is Data Division entry
01 EMP-RECORD.
02 EMP-NAME.
04 FIRST-PART.
05 FIRST-NAME PIC X (10).
05 MIDDLE-NAME PIC X (10).
04 SURNAME PIC X(20).
Which one of the following gives correct information about the above record description.
a) It is correct
b) It is not correct because first-name and middle name contain the same PIC Clauses
c) Not correct because the PIC Clause is missing for the first three data items.
d) Not correct because the level number 03 is missing

3) Indicate which one of the following is correct
a) 01 level entry cannot have any picture clause
b) 01 level entries may appear in any section of the Data Division
c) 01 level entries may appear only in the File Section
d) 01 level entries may appear only in the working-storage section and that too after all 77 level entries.

4) The following combination of edit characters can appear in the same PIC clause
Except
a) -$*
b) $CR
c) $Z9
d) -$CR
e) -$Z9

5) Determine the size of the data item: -9(4). 99
a) 6
b) 7
c) 8
d) 4

6) Determine the size of the data item: SPPPP9999
a) 9
b) 5
c) 8
d) 4

7) Which one of the following is correct
a) $$Z(4).99
b) $9(4)zz.99
c) A(4)BB
d) +9(5).99CR

8) The smallest negative dollar amount with a dollar in the output that can be edited
Through the picture string -$$$$ is
a) –1000
b) –9999
c) –999
d) –100

9) To describe a record the level numbers may be chosen from
a) 01 to 77
b) 01 to 49 and 77
c) all odd numbers from 01 to 49
d) 01 to 49

10) In the following entries which is valid entry
a) 02 Amount pic “$ZZZZ9.99”
b) 02 UNDER-LINE PIC X(132) VALUE IS ALL *
c) 03 FILLER PIC X(40) VALUE “SPACES”
d) 03 A PIC X (6) VALUE 123456.

JCL

1. Maximum number of Sequential files that can be concatenated:
a. 16
b.
255
c. 3273
d.
No limit

2. Which of the following is true.
a. PROC and PEND is mandatory in Cataloged procedure.
b. PROC and PEND is mandatory in Instream procedure.
c. Both a and b
d. None of the above.

3. What is the result of execution of a job with Time parameter coded as TIME=0.
a. Job runs for Unlimited time.
b. Job runs for 24 hrs.
c. Results are unpredictable.
d. Job always abends.

4. The System return code for insufficient space coded in REGION parameter is
a. S322
b. S822
c. S80A
d. S222.

5. Time parameter is coded in both JOB statement and EXEC statement. Which of the below statement is true w.r.t to time parameter.

a. EXEC parameter overrides Job parameter
b. JOB parameter overrides the EXEC parameter
c. It depends on installation standards

6. Maximum conditions that can be coded in COND parameter is
a. 1
b. 3
c. 4
d. 8

7. Which of the following is not a valid DEFINE GDG parameter
a. OWNER
b. LIMIT
c. ALTER
d. SCRACH.

8. Maximum number of DD statements in a Job
a. 255
b. 15
c. 3273
d. No limit

9. When do we get SOC7
a. When a numeric value is moved to an alphanumeric field.
b. When a alphanumeric value is moved to a numeric field.
c. Neither a and B
d. Both a and b.

10. Select the correct statement
a. NEXT SENTENCE and CONTINUE functionally does the same.
b. Never can code a DECLARE CURSOR statement in procedure division.
c. Edited numeric characters can be included in arithmetic operations.
d. The Sub parameters of a DCB parameter are Keyword parameters.

DB2

1) What does QMF stands for ?
a) Query Manager Facility
b) Query Management Factor
c) Query Management Facility
d) None of the above

2) When DB2 is run with TSO data can be accessed from a TSO terminal in
a) Foreground
b) Batch job running in background
c) Both a & b
d) None of the above

3) When DB2 is run in IMS environment an application can access data in
a) Only DB2 database
b) Only IMS database
c) Both DB2 & IMS databases
d) None of the above

4) DB2 application programs can be written in which of the following languages?
a) COBOL
b) PL/I, FORTRAN, PASCAL, COBOL, C
c) PL/I, FORTRAN, C, COBOL, ASSEMBLER
d) COBOL, PL/I, FORTRAN, BASIC, APL2, C & ASSEMBLER

5) DB2 maintains information about the data
a) In Tables
b) In a set of tables known as DB2 catalog
c) In DB2 database
d) None of the above

6) The relational equivalent of RECORD is
a) Relation
b) Tuple
c) Attribute
d) Primary Key

7) The two types of DB2 tables are
a) Base Tables & Views
b) Base Tables & Catalogs
c) Tables & Views
d) None of the above

8) What does IRLM stands for ?
a) IMS Resource Lock Manager
b) Information Resource Lock Manager
c) Information Resource Location Manager
d) Integrity Resource Lock Manager

9) What are the valid DB2 numeric data types ?

a) NUMERIC, INTEGER, SMALLINT, FLOAT
b) LONG, SMALLINT, FLOAT
c) INTEGER, SMALLINT, DECIMAL, FLOAT
d) INTEGER, TINYINT, FLOAT, DECIMAL

10) Which utility allows the user to execute maintenance functions on a database
a) SYSOPR
b) DBMAINT
c) DBADM
d) DBCTRL

11) Failure to use null indicator variable when referencing a nullable column will give the following SQLCODE
a) +150
b) –001
c) +276
d) +305

12) If the Singleton SELECT retrieves more than one row the SQLCODE will contain the value
a) –255
b) –905
c) –001
d) –811

13) A Plan is
a) Is an executable module containing access path logic provided by the DB2 optimiser (
b) In an non executable module containing access path logic provide by the DB2 optimiser
c) Is just a module containing access path to DB2 optimiser
d) Is a module containing access path

14) A Package is
a) A single, bound DBRM
b) A Multi bound DBRM with optimised access paths
c) A Single bound DBRM with optimised access paths
d) A Multi bound DBRM

15) Package information is stored in
a) DB2 Directory
b) DB2 system tables
c) DB2 catalog tables
d) None of the above

VSAM

1. FREESPACE can be specified for which type of cluster?
a. LDS
b.
RRDS
c. ESDS
d.
KSDS

2. Default RECORD SIZE for a NONSPANNED data set is
a. (80 80)
b.
(4086 32600)
c. (100 32600)
d. (4089 4089)

3. Which of the following is/are not supported by COBOL?
a. Skip-sequential processing
b.
RBA addressing
c. Replacing existing record
d.
a and b
e. a, b and c

4. Which is a valid SHAREOPTIONS specification?
a. SHR(2 2)
b.
SHR(2 3)
c. SHR(4 1)
d.
SHR(1 2)
e. None

5. For a data set defined with SPEED, which of the following is true?
a) SPEED is effective for the initial load only.
b) SPEED is effective for all additions to the data set after initial load.
c) If the load program ABENDS, VERIFY can determine the HIGH-USED-RBA of the data set.
d) If the load program ABENDS, only those records remaining in buffers need to be added to the data set.
e) None

6. Buffer space cannot be specified in which of the following?
a. DD statement
b.
AMS DEFINE
c. Assembler program
d.
COBOL program

7. To alter a cluster to an LDS, the cluster must
a) be an ESDS
b) be NONSPANNED
c) have a CISZ of 4K
d) all the above

8. An alternate index can be defined for which cluster type?
a. KSDS and RRDS
b.
KSDS and ESDS
c. KSDS and LDS
d.
KSDS only
d. KSDS, ESDS and RRDS

9. Which of the following backs up data in CI mode?
a. REPRO only
b
. IMPORT only
c. EXPORT only
d.
Both REPRO and EXPORT

10. Which of the following is not a VSAM dataset.
a. KSDS
b.
RRDS
c. LSDS
d.
ESDS

CICS

1. Which of the following does multithreading allow?
A. several transactions that require the same program to use one copy of the program.
B. many tasks to be allocated to the terminal.
C. an audit trail of all files records from all files updated by a particular application

2. Under CICS, multitasking achieved by what method?
A. virtual paging. B. task switching. C. priority numbering, D. pseudo conversational

3. What are programs that are reusable to each task and restarted by each task said to be?
A. Command-Level. B. Transaction Dependent. C. Prioritized. D. Quasi-Reentrant.

4. What three control programs execute in a task?
A. File Control/Temp Storage Control/Trace Control. B. Task Control/Interval Control/BMS Control. C. Terminal Control/Task Control/Program Control. D. Journal Control/Dump Control/Storage Control

5.Which are the correct ways to initiate CICS tasks?
A. Automatic Task Initiation/Exec CICS Start. B. CALL Statement/Receivable Map/Send Map. C. Permanent Transaction ID/Temporary Transaction ID. D. PA Key/XCTL Statement/Interval Control Transaction ID

6. A CICS Cobol program must first be ____________ before compiled.
A. linked to CICS tables.
B.
new copied.
C.
loaded to CICS object table.
D
. translated.

7. Online files must have an entry in the:
A. resource control table.
B.
vsam master catalog.
C.
file control table.
D
. file initialization table.

8. For data fields that should not be entered or cleared you can use what characteristic?
A. Unprotected.
B.
Normal.
C.
Initial Value.
D.
Auto skip.

9. The cursor can be controlled by using a special one byte field called:
A. stopper field.
B.
jump field.
C.
shift field.
D.
tag field.

10. Name the types of maps used in CICS:
A. BMS Map/Mapset.
B.
Offline Map/Online Map.
C.
Physical Map/Symbolic map.
D.
Symbolic Map/Temp Map.

11. BMS uses _______________ to load the appropriate physical map into main storage.

A. load library.
B
. program control.
C.
mapset.
D.
temp storage.

12. With BMS, two (2) major application benefits are given to the programmer. They are:

A. Physical Map/Assembler Macro.
B
. Symbolic Maps/Mapsets.
C.
Device and Data independence. D. Mapsets/Coding Rules.

13. Which answer describes a rule for coding a BMS Macro?

A. Label is from one (1) to seven (7) characters long with the first character being alphabetic.
B.
Getmain command should be coded first.
C.
Op-code is separated from the label by an asterisk.
D.
Operands start in column 20 separated by commas.

14. The second BMS macro (OP Code DFHMDI) has which function?
A. Specifies length of the field.
B.
Defines a field with a map and its position.
C.
States purpose of field - Input, Output or both.
D.
Contains size parameters of Map.

15. If the program uses other keys besides "enter" to control logic, a copy of ___________ should be used in working storage of program.
A. ebaid.
B.
dfhaid.
C.
dfhbmsca.
D
. dfheivar.

ANSWER:

COBOL JCL DB2 VSAM KEY CICS KEY
Question No. Answer Question No. Answer Question No. Answer Question No. Answer Question No. Answer
1 c 1 b 1 c 1 d 1 a
2 a 2 b 2 c 2 d 2 d
3 b 3 c 3 c 3 e 3 d
4 d 4 b 4 d 4 b 4 c
5 c 5 b 5 b 5 a 5 d
6 d 6 d 6 b 6 d 6 d
7 c 7 c 7 a 7 d 7 c
8 c 8 c 8 a 8 b 8 d
9 d 9 b 9 c 9 c 9 a
10 c 10 d 10 b 10 c 10 c
11   11 d 11 b 11 b
12   12 d 12 c 12 c
13   13 a 13 a 13 a
14   14 c 14 d 14 d
15   15 c 15 b 15 b

This was the question paper asked on November, 2010 mainframes interview and also in January 2011 walk-in.
All the best.

Exam/Interview Date : 06, Jan 2011
No of Rounds: Aptitude Test, Client/Manager Interview
Location: Chennai
Contributor Name: Dexter