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 do you manage the production space. what are the proactive methods you can take ?

1983

What are differences between teradata and ansi session modes in teradata?

1222

What are the design features involved in teradata?

1118

Describe primary index in teradata. And what are the available primary index types?

1044

What are the scenarios in which full table scans occurs?

1054

Explain teradata utilities. What is multiload, fast load, tpump?

1049

What is the multi-insert?

1084

Which is faster fastload or multiload?

1183

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

2243

How you will check the version of teradata?

1226

Describe the set operators in teradata.

1050

Highlight the advantages of PPI(Partition Primary Index).

1130

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1215

Differentiate database data and data warehouse data?

1163

What are the multiload utility limitations?

1115