1.

How Many Types Of Tables Exists And What Are They In Data Dictionary?

Answer»

4 types of tables

  1. Transparent tables : Exists with the same structure both in dictionary as well as in database exactly with the same data and FIELDS. Both Open sql and Native sql can be USED.
  2. Pool tables
  3. Cluster tables : These are LOGICAL tables that are arranged as records of transparent tables. one cannot use native sql on these tables (only open sql).They are not manageable directly using database SYSTEM tools. 
  4. Internal tables.

4 types of tables


Discussion

No Comment Found

Related InterviewSolutions