The file will be created and will be opened for reading and writing

The open fails and error occurs

File will be created and opened for writing only

The file will be created and opened for reading only

Elementary level

For condition names

Initialize

Renames

The records will be accessed one after the other in order of primary key

The file will be accessed one record at a time and for each access an exact value for the primary key will be specified

Both 1 and 2

None of the above

51

52

53

54

Area C

Area AB

Identification area

Modification area

Dataset is created if not available

Dataset will deleted on abnormal termination

Dataset will not be deleted on abnormal termination

job will abend if the data is not available

DSN=*

DSN=##TEMP

DSN=&&TEMP

By not specifying any DSNAME

Execute next step even if the current step terminates abnormally.

Execute this step even if any of the previous steps, terminated abnormally.

Execute next step even if the current step terminates normally.

Execute this step even if any of the previous steps, terminated normally.

Execute this step only if any of the previous steps terminates normally

Execute this step only if any of the previous steps terminates abnormally

Execute next step only this step terminates abnormally

Execute next step only this step terminates normally

STEPLIB will be ignored

JOBLIB will be ignored

Both are referred

JOBLIB overrides the STEPLIB

Records will be appended at the end

Records will be overwritten

Dataset will be deleted and records will be written by creating a new file

Job will abend

16

255

256

No limit

TIMESTAMP

VARCHAR

TIME

CLOB

Primary Key

Check constraint

Foreign Key

Update trigger

NEWTAB would have the same column names, attributes and referntial integrity as TAB.

NEWTAB would have the same column names and attributes as TAB.

NEWTAB would have the same column names, attributes, indexes and constraints as TAB.

NEWTAB would have the same column names, attributes and data as TAB.

The unit of work moves to pending status

The unit of work moves to CHECK_PENDING

The unit of work is rolled back

The unit of work remains active

ORDER BY 2,1

ORDER BY 2 ASC, 1 ASC

ORDER BY 1,2

ORDER BY 1 ASC, 2 ASC

ORDER BY 2,1

ORDER BY 2 ASC, 1 ASC

ORDER BY 1,2

ORDER BY 1 ASC, 2 ASC

ORDER BY 2,1

ORDER BY 2 ASC, 1 ASC

ORDER BY 1,2

ORDER BY 1 ASC, 2 ASC

True

False