Tag: mainframe

Questions Related to mainframe

  1. (A) Control Starts after the line where, FULLSTOP is present

  2. (B) Control Starts after the line where, First END-IF is present

  3. (C) Control starts after the line where, its respective END-IF is present

  4. (D) None of the above.


Correct Option: A
  1. A. STORAGE GROUP -->DATABASE --> TABLESPACE -->TABLE--> VIEW

  2. B.TABLESPACE -> DATABASE-> TABLE-> VIEW--> STORAGE GROUP

  3. C. DATABASE --> TABLE --> TABLE SPACE --> VIEW-->STORAGE GROUP

  4. D. VIEW --> TABLE --> DATABASE--> TABLE SPACE --> STORAGE GROUP


Correct Option: A
  1. Foreign Key constraint

  2. Bind Issue

  3. Invalid date or Time

  4. Invalid string


Correct Option: C
  1. Bind issue

  2. String representation of invalid date value

  3. Both A and B

  4. No Null indicator


Correct Option: B
  1. Row not found

  2. Column not found

  3. Both A and B

  4. Table not found


Correct Option: D
  1. With Hold option missing

  2. Cursor not open

  3. Cursor not close

  4. BOTH B and C


Correct Option: B
  1. Cursor not closed

  2. Cursor not opened

  3. Cursor already open

  4. ALL the ABOVE


Correct Option: C
  1. Invalid column values

  2. Invalid date or time

  3. Update issue. Update clause missing in the select statement of the cursor

  4. BOTH A and B


Correct Option: C
  1. Foreign Key constraint

  2. Bind issue

  3. Authorization iussue

  4. BOTH A and C


Correct Option: A

SQL Return code -532

  1. Restriction in deletion

  2. Foreign key constraint

  3. Invalid update

  4. Both A and B


Correct Option: A