When is the skeleton cursor table created?

Question Posted / guest

When is the skeleton cursor table created?..

Skeleton cursor table is created when a new plan is bound.

Is This Answer Correct ?

3 Yes

0 No

More DB2 Interview Questions

What is rct?

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

Is the primary key a clustered index?

Are views updatable ?

What are the three types of page locks that can be held?

What are packages in db2?

How do I add a column to an existing table in db2?

What is the SQL query to select, delete and get count of duplicate rows in DB2?

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

What is isolation level in db2?

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

For more DB2 Interview Questions Click Here