How does one remove entries from the SCT02 table?

Question Posted / guest

How does one remove entries from the SCT02 table?..

When a plan is dropped it removes the entries from SCT02
table.

Is This Answer Correct ?

3 Yes

0 No

More DB2 Interview Questions

What are the contents of dclgen?

What is db2 bind process?

What is the specific need of Plan and..where are the tables in DB2 are physically saved

How do you check for a null value in a db2 column?

what is rebinding ?

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

Can a Db2 table data be retrived through JCL?

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

What is buffer pool?

define clustering index.

Can you tell me how can you find out the # of rows updated after an update statement?

How do you simulate the explain of an embedded sql statement in spufi/qmf?

For more DB2 Interview Questions Click Here