TEMPORARY TABLES 1. Global Temporary Table 2. Derived Table 3. Volatile

What are the types of tables in Teradata

Question Posted / ramya

Answer Posted / ramya

TEMPORARY TABLES
1. Global Temporary Table
2. Derived Table
3. Volatile Table

PERMANENT Table

1. SET Table
2. MULTISET Table

Is This Answer Correct ?

16 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to select first n records in teradata?

1067

What are the available primary index types?

1170

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1126

Syntax for case when statement?

1025

Explain fallback in teradata?

1008

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2124

What is partitioned primary index (ppi)?

1020

if collect stats but it show low confidence why?

1648

What is the purpose of upsert command?

1114

What is the meaning of Caching in Teradata?

1102

How is MLOAD Teradata Server restarted after execution?

1198

How many types of joins are there in teradata?

933

What is the difference between union and union all in teradata?

1085

Why teradata is used?

957

What are some commonly used bteq scripts?

967