0

mainframe Online Quiz - 21

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

In the below code, what will happen if first IF is satisfied. IF A=B NEXT SENTENCE ELSE IF C=D Move 20 to C End-If Move 40 to D End-If. Move A to B. Move C to D.

  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

Drop dependencies

  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

SQL Retun code -181

  1. Bind issue

  2. String representation of invalid date value

  3. Both A and B

  4. No Null indicator


Correct Option: B

SQL Return code -204

  1. Row not found

  2. Column not found

  3. Both A and B

  4. Table not found


Correct Option: D

SQL Return code -501

  1. With Hold option missing

  2. Cursor not open

  3. Cursor not close

  4. BOTH B and C


Correct Option: B

SQL Return Code -502

  1. Cursor not closed

  2. Cursor not opened

  3. Cursor already open

  4. ALL the ABOVE


Correct Option: C

SQL Return Code -503

  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
  1. Column value is not valid

  2. Duplicate Value

  3. Row not found

  4. BOTH A and C


Correct Option: B
  1. Row not found

  2. Privilege issue

  3. Bind issuie

  4. Insert value is missing for a Column


Correct Option: D
  1. Column not found

  2. Duplicate value

  3. Bind issue

  4. Invalid time and date


Correct Option: C
  1. Fetching only Zero Rows

  2. Fetching more than one row.

  3. Table not found

  4. BOTH A and B


Correct Option: B

Sql Return code -818

  1. Bind issue

  2. No Null indicator found

  3. Invalid Date or Time

  4. Timestamp mismatch between Load and BIND


Correct Option: D

Sql Return code -904

  1. RESOURCE UNAVAILABLE

  2. TABLE NOT FOUND

  3. PLAN NOT FOUND

  4. ALL THE ABOVE


Correct Option: A
  1. BOTH B and C

  2. Privilege issue

  3. Dead Lock

  4. No row found


Correct Option: C

Sql Return code -913

  1. Access not given

  2. Plan not found

  3. Deadlock and Timeout

  4. Authorization isse


Correct Option: C
  1. Dead Loack

  2. Time out

  3. BOTH A and D

  4. Authorization failure


Correct Option: D
  1. Colum not found

  2. Rows found

  3. No Row found

  4. Both A and B


Correct Option: C
- Hide questions