| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Is it mandatory to use DCLGEN? If not, why would you use it
at all? | | 1 |
| What are data types? | | 1 |
| What is the difference between static and dynamic SQL? | | 1 |
| what is the process of precompiler? | | 2 |
| What is SPUFI? | | 1 |
| In a DB2-CICS program which is acts as co-ordinator and
which is participant? | | 1 |
| What is the SQL Communications Area and what are some of
its key fields? | | 1 |
| What is sqlcode -922 ? | | 1 |
| can we drop column from a table | INDUS | 4 |
| What do you need to do before you do EXPLAIN? | | 1 |
| When will you chose to run RUNSTATS? | | 1 |
| How would one remove old reorg information from the DB2
catalog? | | 1 |
| Where is the access path logic created by the DB2 Optimizer
stored? | | 1 |
| What is the difference between base table and view? | | 3 |
| 4. A DB2 application is bound with uncommitted Read
isolation level.It issues a request that retrieves 20 rows
out of 200000 in the table.
Which of the following descrbes the rows that are locked
as a result of this request?
a. None of the rows are locked.
B.The retrieved rows are locked.
C.The last row of the result set is locked.
D.The rows not previously updated by another application
are locked.
| Wipro | 3 |
| Say CUST Table contains records like:
CUSTNO CUSTNAME CUSTLOC
100 ABC SSS
200 XYZ
300 PQR
400 MNO WWW
500 CVV
-------------
-------------
Now write a query to retrieve all records with CUSTLOC no
data.
| IBM | 2 |
| What does CURRENTDATA option in bind indicate | | 1 |
| What is the purpose of the DSNC transaction ? | | 1 |
| What is a DB2 access path? | | 1 |
| How do you retrieve the data from a nullable column? | | 2 |
| |
| For more DB2 Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
