Answer Posted / pratima reddy

Hi Mahaboob,

Can you please send me the dumps for TE0-12Q and TE0-127 to
my mail: Pratimareddy5@gmail.com

Why teradata is used?

1008

---

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

1109

---

Name the five phases that come under MultiLoad Utility.

988

---

How is the teradata different from oracle?

1116

---

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2165

---

Explain the advantages of partitioned primary index in a query?

1028

---

What are the different methods ot loading a dimension table? A fact table etc?

1036

---

What is bteq script in teradata?

1155

---

What is real time and near real time data warehousing?

1118

---

Explain teradata utilities. What is multiload, fast load, tpump?

1008

---

What is primary index and secondary index?

1028

---

What is basic teradata query language?

1117

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1203

---

What are the functions of a Parser?

1113

---

Can we collect statistics on table level?

1036

---