DB2 interview questions – page 8

How to enter in xpediter?

Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement

How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.

How many clustering indexes can be defined for a table?

What are the contents of a DCLGEN?

Why use RUNSTAT Utility?

What is the difference between off-line back up and on-line back up in ibm db2 udb?

What is the soft code for deadlock ?

How do I handle -911 (deadlock) error in a db2 program sothat the program will never abend?

Wht happens if we close cursor with cursor with hold option?

I have 1000 rows in a db2 table.I want to update first 100records,How do I do it?

How do you fetch current date in normal cobol pgm and incobol-db2 pgm?

What is the difference between IN subselects and EXISTS subselect?

The dd name for ksds is dest1 and what is the dd name for alternate index of ksds ?a.dest b.dest1 c.dest1a d.dd1

Select 100 records from million records ?

Delete rules in db2

Db2 restart logic ?

What are the SQL codes u freequently got?

How many partitions are possible in partitioned tablespace?dont say 1-64.a)240b)256c)512d)none

How to compile PL/1 DB2 program? Please provide me details on this process?

What is main use of table space and index object?please its urgent

What is COPY PENDING status?

Explain the function of Data Manager?