Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 3675

What is meant by the attachment facility?

3 7722

What is a Cartesian product?

2 8651

What is DCLGEN ?

2 4948

Can we declare DB2 HOST variable in COBOL COPY book?

2 8934

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

2 16510

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

1 4503

max number of columns in a db2 table?

6 21773

Can you access the DB2 Directory table using SQL?

3 5855

What is correlation names?

1 3575

What is an alias?

3 4187

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 4653

What is the difference between Where and Having Clause

IBM, iFlex,

7 26599

Which transaction use a command thread ?

1 2785

What is a LIKE table and how is it created?

2 4114


Post New DB2 Questions

Un-Answered Questions { DB2 }

How can record locking be achieved in those DB2 versions which do not support it?

450


what is a corelated subquerry?

470


What is ibm db2 used for?

437


What is the reason behind not using select * in embedded sql programs?

438


What is difference between alias and synonym in db2?

426






What is a storage group (stogroup)?

544


What is declare cursor?

428


What type of database is db2?

372


Define declaration generator (dclgen).

507


What is the maximum No of rows per page?

478


What is db2 instance?

438


What is a Foreign Key?

472


What is check constraint. Explain with example.

485


When do you specify the isolation level?

441


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

463