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

Explain the new features of teradata?

1032

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1236

What is meant by a Highest Cost Plan?

1058

What is collect statistics?

996

What is oltp?

972

How many sessions of MAX is PE capable of handling at a particular time?

1079

What are the various etl tools in the market?

1069

What is a node in teradata?

993

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

949

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

1108

What are the uses of client software involved in teradata?

982

What is the function of parser component in teradata?

1080

What are different table types used in teradata?

1037

What are the various indexes in teradata?

1044

What happens in a conflict? How do you handle that?

1044