Answer Posted / rajesh kumar

update on previous answer:

1.Derived table stores the derived result from a subquery.
2.It uses only spool space, so no table definition,
permission needed.
simple query eg:

select * from (select max(sal) from emp) DT (Max_sal)

answer:
derived table(DT) has Max salary and result would be

Max_sal- here subquery result is maintained in derived table
-------
25000

3. derived table auto drops after the query ends

List out all forms of LOCKS that are available in Teradata.

967

---

What is oltp?

972

---

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

1126

---

What are the different design perspectives used in teradata?

981

---

What is difference between user and database in teradata?

1065

---

how many modules are there in telecome domain?how to explain the architecture?

2013

---

What are aggregate tables? How do you design them using teradata?

1167

---

What are tpump utility limitations?

1118

---

What is meant by a Virtual Disk?

1124

---

how can we analyze the locks ?

2125

---

What are the various reporting tools in the market?

1060

---

What are the uses of bynets in multi-node systems?

1027

---

What are the uses of client software involved in teradata?

982

---

What is partitioned primary index (ppi)?

1046

---

What is meant by a Channel Driver?

1237

---