Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What is meant by index cardinality?
- 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
- 1. How will u send data from a cobol file to db2 table? Discuss
- 2. What is a DB2 bind? Discuss
- 3. What is a DB2 plan? Discuss
- 4. My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why? Discuss
- 5. File contains 5 records say D,E,F,C,A-I want to copy D and A records only by using file-aid? Discuss
- 6. Why SELECT * is not preferred in embedded SQL programs? Discuss
- 7. When does the SQL statement gets executed when you use cursor in the application programming? Discuss
- 8. What is QUIESCE? Discuss
- 9. In terms of DB2 indexing, what is the root page? Discuss
- 10. In a DB2-CICS program which acts as co-ordinator and which is the participant? Discuss
Technology problems
Search Results
Correct Answer: USING HOST VARIABLE we can pass data from COBOL to DB2
Correct Answer: A DB2 bind is a process that builds an access path to DB2 tables
Correct Answer: An application plan or package is generated by the bind to define an access path
Correct Answer: Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted
Correct Answer: Go to file-aid copy optionEnter the from dataset to be copied and to dataset to which you want to copygo to options Enter 0 at Initial records to skip fieldThen enter 3 at the no of records to skip field and 1 to no of records to selectpress enter and PF3
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: SQL statement gets executed when we open cursor
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: 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
Correct Answer: DB2 acts as the participant and CICS acts as a co-ordinator
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.