Answer Posted / manish

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

Thank you.

What are the various indexes in teradata? How to use them?

992

---

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

1093

---

What is meant by a node?

1032

---

Syntax for case when statement?

1043

---

What do high confidence, low confidence and no confidence mean in explain plan?

1035

---

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

1145

---

What is multi insert?

1032

---

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

990

---

What are the 5 phases in a multiload utility?

1018

---

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

965

---

Different phases of multiload?

978

---

Explain Teradata performance tuning and optimization?

1144

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2189

---

What is the difference between teradata and oracle?

1003

---

Which is more efficient group by or distinct to find duplicates?

1070

---