1.

What types of tables are there in the DB2 database?

Answer»

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.


Discussion

No Comment Found

Related InterviewSolutions