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 5058

What is meant by the attachment facility?

3 9373

What is a Cartesian product?

2 10260

What is DCLGEN ?

2 6235

Can we declare DB2 HOST variable in COBOL COPY book?

2 10491

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

2 18874

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

1 5633

max number of columns in a db2 table?

6 25069

Can you access the DB2 Directory table using SQL?

3 7662

What is correlation names?

1 4854

What is an alias?

3 6320

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 6580

What is the difference between Where and Having Clause

IBM, iFlex,

7 30510

Which transaction use a command thread ?

1 3811

What is a LIKE table and how is it created?

2 5516

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to check sequence on a table in db2?

1068

Which isolation level provides highest data integrity?

1127

How to fetch the last row from the table in SQL (db2)?

1658

What is buffer pool?

1110

Define data page.

1075

What is database reorganization?

1135

Which is faster delete or truncate?

1134

What is dclgen (declaration generator)?

1066

Name the various locking levels available?

1101

What are the 2 sqlcodes that are returned?

1196

What is the use of dclgen in db2?

1085

What's The Error Code For Unique Index Voilation?

1244

Explain the contents that are a part of dclgen.

1093

What is a collection in db2?

1042

What is a page in db2?

1029

For More Un-Answered { DB2 } Questions Click Here