Tag: mainframe

Questions Related to mainframe

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

  1. Buffer pools

  2. Tablespaces

  3. Tables

  4. Rows

  5. Columns

Show answer
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?

technology mainframe

  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

Show answer
Correct Option: B

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

technology mainframe

  1. Add a new column

  2. Drop a check constraint

  3. Change a columns name

  4. Change the length of VARCHAR column

Show answer
Correct Option: C

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

technology mainframe

  1. ?

  2. %

  3. +

  4. \

Show answer
Correct Option: B

which one of the following is not IBM mainframe utility programs

technology mainframe

  1. IEBPTPCH

  2. IEHINITT

  3. IEBISAM

  4. IEBVSAM

Show answer
Correct Option: D

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

  1. IEHINITT

  2. ICKDSF

  3. IDCAMS

  4. IEHLIST

Show answer
Correct Option: C

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

technology mainframe

  1. creates

  2. compares

  3. copies

  4. none of the above

Show answer
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
technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

IEBGENER can't be used for

technology mainframe

  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

Show answer
Correct Option: D

IEBIMAGE manipulates character set definitions for the IBM 3800 printing subsystem

technology mainframe

  1. True

  2. False

Show answer
Correct Option: A