Mention the location where the output received from explain statement is stored.

Question Posted / preetik singh

No Answer is Posted For this Question
Be the First to Post Answer

More DB2 Interview Questions

What action db2 takes when a program aborts in the middle of a transaction?

How we create a tables in db2,what is the process/syntax to create a table with example plz?

For Read Stability locks are not applicable for phantoms, What is Phantoms?

Is ibm db2 open source?

Which are the db2 tools to protect integrity of the database?

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

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?

How do you insert a record with a nullable column?

i want to delete 20th million record how ?

What is a view? Why use it?

The only place of VSAM KSDS in DB2 is?

How does DB2 store NULL physically?

For more DB2 Interview Questions Click Here