Answer Posted / nani

continuation of rajesh kumar.
3.when we can use the select statement in form clause and
specify the name with 'as' keyword for that statement is
called derived table

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

1107

---

Difference between multiload and tpump?

1052

---

What are types of partition primary index (ppi) in teradata?

1013

---

What is bteq script in teradata?

1094

---

What is the purpose of indexes?

1021

---

Explain fallback in teradata?

992

---

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

2110

---

Describe the between keyword in teradata?

991

---

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

972

---

What is a sparse index?

1029

---

What are the different table types supported by teradata?

903

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1033

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1118

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

951

---

Did you write stored procedures in teradata?

1071

---