| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What technique is used to retrieve data from more than one
table in a single SQL statement? | CTS | 3 |
| What are simple, segmented and partitioned table spaces ? | | 1 |
| What does DML stand for and what are some examples of it? | | 1 |
| What is a Database Request Module(DBRM)? | | 2 |
| What are the three DB2 date and time data types and their
associated functions? | | 1 |
| How to know the primary key of a table without defining the
primary key in the table? | Satyam | 1 |
| What are the contents of a DCLGEN? | MetLife | 2 |
| What is ALTER ? | | 2 |
| What are the three types of page locks that can be held? | | 1 |
| What is FREEPAGE and PCTFREE in TABLESPACE creation? | | 1 |
| What is a base table? | | 2 |
| What is the FREE command? | | 1 |
| What is a lock? | | 1 |
| what is copy pending and check pending ? | Xansa | 1 |
| What is sqlcode -922 ? | | 1 |
| What information can you find in SYSIBM.SYSLINKS table? | TCS | 1 |
| When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored? | | 2 |
| How to define the data items to receive the fetch items for
the SQL? | | 1 |
| How many Buffer pools are there in DB2 and what are they? | | 1 |
| How does DB2 store NULL physically? | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Site Map