What types of tables are there in the DB2 database?

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.