Answer Posted / vinay

as far as i my knoweledge goes we have ,correct me if i am
wrong.

1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
and there is one more i reckon which i cant remember.

What are the joins in teradata?

987

---

What is the difference between union and union all in teradata?

1119

---

What are the 5 phases in a multiload utility?

1031

---

Different phases of multiload?

995

---

During the Display time, how is the sequence generated by Teradata?

1049

---

What is meant by a Virtual Disk?

1124

---

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

1950

---

Why teradata is used?

997

---

What are the different functions included in the server software?

1028

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

985

---

What is a clique?

1082

---

What are the string manipulation operators and functions associated with teradata?

1083

---

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

949

---

What is partitioned primary index (ppi)?

1046

---

What are tpump utility limitations?

1118

---