DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 15348

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 9328

If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?

2 6331

how to fetch multiple records without using cursor

HCL,

14 39609

what is datacom db?

CSC,

2 8271

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,

9 14287

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'

Amdocs,

10 16393

Can we use select * statement in cobol program without giving field names ???

Zensar,

3 11750

why we create view.

5 10156

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 10561

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!

KNIT, Tech Mahindra,

17 27207

What are the functions in DB2?

Satyam,

3 9408

How to know the primary key of a table without defining the primary key in the table?

Satyam,

5 15349

can we drop column from a table

INDUS,

7 21108

How to get Top 10 Salaries from a Table

Accenture, HTC,

11 28086

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain db2.

1034

What is table space in db2?

1017

What is dbrm? What it contains? When it will be created?

1050

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

What is the difference between using bind () and rebind () methods of naming class?

1398

What is a storage group (stogroup)?

1246

What is blu acceleration in db2?

1069

What is the difference between bind and rebind in db2?

1450

What is the clustering index in the db2 database?

1001

How connect db2 database to datastage?

1242

Can you use max on a char column?

1097

How do I copy a table in db2?

1000

What is precompiler in db2?

1018

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2065

What's The Error Code For Unique Index Voilation?

1238

For More Un-Answered { DB2 } Questions Click Here