Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

What is query for your birthday date should be in hours,minute and seconds format?

Fidelity,

1 6201

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

HCL,

1 4302

how do you resolve -805?

HCL,

3 7331

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

Fidelity,

10 9582

how to unload different table data into different gdg files/ vsam files.

3 7807

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

Tech Mahindra, Wipro,

2 12933

WHAT IS MEANT BY COMMIT COMMAND?

Wipro,

7 7337

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

CTS,

4 11163

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

CTS, IBM,

3 17163

select distinct(empid),distinct(dept),name from EMP will the above query work?

CTS,

2 6940

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

CTS,

3 6272

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

CTS, IBM,

4 8298

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 4866

my project is insurance management system,how to explain my work environment in interview?

CGI, Value Labs,

2 6674

What is db2 isolation?

2 5608


Post New DB2 Questions






Un-Answered Questions { DB2 }

Differentiate between cs and rr isolation levels? Where do you specify them?

222


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

243


Who uses db2?

218


Why select is not preferred in embedded sql programs?

269


What types of tables are there in the db2 database?

238






How do you retrieve the first 5 characters of firstname column of db2 table emp?

284


What is with ur in db2?

184


Explain in detail about buffer manager and its functionalities?

234


How do I delete a column in db2?

206


How to find the number of rows in a db2 table?

245


How will you return the number of records in table?

175


Mention the location where the output received from explain statement is stored.

246


Define predicate?

264


Is db2 relational database?

202


What is meant by explain?

266