mainframe Online Quiz - 21
Description: mainframe Online Quiz - 21 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: mainframe |
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.
-
(A) Control Starts after the line where, FULLSTOP is present
-
(B) Control Starts after the line where, First END-IF is present
-
(C) Control starts after the line where, its respective END-IF is present
-
(D) None of the above.
-
A. STORAGE GROUP -->DATABASE --> TABLESPACE -->TABLE--> VIEW
-
B.TABLESPACE -> DATABASE-> TABLE-> VIEW--> STORAGE GROUP
-
C. DATABASE --> TABLE --> TABLE SPACE --> VIEW-->STORAGE GROUP
-
D. VIEW --> TABLE --> DATABASE--> TABLE SPACE --> STORAGE GROUP
SQL Return code -180
-
Foreign Key constraint
-
Bind Issue
-
Invalid date or Time
-
Invalid string
AI Explanation
To answer this question, we need to understand the different return codes in SQL and their meanings.
Return code -180 in SQL typically indicates an "Invalid date or time" error. This error occurs when there is an issue with the format or value of a date or time value being used in a SQL statement.
Let's go through each option to understand why it is correct or incorrect:
Option A) Foreign Key constraint - This option is incorrect because return code -180 does not indicate a foreign key constraint error. Foreign key constraint errors are usually indicated by different return codes, such as -530 or -532.
Option B) Bind Issue - This option is incorrect because return code -180 does not indicate a bind issue. Bind issues are typically indicated by different return codes, such as -803 or -805.
Option C) Invalid date or Time - This option is correct because return code -180 does indicate an "Invalid date or time" error. This error occurs when there is an issue with the format or value of a date or time value being used in a SQL statement.
Option D) Invalid string - This option is incorrect because return code -180 does not indicate an invalid string error. Invalid string errors are typically indicated by different return codes, such as -305 or -432.
The correct answer is C) Invalid date or Time. This option is correct because return code -180 is associated with an "Invalid date or time" error.
-
Bind issue
-
String representation of invalid date value
-
Both A and B
-
No Null indicator
SQL Return code -204
-
Row not found
-
Column not found
-
Both A and B
-
Table not found
SQL Return code -501
-
With Hold option missing
-
Cursor not open
-
Cursor not close
-
BOTH B and C
SQL Return Code -502
-
Cursor not closed
-
Cursor not opened
-
Cursor already open
-
ALL the ABOVE
-
Invalid column values
-
Invalid date or time
-
Update issue. Update clause missing in the select statement of the cursor
-
BOTH A and B
SQL Return code -530
-
Foreign Key constraint
-
Bind issue
-
Authorization iussue
-
BOTH A and C
SQL Return code -532
-
Restriction in deletion
-
Foreign key constraint
-
Invalid update
-
Both A and B
-
Column value is not valid
-
Duplicate Value
-
Row not found
-
BOTH A and C
Sql Return code -117
-
Row not found
-
Privilege issue
-
Bind issuie
-
Insert value is missing for a Column
Sql Return code -805
-
Column not found
-
Duplicate value
-
Bind issue
-
Invalid time and date
Sql Return code -811
-
Fetching only Zero Rows
-
Fetching more than one row.
-
Table not found
-
BOTH A and B
AI Explanation
To answer this question, we need to understand the possible meanings of SQL return code -811.
SQL return code -811 typically indicates that a SELECT statement returned more than one row. Therefore, option B, "Fetching more than one row," is the correct answer.
Let's go through each option to understand why it is correct or incorrect:
A) Fetching only Zero Rows - This option is incorrect because SQL return code -811 does not indicate that zero rows were fetched. It specifically indicates that more than one row was fetched.
B) Fetching more than one row - This option is correct. SQL return code -811 indicates that a SELECT statement returned more than one row.
C) Table not found - This option is incorrect. SQL return code -811 is not related to a table not being found. It specifically indicates that multiple rows were fetched.
D) BOTH A and B - This option is incorrect. SQL return code -811 does not indicate fetching zero rows. It specifically indicates fetching more than one row.
Therefore, the correct answer is B) Fetching more than one row because SQL return code -811 indicates that a SELECT statement returned more than one row.
Sql Return code -818
-
Bind issue
-
No Null indicator found
-
Invalid Date or Time
-
Timestamp mismatch between Load and BIND
Sql Return code -904
-
RESOURCE UNAVAILABLE
-
TABLE NOT FOUND
-
PLAN NOT FOUND
-
ALL THE ABOVE
SQL Retun code -911
-
BOTH B and C
-
Privilege issue
-
Dead Lock
-
No row found
Sql Return code -913
-
Access not given
-
Plan not found
-
Deadlock and Timeout
-
Authorization isse
SQL Return code -922
-
Dead Loack
-
Time out
-
BOTH A and D
-
Authorization failure
AI Explanation
To answer this question, let's go through each option to understand why it is correct or incorrect:
Option A) Dead Lock - This option is incorrect because a dead lock is a situation where two or more transactions are permanently blocked, waiting for each other to release the resources they need to continue executing. It is not related to return code -922 in SQL.
Option B) Time Out - This option is incorrect because a timeout occurs when a process or query takes longer than a specified time to complete. It is not related to return code -922 in SQL.
Option C) BOTH A and D - This option is incorrect because option A (Dead Lock) is incorrect. Therefore, it cannot be both A and D.
Option D) Authorization failure - This option is correct because return code -922 in SQL typically indicates an authorization failure. It means that the user does not have the necessary permissions or privileges to perform the requested operation.
The correct answer is D. This option is correct because return code -922 in SQL indicates an authorization failure.
-
Colum not found
-
Rows found
-
No Row found
-
Both A and B