0

mainframe Online Quiz - 126

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

Which is the correct ASCII collating sequence?

  1. spaces, special characters, 0-9, A-Z, a-z

  2. spaces, a-z, A-Z, 0-9, special character

  3. a-z, A-Z, 0-9, spaces, special characters

  4. 0-9, special characters, spaces, a-z, A-Z


Correct Option: A

When defining a file layout it is placed in the file section of the data division. Each record begins with an "01", a space, and the record name. Fields within a record traditionally began with 05?

  1. This is an alternate name for the 05 name.

  2. This is a breakdown of the 05 field.

  3. This is another format for the field.

  4. All of these answers.


Correct Option: B

Condition names are names associated with a field that take on a true/false status depending on whether their value is equal to the field value. They are indicated by a level number of what?

  1. 5

  2. 66

  3. 88

  4. 77


Correct Option: C

Which of the following isolation levels will lock all rows scanned to build a result data set?

  1. Uncommitted Read

  2. Cursor Stability

  3. Read Stability

  4. Repeatable Read


Correct Option: D

For which two of the following database object can lock not be acquired ?

  1. Buffer pools

  2. Tablespaces

  3. Tables

  4. Rows

  5. Columns


Correct Option: A,E

A user with the SYSADM authority issue the following statement : GRANT ALL PRIVILEGES ON TABLE payroll.employee TO user1 WITH GRANT OPTION Which of the following statement is USER1 authorized to execute?

  1. GRANT CONROL ON TABLE payroll.employee TO user2

  2. GRANT UPDATE ON TABLE payroll.employee TO user2

  3. GRANT CREATE_EXTERNAL_ROUTINE ON TABLE payroll.employee TO user2

  4. GRANT LOAD ON TABLE payroll.employee TO user2


Correct Option: B

Which of the following can NOT be done using the ALTER TABLE statement

  1. Add a new column

  2. Drop a check constraint

  3. Change a columns name

  4. Change the length of VARCHAR column


Correct Option: C

Which of the following is a valid wildcard character in a like clause of a SELECT statement?

  1. ?

  2. %

  3. +

  4. \


Correct Option: B

which one of the following is not IBM mainframe utility programs

  1. IEBPTPCH

  2. IEHINITT

  3. IEBISAM

  4. IEBVSAM


Correct Option: D

which one of the following is used for generates and modifies VSAM and Non-VSAM datasets

  1. IEHINITT

  2. ICKDSF

  3. IDCAMS

  4. IEHLIST


Correct Option: C

Fill in the blank: IEBCOMPR _________ records in sequential or partitioned data sets

  1. creates

  2. compares

  3. copies

  4. none of the above


Correct Option: B

IEBCOPY copies, compresses and merges partitioned data sets. It can also select or exclude specified members during the copy operation, and rename or replace members

  1. True

  2. False


Correct Option: A

IEBGENER can't be used for

  1. Printing a sequential data set or a member of a PDS

  2. Creating partitioned output data set from sequential input data set

  3. Changing the physical block size or logical record length of a sequential data set.

  4. Copy and print ISAM datasets


Correct Option: D

IEBIMAGE manipulates character set definitions for the IBM 3800 printing subsystem

  1. True

  2. False


Correct Option: A

which one of the following task, IEBPTPCH can perform

  1. Printing or punching selected PDS members

  2. Unloading, loading, coping and printing of ISAM datasets

  3. Creating and updating libraries

  4. Changing the organization of a data set from sequential to partitioned or from partitioned to sequential


Correct Option: A

IEFBR14 is a dummy program, normally inserted to JCL when the only desired action is allocation or deletion of datasets.

  1. True

  2. False


Correct Option: A

which one of the following is not the System utility

  1. IEHINITT

  2. IEHLIST

  3. DFSMS

  4. ICKDSF


Correct Option: C

What is the Line command Used to Change a line in Mainframes from any case to Lower case

  1. MC

  2. LC

  3. BC

  4. AC


Correct Option: B

After hiding all the line how do you display the First line in a Mainframe program

  1. Show First

  2. First Only

  3. F

  4. L


Correct Option: C

What is the TSO command to display the Last 30 used datasets

  1. TSO DS

  2. dslist

  3. Display ds

  4. All of the above


Correct Option: B
- Hide questions