| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is sqlcode -922 ? | | 1 |
| In cursor program-1 can we create another cursor program-2
inside the cursor program-1.If yes how/no why ? | Wipro | 1 |
| What is the function of the Data Manager? | | 1 |
| when does the SQL statement gets executed when you use
cursor in the application programming ? | | 3 |
| how to fetch multiple records without using cursor | HCL | 9 |
| Why might full image copies be faster to implement than an
incremental image copy? | | 1 |
| What is a page? | | 2 |
| What is the format (internal layout) of ?TIMESTAMP?? | | 1 |
| What does it mean if the null indicator has -1, 0, -2? | | 1 |
| What is CHECK PENDING ? | | 2 |
| what is a collection? | | 2 |
| what are the frequent DB2 abends did you encounter in your
programs ?? What are different SQL abends ?? | Xansa | 2 |
| What is a DBRM, PLAN ? | | 1 |
| what is consistency token | | 1 |
| Once you create a view, where would information about the
view be stored? | | 1 |
| What is the function of buffer manager? | | 1 |
| What is UNION,UNION ALL? | | 1 |
| What is COPY PENDING status? | | 4 |
| There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........ | IBM | 6 |
| Can we declare DB2 HOST variable in COBOL COPY book? | | 1 |
| |
| For more DB2 Interview Questions Click Here |