Code.GeekInterview.com
  I am new, Sign me up!
 

Categories

Latest Articles

 
Home Career Center Interview Questions

DB2 Interview Questions

     Published: 6th Jun 2005     Read: 14304 times
Category: Interview Questions
Add Comment
 




Please find the questions in DB2, actually i want answers for few queries in mainframes that is (DB2,CICS,JCL,VSAM).i am sending u the queries in the below ,please let me know if i can get solutions to these queries. These are the interview questions which were asked to me in some companies recently.


Latest Questions
1.  Can you display the index?
2.   At what stage db2 must be up?
3.   When do you use subroutines?
4.   Initial position of cursor of the exucuton of open statements?
5.   What is the index ,types of index ?
6.   How many clustering indexes are pasing for a table?
7.   When u will use curser with hold option?
8.   File opening modes in cobol and corresponding dispositions?
9.   What will happened .if the file is open in extend mode and corresponding is equal to old in jcl?
10.   How to know other person job status?
11.   What will happened ,if the subprogram is called second time?
12.   Can u see s9(4)comp3 data?
13.   Commenly facing errors?
14.   What is low values and high values?
15.   How to enter in xpediter?
16.   A dataset contains 1000 records ,I want to brouse particular record in file-id?
17.   There are two programs say A&B,A is only cobol program,B iscobol-db2 program, how to compile both programs?
18.   How to pass return codes from Cobol to jcl?
19.   In my jcl ,the 1st step is delete step, if the data set is existing, I want to delete, that one ,if dataset is no existing, I do not want abend the job, how can I code in disp?
20.   What is diff b/w check pending and copy pending?
21.   How to Repair the table?
22.   How to see the status of the table?
23.   How to load data to a table?
24.   What is diff b/w QMF & Spoofi?
25.   I have update Row in table using spoofi.how Revert that update Row it means original position?
26.   Quick Respendse and REspondce time in file-aid?
27.   File contains 5 records say D,E,F,C,A-I want to copy D and A records only by using file-aid?
28.   What is severity one error in production support?
29.   How to increase table space in db2?
30.   What is the indexset and sequence set in vsam ksds?
31.   How to read last record in vsam file.,I don't know how many records are there?
32.   I have 1000 records in vsam,I want to read records 500 to 900
33.   Explain Reuse and upgrade
34.   How do you read vsam file?
35.   How can we over come the same situation when using flat file.
36.   what r the compiler options we use?where the compiler option will be?What is the need of compiler options?
37.   Suppose there is cobol-db2 program.I made changes only in the cobol program.Is there need recomile the DBRM again?why?
38.   After bind i how can we run a cobol-db2 program?
39.   By using any condition is there any way to abend a program.?If so how?
40.   What is the diff bet plan,package,dbrm?
41.   After retrieving the elements from production,how can do the testing before moving the changes to production. Whether we have to create the JCL for testing or it will automatically tested and compiled?
42.   What is a packed decimal..?


 






Next: Latest Career Articles and Free Trainings



Post Comment


Members Please Login

Name:
Email: (Optional)
 (Used for Notification)
Title:
Comment:
Validation Code:
 <=>  (Enter this code in text box)


Subscribe

 


Daily Email Updates

GeekInterview Articles Updates delivered directly to your Inbox...

Enter your email address:


Latest GeekInterview Articles Updates

Sponsored Links


 

Related Articles

 » Video Interview With Roman Strobl
 » Doctor Dobb's MP3 Audio Interview: Dan Roberts on Sun's Developer Tools, Part 1
 » Doctor Dobb's MP3 Audio Interview: Dan Roberts on Sun's Developer Tools, Part 2
 » Deep Dive: Project Tango, An Interview With Arun Gupta (Vodcast)
 » Keane Interview Experience
 » Interview Experience in TCS
 » Infosys Interview,17th april 2006,Chengannur
 » Effective Interview Skills
 » CES INTERVIEW: Gates Sees Microsoft Leading Sony In Video Games
 » 5 Questions for New Teradata CEO Michael Koehler
 

Popular Articles

About Us -  Privacy Policy -  Terms and Conditions -  Contact  

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape