What will be the value of B after executing the below code snippet? 77 A PIC 9(4)V999 VALUE 9902.852. 77 B PIC 9(4)V9(2) VALUE 99.85. PROCEDURE DIVISION. MULTIPLY A BY 30.5 GIVING B ROUNDED STOP RUN.
B will have 2
B will have 0002000
B will have 2662311
Program will abend
What is the precedence rule (from highest to lowest) applied for a complex condition if parentheses are not used.
Arithmetic, Relational, NOT, AND, OR
Relational, Arithmetic, NOT, AND, OR
Arithmetic, Relational, AND, OR, NOT
Arithmetic, Relational, OR, AND, NOT
Which one of the following is not an integrity?
Domain Integrity
Entity Integrity
Technology Integrity
Referential Integrity
What is the function of a precompiler ?
Extracts the SQL statements and place them into load.
Extracts the SQL statements and place them into DBRM.
Extracts the COBOL statements and place them into DBRM.
Extracts the COBOL statements and place them into load.
How many Indexes can be built on a table ?
No limit
4
15
none
What is SPUFI ?
SQL Process Used File Input.
SQL Processing Using Format Input
SQL Processing Using File Input
SQL Processing Using File Information.
Which of the following are the lock types?
shared
update
exclusive
All of the above
Which VSAM file status code indicates that you are tring to open a VSAM file that is not present?
05
41
35
91
What does a VSAM file status code '10' indicate?
successful completion
Record or file not found
End of file reached
dupliacate key
When you try to open a VSAM file, which of the following status codes are acceptable?
00
92
07
97