Tag: mainframe

Questions Related to mainframe

  1. A. SELECT * FROM DB2P.SYSIBM.SYSPLANDEP WHERE BCREATOR = 'DBNAME' AND BTYPE = 'T' ORDER BY BNAME, DNAME

  2. B. SELECT BNAME, BQUALIFIER, BTYPE, DCOLLID, DNAME FROM DB2P.SYSIBM.SYSPACKDEP WHERE BQUALIFIER = 'DATABASE NAME' AND BTYPE = 'T' ORDER BY BNAME, DNAME

  3. C. (A) or (B)

  4. D. Neither (A) nor (B)


Correct Option: C

What is the use of DB2 utility RUNSTAT

  1. A. To take the copy of table

  2. B. To load the table

  3. C. To get the structure of the table

  4. D. NONE


Correct Option: C
  1. (A) Input

  2. (B) I-O

  3. (C) Output

  4. (D) A or B or C


Correct Option: B

How to check the success of your binding job

  1. A. Check the bind plan job run success in JMR

  2. B. Checking in the table SYSIBM.SYSPLAN

  3. C. (A) and (B)

  4. D. None


Correct Option: C
  1. A. REPAIR

  2. B. UPDATE

  3. C. LOAD

  4. D. IMAGCOPY


Correct Option: B
  1. A. With Update

  2. B. Updating

  3. C. To Update

  4. D. For Update Of


Correct Option: D
  1. (A) SELECT (File Name) [OPTIONAL] ASSIGN (FILE)

  2. (B) SELECT (File Name) [ALTERNATE] ASSIGN (FILE)

  3. (C) SELECT (File Name) [ELECTIVE] ASSIGN (FILE)

  4. (D) SELECT (File Name) [DISCRETIONARY] ASSIGN (FILE)


Correct Option: A
  1. (A) Start

  2. (B) Rewrite

  3. (C) Delete

  4. (D) Update.


Correct Option: D