Answer Posted / hardeep

Hi Madhu

Thanks for ur response but could u pls explain ur answer in more detail, if possible with an example?

Thanks again.

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

1015

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

999

---

What is the purpose of joins in teradata and what are the available join types?

1024

---

What are the functions involved in shared information architecture?

1037

---

How to identify ppi columns?

1121

---

Discuss the advantages of using partitioned primary index in a query?

920

---

how do you manage the production space. what are the proactive methods you can take ?

1890

---

Describe the set operators in teradata.

963

---

What is teradata and why it is used?

1033

---

How many codd's rules are satisfied by teradata database?

1062

---

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

958

---

What is meant by Teradata Gateway?

1021

---

What is a clique?

1028

---

How to Extract data from multiple legacy systems?

1055

---

How can you track login parameters of users in teradata?

1140

---