Answer Posted / rajesh kumar

Permenant Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTISET table - Allows Duplicate Values.

Temporary Tables:
1. Global Temporary Table - supports [Compression in table],
when session logged out, Table persists and its record gets
vanished.
2. Volatile Table - When session logged out, TABLE and its
records are not available further.

I dont have idea about Derived Table, could someone
elaborate on this?

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1996

---

What are the available primary index types?

1147

---

Explain the most common data types used in teradata?

983

---

What is the difference between teradata and basic rdbms?

949

---

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

954

---

List out some of the primary characteristics of teradata.

925

---

List the logical and conditional operators that are used with teradata along with their meanings?

938

---

What is meant by a Virtual Disk?

1044

---

Explain how spool space is used.

1017

---

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

905

---

Why is the case expression used in teradata?

1023

---

Why teradata is used?

940

---

What are the various indexes in teradata? How to use them?

953

---

What are the various indexes in teradata? How to use them? Why are they preferred?

996

---

Comment whether bottleneck is an error or not.

1073

---