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

What is teradata and why it is used?

582

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

597

What are the primary characteristics of the Teradata.

586

Difference between multiload and tpump?

617

What is the purpose of upsert command?

589

How many codd's rules are satisfied by teradata database?

660

Explain teradata architecture in detail with a diagram.

613

What is a dimension table?

608

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

587

What is a level of granularity of a fact table?

637

What is partitioned primary index (ppi)?

565

What is the maximum number of dml can be coded in a multiload script?

619

What are the advantages of teradata?

598

What is meant by a Parsing Engine?

705

How to run a query in teradata?

581