1-- SET TABLE 2-- MULTISET TABLE 3-- PERMANANT TABLE 4-- GLOBAL TEMPORAR

What are the types of tables in Teradata

Question Posted / rd

Answer Posted / rd

1-- SET TABLE
2-- MULTISET TABLE
3-- PERMANANT TABLE
4-- GLOBAL TEMPORARY TABLE(TEMPORARY TABLE)
5-- VOLATILE TABLE
6-- DERIVED TABLE

Is This Answer Correct ?

9 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Difference between inner join and outer join?

1019

What are the different softwares used with their functions in teradata?

1015

Can we collect statistics on table level?

1024

Explain fastload in teradata?

1098

What are teradata utilities?

1107

In the Primary Index, what is the score of AMPs that are actively involved?

1071

What are the main components of teradata system?

1125

What are default access rights in teradata? What explicit right can be given to a user?

1108

What is meant by a Channel Driver?

1237

Highlight the advantages of PPI(Partition Primary Index).

1072

What are the joins in teradata?

987

How can bottlenecks be identified?

1011

What are the various indexes in teradata?

1044

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1195

What are the various indexes in teradata? How to use them? Why are they preferred?

1061