Tag: mainframe

Questions Related to mainframe

The parameter used with the REPORT statement that can be used to sort the report based on a field
technology mainframe

  1. SORT

  2. SEQUENCE

  3. CONTROL

  4. None of the above

Show answer
Correct Option: B

The I/O statements that are used for random access
technology mainframe

  1. READ and WRITE

  2. GET and PUT

  3. Both a and b

  4. None of the above

Show answer
Correct Option: A

Any DB2 select query which is not part of the JOB INPUT SQL statement should be used as a cursor
technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

The parameter LINESIZE used with the REPORT statement should have the length
technology mainframe

  1. Equal to lrecl of the file

  2. Greater than lrecl of the file

  3. Equal to lrecl – 1

  4. Equal to lrecl + 1

Show answer
Correct Option: C

While comparing files using MATCHED keyword, only one key field can be used
technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

In case of controlled processing, the JOB statement should be defined as
technology mainframe

  1. JOB INPUT SQL

  2. JOB INPUT NULL

  3. JOB INPUT filename

  4. None of the above

Show answer
Correct Option: B

Which command should be used to disable the time out period?

technology mainframe

  1. @@TOUT D

  2. @@TOUT E

  3. @@TOUT F

  4. DISABLING TIME OUT IS NOT POSSIBLE

Show answer
Correct Option: A

IDENTIFY WHICH IS NOT A VALID COMMAND
technology mainframe

  1. @FREE,D

  2. @FREE,I

  3. @FREEM

  4. @FREEALL

  5. NONE OF THE ABOVE

Show answer
Correct Option: E

@DELETE,C IS A VALID DELETE STATEMENT

technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

WHICH OF THE BELOW IS A VALID STATEMENT

technology mainframe

  1. @PRT,T

  2. @PRT,P

  3. @PRT,I

  4. @PRT,F

  5. ALL THE ABOVE

Show answer
Correct Option: E