abnikant
New User
Joined: 12 Jan 2007 Posts: 9 Location: Noida
|
|
|
|
Question 1. Which of the following statement is true for COMP-1 and COMP-2 data variables?
A. Both these format stores the value in binary format
B. No PIC clause should be defined for these 2 types of DATA items
C. COMP-1 uses a 1/2 word to store the data whereas COMP-2 uses full word to store the data
D. Both these data types can handle alphanumeric values also
E. The USAGE clause is must whenever these 2 data types are used in the data definition.
Answer 1. *
A & B
A, C & D
B, D & E
C, D & E
None of the above
Question 2. Which of the following operations can be performed on a file using the SEQUENTIAL access mode?
A. READ
B. WRITE
C. REWRITE
D. DELETE
E. START
Answer 2. *
A, B & D
B, D & E
A, B & C
B, C & E
None of the above
Question 3. Consider the code below, assuming N has a value of 20 what will be the output of the following piece?
PROCEDURE DIVISION.
PERFORM PARA-A THRU PARA-A-EXIT VARYING SUB FROM 3 BY 1 UNTIL SUB>N
END-PERFORM.
PARA-A.
SWITCH = 'Y'.
PERFORM PARA-B THRU PARA-B-EXIT VARYING SUB1 FROM 2 BY 1 UNTILL SUB1>(N-1)
END-PERFORM.
IF SWITCH = 'Y'
DISPLAY N
END-IF
PARA-A-EXIT.
EXIT.
PARA-B.
DIVIDE SUB1 INTO SUB GIVING Q REMAINDER R
IF R = 0
SWITCH = 'N'
END-IF
PARA-B-EXIT.
EXIT.
Answer 3. *
1,2,3,4,5,6………
1,2,4,6,8,10…….
1,2,3,5,7,11,13……..
1,2,3,5,7,9………
None of the above
Question 4. Which of the following is true in COBOL: -
A. While performing arithmetic, it is better to use unsigned numeric fields than signed fields.
B. Using indexes to address table is less efficient than using subscripts.
C. S9(6 ) COMP occupies less number of bytes than S9(7)V9(2) COMP-3.
D. For the Sorted table SEARCH ALL is much efficient than SEARCH in performance
Answer 4. *
A, B and D
C, D
A, C
A, D
None of the above
Question 5. Which of the following is true about COBOL compilation and bind process:
A. INCLUDE statement is expanded in Compile stage.
B. If the SQL syntax is incorrect, the program will fail in Pre-Compile stage.
C. If a table field used in a program does not exist in DCLGEN, program will Pre-Compile but will fail in Compile.
D. If a table field used in a program does exist in DCLGEN but not in table, the program will Compile but will fail in bind.
Answer 5. *
A, C
A, B and D
B, C
B, D
None of the Above
Question 6. A held cursor can be closed when:
A. You issue a CLOSE cursor, ROLLBACK, or CONNECT statement
B.You issue a CAF CLOSE function call or an RRSAF TERMINATE THREAD function call
C. The application program terminates.
Answer 6. *
A, B
A, B and C
A, C
B, C
None of the above
Question 7. Which statement(s) are true with regards to a primary key in a DB2 table?
A. Primary key is mandatory for a Db2 table
B. They key can include upto 64 columns
C. The length attributes of a primary key can be upto 2000
D. If a primary key is defined, an index must be created on the same set of columns, in the same order as those columns.
Answer 7. *
A, B, C and D
B, C and D
A, C and D
A, B and C
None of the above
Question 8. Which of the following functions are used to combine two or more SELECT statements to form a single result table?
A. UNION
B. EXCEPT
C. INTERSECT
Answer 8. *
A only
A, B
A, C
A, B and C
None of the above
Question 9. Which of the following command can be used in force release of a CICS program?
Answer 9. *
CEMT i REL Program(Program Name)
CEMT s TERM Program(Program Name)
CECI REL Program(Program Name)
CECI FREE Program(Program Name)
None of the Above
Question 10. Which of the followings are true -
A. Using ALTER command, you can rename a VSAM dataset.
B. While processing large VSAM dataset, it is always recommended to use BUFNO.
C. Using SORT, you can copy a VSAM dataset to another VSAM dataset.
D. Most installation of IEBGENER uses DFSORT for copy application.
Answer 10. *
A, B
B, C
B, C and D
A, C and D
None of the above
which one is the right answer in given options? |
|