| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a lock? | | 1 |
| db2 query
I have one table with the following details.
SNO SNAME DOJ
------ -------------------- ----------
10 KRISH 2007-03-19
20 REDDY 2007-05-19
30 RRRRR 2007-05-19
40 BBBBB 2008-05-19
50 CCCCC 2009-05-19
60 JJJJJ 2009-05-19
70 JJJJJ 2004-05-19
i want the output in the following format:( no of students
joined in each year(no nedd to consider about month and
date)
year count
--------- ----------
2004 1
2007 3
2008 1
2009 2
| TCS | 6 |
| How does DB2 store NULL physically? | | 1 |
| What is RUNSTATS? | | 1 |
| Where could you look if you had a question about whether a
column has been defined as an index? | | 2 |
| Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time? | | 1 |
| I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP! | Tech-Mahindra | 10 |
| What is an intent lock? | | 1 |
| What is a host variable? | | 1 |
| I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again). | Wipro | 5 |
| what is copy pending and check pending ? | Xansa | 1 |
| what is commit & rollback? When and where is used while
compiling a cobol-db2 program? | | 2 |
| What is pagespace? | | 1 |
| How to resolve the -305 error code in DB2?
And also please let me know, how to resolve the db2 error
codes. | TCS | 5 |
| What is meant by AUTO COMMIT? | | 2 |
| Where are plans stored? | | 2 |
| What is the purpose of the WHENEVER statement? | | 1 |
| What is the difference between primary key & unique index ? | Patni | 2 |
| what will be the output of the below given query, if no
matching records are found : (a.) 0 (b.) null (c.) error
select Avg(salary)
from TableA
where Deptno = 'insurance' | AMDOC | 4 |
| What is DCLGEN ? | | 1 |
| |
| For more DB2 Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map