Answer Posted / krishna

Hi Vinay ,Sheela and All

I am Krishna working as a teradata dev in MNC.
First I like to Convey a very big thanks to Vinay and his
students Team.
I visited his blog few days back its Realy Awesome.I agree
this Teradata typical questions 1,2,3 covered entire
interview questions in one shot.
Vinay we expect more and more from you and your Team.

Thanks in Advance

Krishna

What is called partitioned primary index (ppi)?

1000

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1080

---

What is the command in bteq to check for session settings ?

1165

---

What are the functions of a teradata dba?

1062

---

Why is the case expression used in teradata?

1064

---

What is the difference between global temporary tables and volatile temporary tables?

1149

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1761

---

What do you mean by teradata intellicloud?

1020

---

What is a clique?

1071

---

What are the different table types that are supported by teradata?

987

---

Explain the term 'tables' related to relational database management system?

1020

---

What do you mean by caching in teradata?

1035

---

Explain the types of join supports by teradata?

976

---

When tpump is used instead of multiload?

1085

---

What are the components provided on node?

1020

---