Answer Posted / rajashree

Hi,
Please send me the dumps at rajashreemamulu@gmail.com

Thank you.

Explain some differences between mpp and smp?

1109

---

What is multi insert?

1058

---

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

2416

---

Differentiate primary key and partition key?

986

---

List out all forms of LOCKS that are available in Teradata.

969

---

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

1111

---

Explain teradata architecture in detail with a diagram.

1115

---

What is the difference between teradata and basic rdbms?

1031

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

991

---

How can you track login parameters of users in teradata?

1198

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2482

---

What are the enhanced features in teradata v2r5 and v2r6?

1138

---

What is called partitioned primary index (ppi)?

1013

---

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

1058

---

Which is faster fastload or multiload?

1121

---