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 is sysdba and sysdbc ? which has high priority ?

3886

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1161

---

What is the use of fallback?

1037

---

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

1100

---

What is smp and mpp platforms?

1037

---

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

1124

---

Can you connect multiload from ab initio?

1284

---

Highlight the need for Performance Tuning.

1157

---

In general, how do you optimze any sql in teradata?

1090

---

Which is faster fastload or multiload?

1183

---

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

1149

---

What can be achieved by using the teradata rdbms?

1092

---

In the Primary Index, what is the score of AMPs that are actively involved?

1129

---

What is logical data model?

1260

---

Difference between stored procedure and macro?

1222

---