Permanent Table Set Table Multi Set Table derived Table Volatile Table

What are the types of tables in Teradata

Question Posted / kishore

Answer Posted / kishore

Permanent Table
Set Table
Multi Set Table
derived Table
Volatile Table
Global temporary Table
Error Table
Queue Table
temporal Table(from TD13.10)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

During the Display time, how is the sequence generated by Teradata?

1049

Can you connect multiload from ab initio?

1207

Difference between multiload and tpump?

1097

What are the advantages of teradata?

1010

how can we analyze the locks ?

2124

How do you determine the number of sessions?

1059

Explain the term 'columns' related to relational database management system?

1062

What are the available primary index types?

1208

Explain the term 'tables' related to relational database management system?

1043

How does hashing happens in teradata?

1082

What is called partitioned primary index (ppi)?

1006

How to find duplicates in a table?

1205

What do high confidence, low confidence and no confidence mean in explain plan?

1043

What are the available primary index types in teradata.

1029

What is the purpose of using case expression in teradata?

1013