Answer Posted / ram

Primary key
============
1. A table should have only one primary key
2. More than one column can consist of a primary key – upto
64 columns
3. Can not be NULL values (missing values)
4. Should be unique values (no duplicate value)

Foreign key
============
1. A table may have zero or more than that upto 32 keys
2. More than one column can consist a primary key – upto 64
columns
3. Can have NULL values
4. Can have duplicate values
5. There should be a corresponding primary key in the
parent table to enforce referential integrity for a foreign
key

Can we collect statistics on multiple columns?

1072

---

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 ?

2488

---

What is the difference between teradata and oracle?

1035

---

Why do you get spool space errors? How do trouble-shoot them?

1065

---

What's the difference between timestamp (0) and timestamp (6)?

1203

---

What is called partitioned primary index (ppi)?

1019

---

How to load specific no.of records using bteq, or fastload,or multiload

1756

---

How to view every column and the columns contained in indexes in teradata?

1060

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1162

---

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

1078

---

What do you mean by tpt in teradata?

1027

---

What is the command in bteq to check for session settings ?

1187

---

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

967

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1113

---

What is the use of fallback?

1002

---