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

DB2 Interview Questions

Questions Answers Views Company eMail

Update command

1 4516

What is cursor?

2 5646

Request to database but database is not available so what is was abend is raised?

UST,

2 7625

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 4121

what is the responsibility of the construction superintendent

Almco,

2144

What is difference between *omit and *nopass?

IBM, TCS,

1 7716

How to find last record before record through SQLRPGLE?

IBM,

1 9439

how to execute qcmdexc in rpgle?plz write code also?

IBM,

1 5363

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

Accenture,

1 4347

My SQL is not performing well. Describe how will you fine tune it?

Accenture,

1 6661

How to resolve deadlock issue

IBM,

5 20121

can any body explain about plan and pakage in detail....

HSBC, IBM,

2 9899

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

ADP,

4 10173

what is the use of cursors?

iGate,

3 7424

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

iGate,

2 8425

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to check table size in db2 sap?

1039

Discuss about db2 bind?

1097

Explain the contents that are a part of dclgen.

1091

How to resolve deadlock issue

20121

What is bind in db2?

1042

How to view db2 table structure?

1017

Why cursor is used in db2?

1036

Explain in detail about buffer manager and its functionalities?

1065

Explain db2.

1034

Explain about cursor stability?

1050

Explain the contention situations caused by locks?

1070

Can we update view in db2?

1002

What is a buffer in memory?

1058

Explain the function of data manager.

1044

Explain about rct in db2?

1109

For More Un-Answered { DB2 } Questions Click Here