COBOL Exam Flashcards

1
Q

Which utility is used to sort files?

A

DFSORT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What 3 things do you specify for DFSORT?

A
  1. File to be sorted (SORTIN)
  2. File for the output (SORTOUT)
  3. Specify fields to sort (SORT FIELDS)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What 4 criteria are specified for the sort fields in DFSORT?

A
  1. Start Position
  2. Length of field
  3. Type of data (CH)
  4. Ascending/Descending
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which type of files were the predecessors to relational databases?

A

Indexed Files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is VSAM?

A

Virtual Storage Access Method

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What 3 types of files are created in VSAM?

A
  1. ESDS (Sequential)
  2. RRDS (Relative Record Data Set)
  3. KSDS (Key Sequenced Data Set)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is another word for a data set in VSAM?

A

Cluster

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the 2 components of a KSDS?

A
  1. Data
  2. Index
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a control interval?

A

Unit of data that VSAM transfers between disc storage and virtual storage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How many records are stored in one control interval?

A

1 or more

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are control intervals stored in?

A

Control Areas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is AMS?

A

Access Method Services

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the continuation character in JCL?

A

’ - ‘

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What keyword is used for COBOL’s version of a SWITCH statement?

A

EVALUATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

When doing a READ, what is file status 23?

A

Invalid key condition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What 2 functions are used to update a record?

A
  1. READ
  2. REWRITE
17
Q

What is the AIX defining?

A

Alternate Key

18
Q

How do you pass variables by reference to a sub program?

A

USING

19
Q

How do you pass variables by value to a sub program?

A

USING BY CONTENT

20
Q

What is the default way that COBOL shares variables between programs?

A

By Reference

21
Q

What is the LINKAGE SECTION?

A

Handles the variables passed from one program to another

22
Q

What number is used to denote the variables in the LINKAGE section?

A

77

23
Q

What does SPUFI stand for?

A

SQL Processing Using File Input

24
Q

What code is used for VARCHAR fields?

A

49

25
Q

What is the SQLDA?

A

SQL Dynamic Area

26
Q

What is the SQLCA?

A

SQL Communications Area

27
Q

What is an SQLCODE of 100?

A

End of Results Table (EOF)

28
Q

What does the pre-compile do with DB2?

A

Converts EXEC SQL commands to COBOL CALLs and creates a DBRM

29
Q

What is a DBRM?

A

Database Request Module