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 4519

What is cursor?

2 5647

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

UST,

2 7627

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 4125

what is the responsibility of the construction superintendent

Almco,

2147

What is difference between *omit and *nopass?

IBM, TCS,

1 7722

How to find last record before record through SQLRPGLE?

IBM,

1 9443

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

IBM,

1 5367

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

Accenture,

1 4349

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

Accenture,

1 6662

How to resolve deadlock issue

IBM,

5 20133

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

HSBC, IBM,

2 9900

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 10180

what is the use of cursors?

iGate,

3 7428

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 8428

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to connect to db2 database from windows command line?

1066

What is sqlca’s maximum length?

1189

How does db2 sample database connect?

1030

What is null in db2?

1026

What is the maximum length of sqlca?

1529

What is a plan and package in db2?

1104

What is bind in db2?

1044

How can deadlocks be resolved?

937

How is the value function used?

1154

What is the role of data manager in the db2 database?

1109

What is dclgen in db2?

1149

Explain packages.

1113

What is lock escalation in db2?

1033

What is check constraint. Explain with example.

1109

How many databases are there?

1054

For More Un-Answered { DB2 } Questions Click Here