| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What does the sqlcode of -818 pertain to? | | 2 |
| What is a synonym ? | | 1 |
| What is a DB2 access path? | | 1 |
| What techniques are used to retrieve data from more than
one table in a single SQL statement? | | 2 |
| What does the REORG Utility do? | | 1 |
| what is the name of the default db2 catalog database? | | 1 |
| What is JOIN and different types of JOIN. | | 2 |
| What is the difference between static and dynamic SQL? | | 1 |
| What is a precompiler? | | 1 |
| Are views updatable ? | | 3 |
| What is auditing? | | 1 |
| what are extents? | | 3 |
| What is UNION,UNION ALL? | | 1 |
| What's the Maximum Length of SQLCA and what's the content
of SQLCABC? | | 2 |
| How many buffer pools are available in db2? | | 2 |
| How do u achieve record level locking in DB2 versions when
record level locking is not allowed? | | 2 |
| When will you chose to run RUNSTATS? | | 1 |
| In a DB2-CICS program which is acts as co-ordinator and
which is participant? | | 1 |
| How is a typical DB2 batch program executed ? | | 1 |
| How do you retrieve the data from a nullable column? | | 2 |
| |
| For more DB2 Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map