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
  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
  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

Which of the following is not DATABASE privilege?

  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