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 BIQ ON 09 Feb 2019
View Suggestions OR Post Your Suggestion

Suggest An Answer

No suggestions Available!
More Interview Questions from Database
SQL Interview Questions MySQL Interview Questions
DBMS Interview Questions Rdbms Interview Questions
MongoDB Interview Questions SQLite Interview Questions
Oracle Interview Questions MariaDB Interview Questions
SAP Hana Interview Questions Teradata Interview Questions