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 Best Interview Question ON 09 Feb 2019