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.