Following are the types: VOLATILE TABLES,DERIVED TABLES,GLOBAL TEMPORARY

What are the types of tables in Teradata

Question Posted / tdguy

Answer Posted / tdguy

Following are the types:

VOLATILE TABLES,DERIVED TABLES,GLOBAL TEMPORARY TABLES,
SET/MULTISET TABLES

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How is the teradata different from oracle?

1167

In Teradata, how do we Generate Sequence?

1092

What are the functions involved in shared information architecture?

1124

While creating table my dba has fallback or no fallback in his ddl. What is that?

1243

What are the different design perspectives used in teradata?

1036

Highlight a few of the important components of Teradata?

1078

What is meant by a node?

1078

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

1110

What is inner join and outer join?

1180

What is the difference between global temporary tables and volatile temporary tables?

1242

What is the use of having index on table?

1043

What are the components used in smp and massively parallel processing (mpp) machines?

1097

What are the uses of bynets in multi-node systems?

1074

How to view every column and the columns contained in indexes in teradata?

1101

What are the various reporting tools in the market?

1117