DB2 Interview Questions
Questions Answers Views Company eMail

Update command

1 3607

What is cursor?

2 4558

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

UST,

2 6469

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 3259

what is the responsibility of the construction superintendent

Almco,

1644

What is difference between *omit and *nopass?

IBM, TCS,

1 6872

How to find last record before record through SQLRPGLE?

IBM,

1 8648

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

IBM,

1 4529

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

Accenture,

1 3374

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

Accenture,

1 5650

How to resolve deadlock issue

IBM,

5 17823

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

HSBC, IBM,

2 8687

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 8483

what is the use of cursors?

iGate,

3 6002

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 7186


Post New DB2 Questions

Un-Answered Questions { DB2 }

List down the types of triggers in the db2 database?

567


What are the rules for db2 programming?

622


What is meant by explain?

638


How to execute stored procedures?

604


Who uses db2?

551






What is the use of with ur in db2?

591


What is the difference between spufi and qmf?

618


What parameters are used to control the free space in DB2?

621


What is runstats and reorg in db2?

763


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

613


Highlight all the advantages that are attached to a package.

603


What is explain in db2?

563


How to resolve deadlock issue

17823


Explain how can you do the explain of a dynamic sql statement?

629


What is the maximum No of rows per page?

606