There are three types of tables in the DB2 database:-

  • Base Tables-These tables hold the persistent data
  • Temporary Tables-These tables are used for the temporary work of the database operations
  • Materialized Query Tables-These tables are used to increase the performance of queries

Point to be noted: Make sure that you go through this twice as this is the favorite db2 dba interview questions for fresher and experienced as well.

BY Admin ON 09 Feb 2019
View Suggestions OR Post Your Suggestion

Suggest An Answer

No suggestions avaliable!