Answer Posted / venkatarayudu gutta

as per my knowledge we have,correct me if i am wrong
1.permanent table
2.set table
3.multiset table
4.derived table
5.error table
6.volatile table
7.global temporary table
and two more we have
8.queue table
9.temporal table(released in TD14)

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2149

---

What are the 5 phases in a multiload utility?

987

---

if collect stats but it show low confidence why?

1620

---

How is MLOAD Teradata Server restarted after execution?

1170

---

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

1036

---

What is meant by a Channel Driver?

1142

---

What happens when a node suffers a downfall?

1058

---

What is the basic syntax for teradata select statement?

986

---

what are the day to day activities of teradata DBA ?

5757

---

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 ?

2420

---

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

931

---

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

991

---

How do you determine the number of sessions?

1010

---

What are the commands to make a new table, change a table and remove a table in teradata?

1070

---

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

982

---