Discussion
Home ‣ Interview ‣ Technology Comments
- Question
In terms of DB2 indexing, what is the root page?
- Correct Answer
- The simplest DB2 index is the B-tree and the B-tree's top page is called the root page The root page entries represent the upper range limits of the index and are referenced first in a search
- 1. What is QUIESCE? Discuss
- 2. When does the SQL statement gets executed when you use cursor in the application programming? Discuss
- 3. Why SELECT * is not preferred in embedded SQL programs? Discuss
- 4. What is meant by index cardinality? Discuss
- 5. How will u send data from a cobol file to db2 table? Discuss
- 6. In a DB2-CICS program which acts as co-ordinator and which is the participant? Discuss
- 7. What is CICS? Discuss
- 8. What CICS command are used to read a VSAM KSDS sequentially in ascending order? Discuss
- 9. What happens when a CICS command contains the NOHANDLE option? Discuss
- 10. What are different ways of Initiating Transaction in CICS? Discuss
Technology problems
Search Results
Correct Answer: A QUIESCE flushes all DB2 buffers on to the disk This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency
Correct Answer: SQL statement gets executed when we open cursor
Correct Answer: - If the table structure is changed ( a field is added ), the program will have to be modified - Program might retrieve the columns which it might not use, leading on I/O over head - The chance of an index only scan is lost
Correct Answer: The number of distinct values for a column is called index cardinality DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data
Correct Answer: USING HOST VARIABLE we can pass data from COBOL to DB2
Correct Answer: DB2 acts as the participant and CICS acts as a co-ordinator
Correct Answer: Customer Information Control System (CICS) is an online transaction processing monitor from IBM that acts as an interface between the operating system and application programs to provide rapid high-volume online transaction processing
Correct Answer: READNEXT reads the next record from a browse operation for any of the three VSAM files
Correct Answer: - NOHANDLE is an option that can be specified along with abnormal condition during program execution - When the exception occurs, no action is performed during execution of NOHANDLE command - The abnormal condition is ignored, even the EXEC CICS HANDLE condition exist - The abnormal condition is also ignored when EXEC CICS IGNORE condition is tested - The previous HANDLE CONDITION for other commands will not be effected with NOHANDLE option
Correct Answer: The following are the ways of initiating a CICS transaction 1 By entering Transaction Id 2 By Start command 3 By Return Trans Id (as in pseudo - conversation) 4 By Registering Tran ID in plt so that it will be automaticaly dusring CICS start 5 By ATI (Automatic task initiation) 6PF & PA keys as defined in PCT
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.