There have four table types supported in Teradata:
  • Permanent Table: It’s the default table and contains data put by the user and stores that data permanently.
  • Global Temporary Table: Persistent but the data present in the table will be deleted at the end of the user session.
  • Volatile Table: The data into this table is retained only during the user session.
  • Derived Table: It holds the intermediate results in a query. The lifetime of this table depends on the query in which they are created, dropped and used.

This is a fundamental question in teradata interview questions.

BY Best Interview Question ON 06 Mar 2019