Answer Posted / venkatarayudu gutta

as per my knowledge we have,correct me if i am wrong
1.permanent table
2.set table
3.multiset table
4.derived table
5.error table
6.volatile table
7.global temporary table
and two more we have
8.queue table
9.temporal table(released in TD14)

Describe the between keyword in teradata?

1086

---

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

1049

---

What is a clique?

1156

---

What does Amp contain and what are all the operations that it performs?

1055

---

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

1119

---

What are the various reporting tools in the market?

1116

---

What is the multi-insert?

1084

---

How do you determine the number of sessions?

1109

---

What are the multiload utility limitations?

1115

---

Explain fastload in teradata?

1147

---

How to view every column and the columns contained in indexes in teradata?

1101

---

What does sleep function does in fast load?

1212

---

What are the functions of a Parser?

1190

---

What are the uses of bynets in multi-node systems?

1074

---

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

2458

---