Answer Posted / shaik mahamad rafi

Teradata Oracle
--------------------------------------------------------------1 shared nothing architecture 1>shared pool architecture
2 Index's Parallel Distribution 2>Sequence distribute
3 No need to maintain Index's as 3>dba must maintain index's
dba
4 MIPS 4>KIPS
5 Especially EDWH 5>Especially TX Process
6 High Availability 6> Comparing Low
7 Easily Writing Complex Queries 7>Difficult To write CMPLXQ
8 Tera bytes of data for historical 8>giga bytes for TX Pro

Write a program to show the parser component used in teradata?

1025

---

What is a three-tier data warehouse?

1151

---

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

1107

---

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

2240

---

Define views in teradata with general syntax.

1086

---

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

1147

---

What are default access rights in teradata?

1187

---

What is teradata and why it is used?

1180

---

What is the difference between teradata and oracle?

1065

---

What are the frequently used data types in teradata?

1131

---

How to run a query in teradata?

1144

---

What are the steps involved after the disk manager passes the request?

1181

---

Explain the types of join supports by teradata?

1041

---

What are the joins in teradata?

1070

---

Explain PDE.

1128

---