Answer Posted / yuvaevergreen

VOLATILE TABLES - Occupies spool space - Data/Definition
dropped when the session ends or user drops it.
DERIVED TABLES - Occupies spool space - Data dropped as
soon as the query ends.
GLOBAL TEMPORARY TABLES - Occupies temporary space - Data
dropped as soon as the user deletes or session ends -
Definition stored permanently in the DD.
SET/MULTISET TABLES - Occupies permanent space -
Data/Definition retained until user deletes it.

What are the available join types in teradata?

1068

---

What is the purpose of joins in teradata and what are the available join types?

1087

---

If a Node is busy what are the steps you can take to avoid ?

2416

---

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

1043

---

What are some commonly used bteq scripts?

1012

---

What do high confidence, low confidence and no confidence mean in explain plan?

1048

---

Highlight a few of the important components of Teradata?

1030

---

What are the functions involved in shared information architecture?

1073

---

What are the design features involved in teradata?

1058

---

Discuss the advantages of using partitioned primary index in a query?

954

---

Explain amp in teradata?

1085

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1024

---

What is teradata? Also, list out some of the primary characteristics of teradata.

1060

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

---

Is multi insert ansi standard?

2207

---