Monday, June 29, 2009

HR Questions (Most commonly asked Interview Questions)1. Tell me about you!Keep your answer to one or two minutes; don't ramble. Stick to what you'vewritten in your resume summary. To answer this question well, you'll needto start with a solid and concise resume summary.2. What do you know about our company?Do your homework before the interview! Spend some time online or at thelibrary researching the company. Find out as much as you can, includingproducts, size, income, reputation, image, management talent, people,skills, history and philosophy. Project an informed interest; let theinterviewer tell you about the company.3. Why do you want to work for us?Don't talk about what you want; first, talk about their needs: You would liketo be part of a specific company project; you would like to solve a companyproblem; you can make a definite contribution to specific company goals.4. What would you do for us?What they really want to know is... What can you do for us that someoneelse can't? Relate past experiences that show you've had success insolving previous employer problem(s) that may be similar to those of theprospective employer. Make sure you have a strongly worded EmploymentHistory section in your resume, that you can refer to.5. What about the job offered do you find the most attractive? Leastattractive?List three or more attractive factors and only one minor unattractive factor.6. Why should we hire you?Because of your knowledge, experience, abilities and skills.7. What do you look for in a job?An opportunity to use your skills, to perform and be recognized.8. Please give me your definition of a.... (the position for which you arebeing interviewed).Keep it brief -- give an action- and results-oriented definition.9. How long would it take you to make a meaningful contribution to ourfirm?Not long at all -- you expect only a brief period of adjustment to thelearning curve.10. How long would you stay with us?As long as we both feel I'm contributing, achieving, growing, etc.Warm-Up Questions1. What made you apply for this position?2. How did you hear about this job opening?3. Briefly, would you summarize your work history & education for me?Work History1. What special aspects of your work experience have prepared you forthis job?2. Can you describe for me one or two of your most importantaccomplishments?3. How much supervision have you typically received in your previousjob?4. Describe for me one or two of the biggest disappointments in yourwork history?5. Why are you leaving your present job? (or, Why did you leave yourlast job?)6. What is important to you in a company? What things do you look forin an organization?Job Peformance1. Everyone has strengths & weaknesses as workers. What are yourstrong points for this job?2. What would you say are areas needing improvement?3. How did your supervisor on your most recent job evaluate your jobperformance? What were some of the good points & bad points ofthat rating?4. When you have been told , or discovered for yourself , a problem inyour job performance, what have you typically done? Can you giveme an example?5. Do you prefer working alone or in groups?6. What kind of people do you find it most difficult to work with? Why?7. Starting with your last job, tell me about any of your achievementsthat were recognized by your superiors.8. Can you give me an example of your ability to manage or superviseothers?9. What are some things you would like to avoid in a job? Why?10. In your previous job what kind of pressures did you encounter?11. What would you say is the most important thing you are looking forin a job?12. What are some of the things on your job you feel you have doneparticularly well or in which you have achieved the greatestsuccess? Why do you feel this way?13. What were some of the things about your last job that you foundmost difficult to do?14. What are some of the problems you encounter in doing your job?Which one frustrates you the most? What do you usually do aboutit?15. What are some things you particularly liked about your last job?16. Do you consider your progress on the job representative of yourability? Why?17. How do you feel about the way you & others in the department weremanaged by your supervisor?18. If I were to ask your present (most recent) employer about yourability as a____________________, what would he/she say?EDUCATION1. What special aspects of your education or training have preparedyou for this job?2. What courses in school have been of most help in doing your job?CAREER- GOALS1. What is your long-term employment or career objective?2. What kind of job do you see yourself holding five years from now?3. What do you feel you need to develop in terms of skill & knowledgein order to be ready for that opportunity?4. Why might you be successful in such a job?5. How does this job fit in with your overall career goals?6. Who or what in your life would you say influenced you most withyour career objectives?7. Can you pinpoint any specific things in your past experience thataffected your present career objectives?8. What would you most like to accomplish if you had this job?9. What might make you leave this job?SELF-ASSESSMENT1. What kind of things do you feel most confident in doing?2. Can you describe for me a difficult obstacle you have had toovercome? How did you handle it? How do you feel this experienceaffected your personality or ability?3. How would you describe yourself as a person?4. What do you think are the most important characteristics & abilities aperson must possess to become a successful ( )? How do you rateyourself in these areas?5. Do you consider yourself a self-starter? If so, explain why ( and giveexamples)6. What do you consider to be your greatest achievements to date?Why?7. What things give you the greatest satisfaction at work?8. What things frustrate you the most? How do you usually cope withthem?CREATIVITY1. In your work experience, what have you done that you consider trulycreative?2. Can you think of a problem you have encountered when the oldsolutions didn't work & when you came up with new solutions?3. Of your creative accomplishments big or small , at work or home,what gave you the most satisfaction?4. What kind of problems have people recently called on you to solve?Tell me what you have devised.DECISIVENESS1. Do you consider yourself to be thoughtful, analytical or do youusually make up your mind fast? Give an example. (Watch time takento respond)2. What was your most difficult decision in the last six months? Whatmade it difficult?3. The last time you did not know what decision to make, what did youdo?4. How do you go about making an important decision affecting yourcareer?5. What was the last major problem that you were confronted with?What action did you take on it?RANGE OF INTERESTS1. What organizations do you belong to?2. Tell me specifically what you do in the civic activities in which youparticipate. (Leading questions in selected areas. i.e. sports,economics, current events, finance.)3. How do you keep up with what's going on in your company / yourindustry/ your profession?MOTIVATION1. What is your professional goal?2. Can you give me examples of experience on the job that you feltwere satisfying?3. Do you have a long & short-term plan for your department? Is itrealistic?4. Did you achieve it last year?5. Describe how you determine what constitutes top priorities in theperformance of your job.WORK STANDARDS1. What are your standards of success in your job?2. In your position, how would you define doing a good job? On whatbasis was your definition determined?3. When judging the performance of your subordinate, what factors orcharacteristics are most important to you?LEADERSHIP1. In your present job what approach do you take to get your peopletogether to establish a common approach to a problem?2. What approach do you take in getting your people to accept yourideas or department goals?3. What specifically do you do to set an example for your employees?4. How frequently do you meet with your immediate subordinates as agroup?5. What sort of leader do your people feel you are? Are you satisfied?6. How do you get people who do not want to work together toestablish a common approach to a problem?7. If you do not have much time & they hold seriously differing views,what would be your approach?8. How would you describe your basic leadership style? Give specificexamples of how you practice this?9. Do you feel you work more effectively on a one to one basis or in agroup situation?10. Have you ever led a task force or committee or any group whodoesn't report to you, but from whom you have to get work? How didyou do it? What were the satisfactions & disappointments? Howwould you handle the job differently?ORAL PRESENTATION SKILLS1. Have you ever done any public or group speaking? Recently? Why?How did it go?2. Have you made any individual presentations recently? How did youprepare?WRITTEN COMMUNICATION SKILLS1. Would you rather write a report or give a verbal report? Why?2. What kind of writing have you done? For a group? For an individual?3. What is the extent of your participation in major reports that have tobe written?FLEXIBILITY1. What was the most important idea or suggestion you receivedrecently from your employees? What happened as a result?2. What do you think about the continuous changes in companyoperating policies & procedures?3. How effective has your company been in adapting its policies to fit achanging environment?4. What was the most significant change made in your company in thelast six months which directly affected you, & how successfully doyou think you implemented this change?STRESS TOLERANCE1. Do you feel pressure in your job? Tell me about it.2. What has been the highest pressure situation you have been underin recent years? How did you cope with it?STABILITY & MATURITY1. Describe your most significant success & failure in the last twoyears.2. What do you like to do best?3. What do you like to do least?4. What in your last review did your supervisor suggest neededimprovement?5. What have you done about it?INTEREST IN SELF DEVELOPMENT1. What has been the most important person or event in your own selfdevelopment?2. How much of your education did you earn?3. What kind of books & other publications do you read?4. Have you taken a management development course?5. How are you helping your subordinates develop themselves?TESTING GENERAL1. What is workadround ?2. What is a show stopper?3. What is Traceability Matrix? Who prepares this document?4. What is testlog document in testing process?5. What is the Entry And Exit Criteria of a test plan? 2.How to Automateyour test plan?6. What is the role of QA in a company that produces software?7. What is terminologe? Why testing necessary? Fundamental test processpsychology of testing8. What are the common bugs encountered while testing an applicationmanually or using test?9. What are the bug and testing metrics?10. For a bug with high severity can we give the priority also to be high...Ifso why we need both?11. How would you differentiaite between Bug, Defect, Failure, Error.12. What is the difference between Client Server Testing and Web Testing?13. What is backward compatibility testing ?14. What certifications are available in testing?15. What is release candidate?16. What do you think the role of test-group manager should be?17. What is a test data? Give examples18. What is the difference between QA, QC and testing?19. What is seviarity & priority? What is test format? Test procedure?20. What are the different is manual database checking types?WEB TESTING1. What is the difference between testing in client-server applications andweb based applications?2. Without using GUI map editor, Can we recognise the application inWinrunner?3. What command is used to launch a application in Winrunner?4. What is the difference in testing a CLIENT-SERVER application and aWEB application ?6. What bugs are mainly come in Web Testing? What severity and prioritywe are giving?WHITE BOX TESTING1. What are the table contents in test plans and test cases?2. What are the tables in test plans and test cases?WIRELESS TESTING1. What is Wireless Testing? How do we do it? What are the concepts a testengineer should have knowledge of? How do you classify testing ofwireless products?TEST CASES1. How will you prepare test cases?2. Write the testcases on ATM Transactions?3. What is meant by Hot Keys?4. How is test case written?5. How can we write a good test case?6. How will you check that your test cases covered all the requirements7. For a triangle (sum of two sides is greater than or equal to the third side),what is the minimal number of test cases required.TEST DIRECTOR1. Difference between WEBINSPECT-QAINSPECT and WINRUNNER/TESTDIRECTOR?2. How will you generate the defect ID in test director? Is it generatedautomatically or not?3. Difference between TD 8.0 (Test director) and QC 8.0 (Quality Center).4. How do you ensure that there are no duplication of bugs in TestDirector?5. Difference between WinRunner and Test Director?6. How will you integrated your automated scripts from TestDirector?7. What is the use of Test Director software?TESTING-SCENARIOS1. How to find out the length of the edit box through WinRunner?2. Is it compulsary that a tester should study a Design Document for writingintegration and system test casses3. What is Testing Scenario? What is scenario based testing? Can youexplain with an example?4. Lets say we have an GUI map and scripts, and we got some 5 new pagesincluded in an application, How do we do that?5. How do you complete the testing when you have a time constraint?6. Given an yahoo application how many test cases u can write?7. GUI contains 2 fields. Field 1 to accept the value of x and Field 2 displaysthe result of the formula a+b/c-d where a=0.4*x, b=1.5*a, c=x, d=2.5*b; Howmany system test cases would you write8. How do you know that all the scenarios for testing are covered?TEST AUTOMATION1. Give me an example where you have customized an automated testscript.2. What steps have you followed while automating?.......a) Running the test manually and ensuring a "pass"........b) Recording.......c) Checkpoints/Verification3. Can you automate Context-sensitive help? If so, how do you that?4. What are the major differences between Stress testing, Load testing,Volume testing?5. What is the difference between quality assurance and testing?6. What are the main attributes of test automation?7. What is data - driven automation?8. What is 'configuration management'?9. What is memory leaks and buffer overflows?10. Why does software have bugs?11. How do you do usability testing, security testing, installation testing,ADHOC, safety and smoke testing?12. Describe some problem that you had with automating testing tool.13. How do we test for severe memory leakages?14. What are the problems encountered during the testing the applicationcompatibility on different browsers and on different operating systems15. How will you evaluate the fields in the application under test usingautomation tool?16. How did you use automating testing tools in your job?17. What skills needed to be a good test automator?18. Can the activities of test case design be automated?19. What types of scripting techniques for test automation do you know?.What are scripting techniques? Could you describe the 5 techniquesmentioned?20. What tools are available for support of testing during softwaredevelopment life cycle?SOFTWARE TESTING1. What is the diffrence between Regression testing and Retesting?2. What are the errors encountered while testing an application manually orusing automated tool like Testdirector, Winrunner?3. What is Inspection, Review?4. What is the actual different between re-testing and regressiontesting.brefily explain5. Explain Test Strategy6. What is Tracebility Matrix ?7. What are the major diff. between the Winrunner 6.0 and 7.0 (with internalprocedure)?8. What test you perform mostly? Regression or retesting in your testingprocess?9. What did you do as a team leader?10. How do we know about the build we are going to test? where do yousee this?11. What is system testing and what are the different types of tests youperform in system testing?12. What is the difference between Return and treturn?13. How do you test a weblink which is changing dynamically?14. What are the flaws in water fall model and how to overcome it?15. What is defect leakage?16. Did you ever have to deal with someone who doesn't believe in testing?What did u do?17. How will you write test cases for a code currently under development?18. Describe the last project scenario and generate test cases for it?19. If there are a lot of bugs to be fixed, which one would you resolve first20. How will you test a stapler?QA TESTING1. If the actual result doesn't match with expected result in this situationwhat should we do?2. What is the importance of requirements traceability in a product testing?3. When is the best time for system testing?4. What is use case? What is the diffrence between test cases and usecases?5. What is the difference between the test case and a test script6. Describe to the basic elements you put in a defect report?7. How do you test if you have minimal or no documentation about theproduct?8. How do you decide when you have tested enough?9. How do you determine what to test?10. In general, how do you see automation fitting into the overall process oftesting?11. How do you deal with environments that are hostile to quality changeefforts?12. Describe to me the Software Development Life Cycle as you woulddefine it?13. Describe to me when you would consider employing a failure mode anddefect analysis?14. What is the role of QA in a company that produces software?15. How do you scope, organize, and execute a test project?16. How can you test the white page17. What is the role of QA in a project developement?18. How you used whitebox and block box technologies in yourapplication?19. 1) What are the demerits of winrunner?2) We write the test data afterwhat are the principles to do testing an application?20. What is the job of Quality Assurance Engineer? Difference between theTesting & Quality Assurance job.WINRUNNER INTERVIEW QUESTIONS1.. How to recognise the objects during runtime in new build version (testsuite) comparing with old guimap?2. wait(20) - What is the minimum and maximum time the above mentionedsynchronization statements will wait given that the global default timeout isset to 15 seconds.3. Where in the user-defined function library should a new error code bedefined?4. In a modular test tree, each test will receive the values for the parameterspassed from the main test. These parameters are defined in the Testproperties dialog box of each test.Refering to the above, in which one ofthe following files are changes made in the test properties dialog saved?5. What is the scripting process in Winrunner?6. How many scripts can we generate for one project?7. What is the command in Winrunner to invoke IE Browser? And once Iopen the IE browser is there a unique way to identify that browser?8. How do you load default comments into your new script like IDE's?9. What is the new feature add in QTP 8.0 compare in QTP 6.010. When will you go to automation?11. How to test the stored procedure?12. How to recognise the objects during runtime in new build version (testsuite) comparing with old guimap13. what is use of GUI files in winrunner.14. Without using the datadriven test, how can we test the application withdifferent set of inputs?15. How do you load compiled module inside a comiled module?16. Can you tell me the bug life cycle17. How to find the length of the edit box through WinRunner?18. What is file type of WinRunner test files, its extension?19. What is candidate release?20. What type of variables can be used with in the TSL function?RATIONAL ROBOT1. In which directory are the .sbl files stored?2. What SQABasic commands have you used?3. Difference between SQAgetpropertyArray and SQAGetPropertyAsString?4. What do .sbl and .sbh represent?5. Is there any Load testing tool called Rational Site Load tool?6. What is the difference between rational robot and QTP or Winrunner?Which is more ueful of the three?7. What is the difference between Rational Robot (Rational FunctionalTester) and IBM functional tester? which is better?QTP1. How can I add an action (external action) programmatically?2. How can I call an external action, which is not added external action ofan action.3. What is meant by Source Control?4. How and what kind of VB functions do u use in QTP?5. How can u describe the basic flow of automation with conditional andprogrammatic logic?6. How can I implement error handling in QTP,7. How to recall a function in QTP8. Give one example where you have used Regular Expression?9. How can I implement error handling in QTP?10. How to select particular value from the combo box in the current pagewhich is entered in the previous page edit box after parameterization?11. If you have the same application screen with 7 drop down boxes andapproximately 70 values how do you test with QTP?12. When there is a task that gets repeated in multiple scripts, what do youdo in QTP?13. What is the descriptive programming?14. What is the use of descriptive programming?15. How to instruct QTP to display errors and other description in the testresults instead of halting execution by throwing error in the mid ofexecution due to an error (for example Object not found)?16. How you write scripts in QTP? What's the main process in QTP? Howdo you run scripts in QTP? Please anyone can answer my questions.......17. What is descriptive programming?18. How to add run-time parameter to a datasheet?19. How to load the *.vbs or test generating script in a new machine?20. How can you write a script without using a GUI in QTP?LOADRUNNER1. What is load testing? Can we test J2ME application with load runner ?What is Performance testing?2. Which protocol has to be selected for record/playback Oracle 9iapplication?3. What are the enhancements which have been included in loadrunner 8.0when compared to loadrunner 6.2?4. Can we use Load Runner for testing desktop applications or non webbased applications and how do we use it.?5. How to call winrunner script in Loadrunner?6. What arr the types of parameterisation in load runner? List the step to dostrees testing?7. What are the steps for doing load and performance testing using LoadRunner?8. What is concurrent load and corollation? What is the process of loadrunner?9. What is planning for the test?10. What enables the controller and the host to communicate with eachother in Load Runner?11. Where is Load testing usually done?12. What are the only means of measuring performance?13. Testing requirement and design are not part of what?14. According to Market analysis 70% of performance problem lies withwhat?15. What is the level of system loading expected to occur during specificbusiness scenario?16. What is run-time-setting.17. When load runner is used .18. What protocols does LoadRunner support?19. What do you mean by creating vuser script.?20. What is rendezvous point?LOAD TESTING1. What are the uses of load testing ? What is defered graphs? What are thedifferent components in loadrunner?2. How you analyze graphics in loadrunner? How do you work bug log?3. How can data caching have a negative effect on load testing results?4. What criteria would you use to select Web transactions for load testing?5. For what purpose are virtual users created?6. What is the difference between Load testing and Performace Testing?7. Why do you need to parameterize fields in your virtual user script?8. What are the reasons why parameterization is necessary when loadtesting the Web server and the database server?9. Why it is recommended to add verification checks to your all yourscenarios?10. Load Testing - What should be analyzed.11. In what situation would you want to parameterize a text verificationcheck?12. What usually indicates that your virtual user script has dynamic datathat is dependent on you parameterized fields?13. What are the benefits of creating multiple actions within any virtual userscript?DATABASE TESTING1. What SQL statements have you used in Database Testing?2. How to test data loading in Database testing3. What is way of writing testcases for database testing?4. What is Database testing?5. What we normally check for in the Database Testing?6. How to Test database Manually? Explain with an exampleCOMMON INTERVIEW QUESTIONS1. What Technical Environments have you worked with?2. Have you ever converted Test Scenarios into Test Cases?3. What is the ONE key element of 'test case'?4. What is the ONE key element of a Test Plan?5. What is SQA testing? tell us steps of SQA testing6. How do you promote the concept of phase containment and defectprevention?7. Which Methodology you follow in your Testcase?8. Specify the tools used by MNC companies9. What are the test cases prepared by the testing team10. During the start of the project how will the company come to anconclusion that tool is required for testing or not?11. Define Bug Life Cycle? What is Metrics12. What is a Test procedure?13. What is the difference between SYSTEM TESTING and END-TO-ENDTESTING?14. What is Traceability Matrix? Is there any interchangeable term forTraceability Matrix ?Are Traceability Matrix and Test Matrix same orDifferent ?15. What is the differance between an exception and an error?16. Correct bug tracking process - Reporting, Re-testing, Debigging, .....?17. What is the difference between bug and defect?18. How much time is/should be alloated for Testing out of totalDevelopment time based on industry standards?19. What are test bugs?20. Define Quality - bug free, Functionality working or both?COMMON QUESTIONS1. If you have an application, but you do not have any requiremntsavailable, then how would you perform the testing?2. How can you know if a test case is necessary?3. What is peer review in practical terms?4. How do you know when you have enough test cases to adequately test asoftware system or module?5. Who approved your test cases?6. What will you when you find a bug?7. What test plans have you written?8. What is QA? What is Testing? Are they both same or different?9. How to write Negative Testcase? Give ex.10. In an application currently in production, one module of code is beingmodified. Is it necessary to re-test the whole application or is it enough tojust test functionality associated with that module?11. What is included in test strategy? What is overall process of testingstep by step and what are various documnets used testing during process?12. What is the most challenging situation you had during testing13. What are you going to do if there is no Functional Spec or anydocuments related to the system and developer who wrote the code doesnot work in the company anymore, but you have system and need to test?14. What is the major problem did you resolve during testing process15. What are the types of functional testing?16. 1. How will you write integration test cases 2. How will you track bugsfrom winrunner. 3.How will you customise the bugs as pass/fail. 4. You finda bug How will you repair 5. In testcases you have bug or not. 6. What isuse case ? what does it contains.17. What is the difference between smoke testing and sanity testing18. What is Random Testing?19. What is smoke testing?20. What is stage containment in testing?BUG TRACKING1. What is the difference between a Bug and a Defect?2. How to post a BUG3. How do we track a bug?plz send format of excel sheet in which we writethe bug details? How do we give the severithy and priority to the bugs?4. What are the different types of Bugs we normally see in any of theProject? Include the severity as well.5. Top Ten Tips for Bug TrackingDB2 INTERVIEW QUESTIONS1. 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 andcorresponding 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 infile-id?17. There are two programs say A&B,A is only cobol program,B iscoboldb2program, 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 todelete, that one ,if dataset is no existing, I do not want abend the job, howcan 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 itmeans 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 recordsonly 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 recordsare there?32. I have 1000 records in vsam,I want to read records 500 to 90033. Explain Reuse and upgrade34. 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 willbe?What is the need of compiler options?37. Suppose there is cobol-db2 program.I made changes only in the cobolprogram.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 sohow?40. What is the diff bet plan,package,dbrm?41. After retrieving the elements from production,how can do the testingbefore moving the changes to production. Whether we have to create theJCL for testing or it will automatically tested and compiled?42. What is a packed decimal..?DATASTAGE INTERVIEW QUESTIONS1. How do you rename all of the jobs to support your new File-namingconventions?2. Does the selection of 'Clear the table and Insert rows' in the ODBC stagesend a Truncate statement to the DB or does it do some kind of Deletelogic.3. Tell me one situation from your last project, where you had facedproblem and How did u solve it?4. The above might rise another question: Why do we have to load thedimensional tables first, then fact tables:5. How will you determine the sequence of jobs to load into datawarehouse?6. What are the command line functions that import and export the DSjobs?7. What is the utility you use to schedule the jobs on a UNIX server otherthan using Ascential Director?8. How would call an external Java function which are not supported byDataStage?9. What will you in a situation where somebody wants to send you a fileand use that file as an input or reference and then run job.10. Read the String functions in DS11. How did u connect with DB2 in your last project?12. What are Sequencers?13. How did you handle an 'Aborted' sequencer?14. What are other Performance tunings you have done in your last projectto increase the performance of slowly running jobs?15. How did you handle reject data?16. If worked with DS6.0 and latest versions what are Link-Partitioner andLink-Collector used for?17. What are Routines and where/how are they written and have youwritten any routines before?18. What are OConv () and Iconv () functions and where are they used?19. How did u connect to DB2 in your last project?20. Do u know about METASTAGE?21. Do you know about INTEGRITY/QUALITY stage?22. Explain the differences between Oracle8i/9i?23. How good are you with your PL/SQL?24. Did you work in UNIX environment?25. What other ETL's you have worked with?26. What versions of DS you worked with?27. What is DS Designer used for - did u use it?28. What is DS Administrator used for - did u use it?29. What is DS Director used for - did u use it?30. What is DS Manager used for - did u use it?31. What are Static Hash files and Dynamic Hash files?32. What is Hash file stage and what is it used for?33. Have you ever involved in updating the DS versions like DS 5.X, if sotell us some the steps you have taken in doing so?34. Did you Parameterize the job or hard-coded the values in the jobs?35. How do you merge two files in DS?.NET INTERVIEW QUESTIONS1. Explain the differences between Server-side and Client-side code?2. What type of code (server or client) is found in a Code-Behind class?3. Should validation (did the user enter a real date) occur server-side orclient-side? Why?4. What does the "EnableViewState" property do? Why would I want it on oroff?5. What is the difference between Servers? Transfer and Response.Redirect? Why would I choose one over the other?6.Can you give an example of when it would be appropriate to use a webservice as opposed to a non-serviced .NET component7.Let's say I have an existing application written using Visual Studio 6 (VB6, InterDev 6) and this application utilizes Windows 2000 COM+ transactionservices. How would you approach migrating this application to .NET8.Can you explain the difference between an ADO.NET Dataset and an ADORecordset?9. Can you give an example of what might be best suited to place in theApplication Start and Session Start subroutines?10. If I'm developing an application that must accommodate multiplesecurity levels though secure login and my ASP.NET web application isspanned across three web-servers (using round-robin load balancing) whatwould be the best approach to maintain login-in state for the users?JAVA INTERVIEW QUESTIONSJAVA:-1) What is static variable.2) What is transient variable?3) What is final variable.4) What is final method.5) What is native method.6) What is abstract method7) what is innerclass.8) What is static class?9) What is final class.10) What is anonymous class?JDBC:1) What is a transaction. (*)2) What is the purpose of setAutoCommit(). (*)3) What are the three statements in JDBC & differences between them. (*)4) What is stored procedure. How do you create stored procedure? (*)5) What are batch updates.JSP:1)What is JSP. (*)2)What are advantages of JSP.3)What is the difference between include directive & jsp:include action. (*)4)What are Custom tags. Why do you need Custom tags. How do youcreate Custom tag. (*)5)What are the implicit objects in JSP & differences between them. (*)Servlets:1)What are Servlets.2)What are the advantages of Servlet.3)What is the Life cycle of Servlet. (*)4)What is the difference between Servlet and JSP. (*)EJB:- (All questions are important)1)What is the difference between normal Java object and EJB.2)What is the difference between JavaBean and EJB.3)What is EJB.4)What is Session Bean. What are the various types of Session Bean.XML:-1)What is the difference between SAX parser and DOM parser. (*)2)What is the difference between Schema and DTD. (*)3)How do you parse/validate the XML document. (*)4)What is XML Namespace.5)What is Xpath.PEOPLESOFT INTERVIEW QUESTIONS1)What is the APP engine event in peoplecode.2)what are the different actions in APP ENGINE.3)How many temp records are there in app engine.4)How do you debug your AE.5)Why temp records are needed?6)Why state records are needed?7)Differences between State and temp records.8)Different ways to run AE, SQR.(Command, process scheduler)7)Different sql statements and metasql statements.8)How do you retrieve a value from scroll..scroll select?9)What is scroll select, etc10)what is record, row peoplecode.DATABASE QUESTIONS1)What are copybooks(DB2)?2)What is plan?3)Tell me the sections in COBOL?4)Connectivity to DB2 from COBOL.5)What are the customizations in COBOL?6)Diff between union and union all?7)Give me example for group by.8)What is SPUFI?9)Replacement of query analyzer--- SPUFI(DB2)ABAP QUESTIONS:1.Elementary search helps, Collective search help.2.Difference between Search Helps and Match Codes3.Have you created database tables?4.Difference between client dependent and client independent tables?5.How to create client independent tables6.Have you created Maintenance dialog or Table Maintenance?7.On ABAP: Did you set up a workflow? Are you familiar with all steps forsetting up a workflow?8.Have you used performance tuning? What major steps will you use forthese?9.In the ‘select’ statement what is “group by”?10.Have you worked with field groups? Have you used Import/Exportstatements?ABAP EDITOR:1.Fixed point arithmetic – what is the use? How to set this?2.Have you used client dependent ABAP programs?DATABASE COMMANDS:1.Select statement to read data into internal tables. Types of Selectstatements2.What happens “Update” command is used without where clause ?3.Difference between “Insert”, “Update” and “Modify”4.Explain “Commit” and “Roll back”5.“Catch” Command6.What is “Group by” in Select statement?TEST AUTOMATION:1.What automating testing tools are you familiar with?2.How did you use automating testing tools in your job?3.Describe some problem that you had with automating testing tool.4.How do you plan test automation?5.Can test automation improve test effectiveness?6.What is data - driven automation?7.What are the main attributes of test automation?8.Does automation replace manual testing?9.How will you choose a tool for test automation?10.How you will evaluate the tool for test automation?LOAD TESTING:1.What criteria would you use to select Web transactions for load testing?2.For what purpose are virtual users created?3.Why it is recommended to add verification checks to your all yourscenarios?4.In what situation would you want to parameterize a text verificationcheck?5.Why do you need to parameterize fields in your virtual user script?GENERAL QUESTIONS:1.What types of documents would you need for QA, QC, and Testing?2.What did you include in a test plan?3.Describe any bug you remember.4.What is the purpose of the testing?5.What do you like (not like) in this job?6.What is quality assurance?7.What is the difference between QA and testing?8.How do you scope, organize, and execute a test project?9.What is the role of QA in a development project?10.What is the role of QA in a company that produces software?C C PLUS PLUS INTERVIEW QUESTIONS1. What is the output of printf("%d")2. Difference between "C structure" and "C++ structure".3. Difference between a "assignment operator" and a "copyconstructor"4. What is the difference between "overloading" and "overriding"?5. Explain the need for "Virtual Destructor".6. Can we have "Virtual Constructors"?7. What are the different types of polymorphism?8. What are Virtual Functions? How to implement virtual functions in"C"9. What are the different types of Storage classes?10. What is Namespace?VISUAL BASIC INTERVIEW QUESTIONS1. 3 main differences between flexgrid control and dbgrid control2. ActiveX and Types of ActiveX Components in VB3. Advantage of ActiveX Dll over Active Exe4. Advantages of disconnected recordsets5. Benefit of wrapping database calls into MTS transactions6. Benefits of using MTS7. Can database schema be changed with DAO, RDO or ADO?8. Can you create a tabletype of recordset in Jet - connected ODBCdatabase engine?9. Constructors and distructors10. Controls which do not have eventsSQL Server1.What are primary keys and foreign keys?2.What is the difference between clustered and non-clustered indices?...and why do you use a clustered index?3.What is an outer join?4.What are Cartesian joins?5.How is referential integrity enforced in a SQL Server database?6.What are the inserted and deleted tables and what are they used for?7.What is the name of the SQL language used in SQL Server storedprocedures?8.What is the purpose of having stored procedures in a database?9.Why might you create a stored procedure with the 'with recompile'option?10.What is a cursor? Within a cursor, how would you update fields on therow just fetched?SQL, ORACLE, PRO*C/C++1.What are the different types of joins?2.Explain normalization with examples.3.What cursor type do you use to retrieve multiple recordsets?4.Difference between a "where" clause and a "having" clause5.What is the difference between "procedure" and "function"?6.How will you copy the structure of a table without copying the data?7.How to find out the database name from SQL*PLUS command prompt?8.Talk about "Exception Handling" in PL/SQL?9.What is the difference between "NULL in C" and "NULL in Oracle?"10.What is Pro*C? What is OCI?ORACLE CONCEPTS AND ARCHITECTURE DATABASE STRUCTURES1.What are the components of physical database structure of Oracledatabase?2.What are the components of logical database structure of Oracledatabase?3.What is a tablespace?4.What is SYSTEM tablespace and when is it created?5.Explain the relationship among database, tablespace and data file.6.What is schema?7.What are Schema Objects?8.Can objects of the same schema reside in different tablespaces?9.Can a tablespace hold objects from different schemes?10.What is Oracle table?SIEBEL INTERVIEW QUESTIONS1.How do you control visibility in Siebel?2.What is the difference between an organization and division in Siebel?3.What does position represents in Siebel?4.How do you assign responsibilities to employees in Siebel?5.How do you set up employees in Siebel?6.What happens if you create an employee in Siebel application and forgetto create the employee in the database?7.Why do you need to create employees at the database in Siebel?8.What is position type field in position applet?9.What does an opportunity, account contact do in Siebel?10.How is the opportunity related to an account?DATAWARE HOUSING INTERVIEW QUESTIONS(ETL, BUSINESSINTELLIGENCE,ABINITIO)GENERAL :1. What is a data-warehouse?2. What are Data Marts?4. What is ER Diagram?5. What is a Star Schema?6. What is Dimensional Modelling?7. What is Snow Flake Schema?ETL QUESTIONS:1. What is a staging area? Do we need it? What is the purpose of a stagingarea?2. What is a three tier data warehouse?3. What are the various methods of getting incremental records or deltarecords from the source systems?BUSINESS INTELLIGENCE:1. What is Business Intelligence?2. What is OLAP?3. What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?ABINITIO:1.What is the function you would use to transfer a string into a decimal?2.How many parallelisms are in Abinitio? Please give a definition of each.3.What is the difference between a DB config and a CFG file?