1-- SET TABLE 2-- MULTISET TABLE 3-- GLOBAL TEMPORARY TABLE 4-- VOLATILE

What are the types of tables in Teradata

Question Posted / raghavender

Answer Posted / raghavender

1-- SET TABLE
2-- MULTISET TABLE
3-- GLOBAL TEMPORARY TABLE
4-- VOLATILE TABLE
5-- DERIVED TABLE

Is This Answer Correct ?

11 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is a level of granularity of a fact table?

1096

What do you mean by teradata sql assistant?

1017

Highlight the need for Performance Tuning.

1060

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

1051

What are the multiload utility limitations?

1015

Name the five phases that come under MultiLoad Utility.

947

What is the use of fallback?

957

What are the functions of a Parser?

1057

Steps to create a data model?

1085

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1910

what is sysdba and sysdbc ? which has high priority ?

3786

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

951

Explain vproc in teradata?

951

Explain the term 'foreign key' related to relational database management system?

981

What is the difference between teradata and oracle?

980