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

DB2 Interview Questions

Questions Answers Views Company eMail

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 5042

What is meant by the attachment facility?

3 9365

What is a Cartesian product?

2 10246

What is DCLGEN ?

2 6224

Can we declare DB2 HOST variable in COBOL COPY book?

2 10480

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 18862

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 5627

max number of columns in a db2 table?

6 25055

Can you access the DB2 Directory table using SQL?

3 7647

What is correlation names?

1 4845

What is an alias?

3 6306

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 6573

What is the difference between Where and Having Clause

IBM, iFlex,

7 30492

Which transaction use a command thread ?

1 3804

What is a LIKE table and how is it created?

2 5507

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is concurrency?

1234

How to rename a table in DB2 ?

1088

How does coalesce work?

1023

What is dclgen (declaration generator)?

1059

Explain in detail about buffer manager and its functionalities?

1066

What is dbrm? When it will be created?

1029

Are view updateable?

1043

How to execute stored procedures?

1130

what is diffrence b/w file-aid tool and file-aid utility???

4892

How do I create a view in db2?

1024

What is a cursor in programming?

1069

Can we update view in db2?

1003

What is the use of db2 optimizer?

1117

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107

How can you quickly find out the # of rows updated after an update statement?

1049

For More Un-Answered { DB2 } Questions Click Here