0

mainframe Online Quiz - 111

Description: mainframe Online Quiz - 111
Number of Questions: 20
Created by:
Tags: mainframe
Attempted 0/20 Correct 0 Score 0
  1. The file will be created and will be opened for reading and writing

  2. The open fails and error occurs

  3. File will be created and opened for writing only

  4. The file will be created and opened for reading only


Correct Option: B
  1. Elementary level

  2. For condition names

  3. Initialize

  4. Renames


Correct Option: B
  1. The records will be accessed one after the other in order of primary key

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

  3. Both 1 and 2

  4. None of the above


Correct Option: C
  1. Area C

  2. Area AB

  3. Identification area

  4. Modification area


Correct Option: C
  1. Dataset is created if not available

  2. Dataset will deleted on abnormal termination

  3. Dataset will not be deleted on abnormal termination

  4. job will abend if the data is not available


Correct Option: A,C
  1. DSN=*

  2. DSN=##TEMP

  3. DSN=&&TEMP

  4. By not specifying any DSNAME


Correct Option: C,D
  1. Execute next step even if the current step terminates abnormally.

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

  3. Execute next step even if the current step terminates normally.

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


Correct Option: B
  1. Execute this step only if any of the previous steps terminates normally

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

  3. Execute next step only this step terminates abnormally

  4. Execute next step only this step terminates normally


Correct Option: B
  1. STEPLIB will be ignored

  2. JOBLIB will be ignored

  3. Both are referred

  4. JOBLIB overrides the STEPLIB


Correct Option: B
  1. Records will be appended at the end

  2. Records will be overwritten

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

  4. Job will abend


Correct Option: A
  1. NEWTAB would have the same column names, attributes and referntial integrity as TAB.

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

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

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


Correct Option: B
  1. The unit of work moves to pending status

  2. The unit of work moves to CHECK_PENDING

  3. The unit of work is rolled back

  4. The unit of work remains active


Correct Option: C

Given the table: COUNTRY NAME CITIES PERSON Argentina 30 1 Cuba 20 2 Canada 10 2 Germany 40 1 Given the statement: SELECT name,cities FROM country Which of the following clauses must be added to the statement for it to return rows sorted by NAME ascending and then sorted by CITIES ascending?

  1. ORDER BY 2,1

  2. ORDER BY 2 ASC, 1 ASC

  3. ORDER BY 1,2

  4. ORDER BY 1 ASC, 2 ASC


Correct Option: C,D
- Hide questions