Answer Posted / ankal

This problm solve only using Distinct or Group by
syntax:
1:sel distinct no,name from tablename;
2:sel no,name from tablename group by no,name;

What are the primary characteristics of the Teradata.

1160

---

What are the design features involved in teradata?

1061

---

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?

1114

---

What are differences between teradata and ansi session modes in teradata?

1175

---

Can we collect statistics on table level?

1037

---

What are types of partition primary index (ppi) in teradata?

1056

---

What is bteq script in teradata?

1159

---

How do you set the session mode parameters in bteq?

1107

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1098

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1043

---

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

1048

---

What is the purpose of indexes?

1079

---

What are the different functions included in the server software?

1034

---

What are normalization, first normal form, second normal form and third normal form?

1058

---

What are default access rights in teradata?

1126

---