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.

Suggest An Answer