abnikant
New User
Joined: 12 Jan 2007 Posts: 9 Location: Noida
|
|
|
|
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.
ANS
A, B, C and D
B, C and D
A, C and D
A, B and C
None of the above |
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
1. Is this a COBOL thread, as subject line says so; then why to post in DB2 part of the forum?
2. Are these interview questions?
3. You started from "Question 4", where are first 3? |
|