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 5140

What is meant by the attachment facility?

3 9471

What is a Cartesian product?

2 10322

What is DCLGEN ?

2 6322

Can we declare DB2 HOST variable in COBOL COPY book?

2 10586

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

2 18971

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

1 5697

max number of columns in a db2 table?

6 25236

Can you access the DB2 Directory table using SQL?

3 7768

What is correlation names?

1 4935

What is an alias?

3 6417

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 6675

What is the difference between Where and Having Clause

IBM, iFlex,

7 30717

Which transaction use a command thread ?

1 3881

What is a LIKE table and how is it created?

2 5596

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is database alias db2?

1177

What is the meaning concurrency in the db2 database?

1160

What is a db2 table?

1064

What is rct?

1287

What is the syntax for seeing the columns and data types of a table in the db2 database?

1230

What is the difference between drop table and delete table?

1284

Mention the location where the output received from explain statement is stored.

1167

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2292

How do I delete a column in db2?

1152

What is bind package and plan in db2?

1103

Explain the contention situations caused by locks?

1141

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1311

What is buffer pool and list some of them?

1091

What is a system catalog table in db2?

1240

What is load replace in db2?

1043

For More Un-Answered { DB2 } Questions Click Here