Answer Posted / ram

Permanent Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTI SET 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.
3 derived able
4 error table(t13)

What are the enhanced features in teradata v2r5 and v2r6?

1128

---

Describe primary index in teradata. And what are the available primary index types?

998

---

What are the things to be considered while creating secondary index?

1096

---

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

1034

---

What is upsert statement in teradata?

1122

---

Describe the between keyword in teradata?

1030

---

What are the string manipulation operators and functions associated with teradata?

1078

---

How many tables can you join in v2r5?

1066

---

Describe primary index in teradata?

998

---

How to Extract data from multiple legacy systems?

1112

---

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

2048

---

How can you track login parameters of users in teradata?

1186

---

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

1148

---

What do high confidence, low confidence and no confidence mean in explain plan?

1043

---

Explain and compare pros and cons of start schemas?

1058

---