COBOL Exam Flashcards

(29 cards)

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?

17
Q

What is the AIX defining?

A

Alternate Key

18
Q

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

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?

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?

23
Q

What does SPUFI stand for?

A

SQL Processing Using File Input

24
Q

What code is used for VARCHAR fields?

25
What is the SQLDA?
SQL Dynamic Area
26
What is the SQLCA?
SQL Communications Area
27
What is an SQLCODE of 100?
End of Results Table (EOF)
28
What does the pre-compile do with DB2?
Converts EXEC SQL commands to COBOL CALLs and creates a DBRM
29
What is a DBRM?
Database Request Module