Answer Posted / maruthi

create insert drop delete
sys    sys    sys  sys-------------derived table
user   user   sys  sys-------------volatile table
user   user   user sys--------------global temp table
user   user   user user-------------normal table


-->derived table will be created by system while executing sub queries
-->global temp table & volatile table has to be created by user by mentioning "global temporary table" , "volatile table" respectively  in the syntax at the time of creating the table.

Explain fallback in teradata?

986

---

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3541

---

What are different table types used in teradata?

981

---

Highlight a few of the important components of Teradata?

969

---

What is the purpose of using case expression in teradata?

958

---

What is teradata and why it is used?

1015

---

What is teradata? Also, list out some of the primary characteristics of teradata.

983

---

What is the primary index in teradata?

1116

---

What is bteq utility in teradata?

918

---

Explain the most common data types used in teradata?

988

---

What is spool space? Why do you get spool space errors?

949

---

How to eliminate product joins in a teradata sql query?

962

---

What happens when a node suffers a downfall?

1058

---

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

975

---

Highlight the points of differences between the database and user in Teradata.

1042

---