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 the logical and conditional operators that are used with teradata along with their meanings?

938

---

Can we collect statistics on multiple columns?

986

---

Explain the new features of teradata?

990

---

What are the different table types that are supported by teradata?

954

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1058

---

Describe the between keyword in teradata?

979

---

What is the difference between fastload and multiload?

1289

---

What are the frequently used data types in teradata?

1003

---

What is the basic syntax for teradata select statement?

982

---

Explain fastload in teradata?

1037

---

what is sysdba and sysdbc ? which has high priority ?

3759

---

Explain the most common data types used in teradata?

983

---

What is a node in teradata?

935

---

What is a node in teradata? Explain

939

---

What are the functions of a teradata dba?

1022

---