How does one remove entries from the SCT02 table?



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

Answer / s

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

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

How would you find out the total number of rows in a db2 table?

0 Answers  


What is the default page size of buffer pools?

0 Answers  


What is the use of dclgen in db2?

0 Answers  


What is cursor in dbms?

0 Answers  


db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  






Which catalog table stores referential constraints?

1 Answers  


What is the role of the data page in the db2 database?

0 Answers  


in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,


what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,


What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  


What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,


What is the maximum No of rows per page?

0 Answers   IBM,


Categories