DB2 Interview Questions
This article provides Mainframe Interview Questions covering db2 questions. For more Interview Questions / Answers related to Mainframe, click on links provided at the end of each question set.
.
1. Loading of ‘DB2 Unload with packed Decimal’ data to Oracle environment 2. Loading of Cobol Data streams with HEX Character data to Oracle environment Are there any tools, mechanisms in Oracle or any other third party product?
2. How many columns maximum can be created in a table of a inner table of the subquerry
3. When do we need a COLLECTION?
4. What is the roll of INDEX in a query?
5. What is stored in tables under creator SYSIBM?
6. File contains 5 records say D,E,F,C,A - How to copy D and A records only by using file-aid?
7. How to load data to a table?
8. A dataset contains 1000 records, How do you browse particular record using file-id?
9. What is difference between QMF & Spoofi?
10. Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement.
11. When you will use curser with hold option?
12. How to see the status of the table?
13. Can you see s9(4)comp3 data?
14. How to know other person job status?
15. How many clustering indexes are pasing for a table?
16. How to read last record in vsam file when the number of records is not known?
17. What is low values and high values?
18. What is an intent lock?
19. What is the index, types of index?
20. Can you display the index?
Click here for more Question and Answers : DB2 Interview Question and Answers
Career Center 
