0

mainframe Online Quiz - 142

Description: mainframe Online Quiz - 142
Number of Questions: 20
Created by:
Tags: mainframe
Attempted 0/20 Correct 0 Score 0

The option used to browse DB2 Tables from the first menu of File-Aid DB2 is

  1. 0

  2. 1

  3. 2

  4. 3


Correct Option: B

Which of the following is not in the File-Aid DB2 league of products

  1. Platinum

  2. Softech

  3. SPUFI

  4. Quartz


Correct Option: D

Which product among the following has the ‘Interactive Edit’ feature

  1. Platinum

  2. File-Aid DB2

  3. SPUFI

  4. QMF


Correct Option: B

The option 3.3 from Main Menu of File-Aid DB2 can be used for

  1. Copy Rows between tables

  2. Object List Processing

  3. SQL Command Manager

  4. Display, Grant or Revoke DB2 Privileges


Correct Option: A

File aid is used to browse?

  1. VSAM File

  2. Sequential file

  3. Sequential and VSAM

  4. None


Correct Option: C

Different formats of accessing files

  1. VFMT

  2. FMT

  3. UNFMT

  4. All of the above


Correct Option: D

VSAM files can be created through file aid?

  1. True

  2. False


Correct Option: B

Option 3.5 is meant for

  1. VSAM Utility

  2. Dataset Utility

  3. Copy Utility

  4. Interactive Utility


Correct Option: A

Alternate index can be created through file aid?

  1. True

  2. False


Correct Option: B

Which option is used for the viewing copybook layout?

  1. Option 1

  2. Option 3

  3. Option 8

  4. Option 10


Correct Option: C

Comparison of file is possible in file aid?

  1. True

  2. False


Correct Option: B

Masking of members possible in file aid?

  1. True

  2. False


Correct Option: B

Records can be browsed based with the selection criteria?

  1. True

  2. False


Correct Option: B

For which format “Record Layout” needed?

  1. VFMT & FMT

  2. Char & UNFMT

  3. Char

  4. UNFMT


Correct Option: A

Function used to find the record count through file aid?

  1. TALLY

  2. COUNT

  3. TOTAL

  4. AVERAGE


Correct Option: A

Different types of selection criteria for viewing the records:

  1. FORMATED

  2. UNFORMATED

  3. Both a & b

  4. None of the above


Correct Option: C

GDG’s can be created through file aid?

  1. True

  2. False


Correct Option: B

In the VFMT what are the parameters can be viewed

  1. Position of the field

  2. Characteristics like alphanumeric or numeric

  3. Field number

  4. All of the above


Correct Option: D

File Aid option can be processed in batch mode?

  1. True

  2. False


Correct Option: B
- Hide questions