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 14135

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 7791

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

2 5269

how to fetch multiple records without using cursor

HCL,

14 34788

what is datacom db?

CSC,

2 6716

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 11164

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 13339

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

Zensar,

3 10308

why we create view.

5 8491

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 8640

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 22269

What are the functions in DB2?

Satyam,

3 7907

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

Satyam,

5 13132

can we drop column from a table

INDUS,

7 17863

How to get Top 10 Salaries from a Table

Accenture, HTC,

11 24275


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is buffer pool and list some of them?

603


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1689


What is a db2 tablespace?

572


What is the physical storage length of date data type?

695


What is a db2 schema?

740






what is a corelated subquerry?

629


How to check sequence on a table in db2?

582


What is dclgen (declaration generator)?

581


Where do you specify them?

659


What does a deadlock mean in DB2?

630


Which command is used to remove all rows from a table?

534


What is db2 catalog database?

558


What is a cursor in programming?

566


is it compulsory commitment control in journal?

1990


Which component is responsible for processing sql statements and selecting access paths?

624