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
5 VOLATILE TEMPORARY TABLES
These are the five kind of tables.

What are the steps involved after the disk manager passes the request?

1111

---

What is the multi-insert?

1026

---

What is meant by a Least Cost Plan?

1057

---

What is meant by a dispatcher?

1013

---

what is sysdba and sysdbc ? which has high priority ?

3827

---

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

1170

---

What are default access rights in teradata? What explicit right can be given to a user?

1108

---

What are the advantages of teradata?

1010

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1166

---

What are the 5 phases in a multiload utility?

1031

---

What is the use of virtual processor connectivity in teradata?

1009

---

Which is faster fastload or multiload?

1105

---

What are the frequently used data types in teradata?

1076

---

How to load specific no.of records using bteq, or fastload,or multiload

1745

---

Highlight the points of differences between the database and user in Teradata.

1106

---