1-- SET TABLE 2-- MULTISET TABLE 3-- PERMANANT TABLE 4-- GLOBAL TEMPORAR

What are the types of tables in Teradata

Question Posted / preeti

22 Answers
78737 Views
Cap Gemini, Cognizant, Infosys, I also Faced
E-Mail Answers

Answer Posted / preeti

1-- SET TABLE
2-- MULTISET TABLE
3-- PERMANANT TABLE
4-- GLOBAL TEMPORARY TABLE(TEMPORARY TABLE)
5-- VOLATILE TABLE
6-- DERIVED TABLE
7--INTERIM TABLES

Is This Answer Correct ?

25 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1119

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

2176

What is upsert statement in teradata?

1144

Can we collect statistics on multiple columns?

1072

How can bottlenecks be identified?

1026

What do you mean by parsing?

1122

In Teradata, how do we Generate Sequence?

1054

Define views in teradata with general syntax.

1041

Why managing the data is important?

1022

Explain teradata utilities?

1052

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2193

How can you track login parameters of users in teradata?

1201

Explain teradata vs. Redshift?

1035

If RDBMS is halted what will you do ?

2179

What are the frequently used data types in teradata?

1093