Answer Posted / rahul

hi,
primary keys are not mandatory in the teradata,but when
we are specify the pk in column the optimizer creates the
upi in that column. and more over pk composite have no limit
in teradata. the creation of pk is combination of primary
key and not null see the example

create set/multiset table <table name>
(
orderid integer primary key not null,
---
----- etc
);

this creates upi on the orderid column.

if we doesn't mentioned nupi will be created..

thanks

Rahul

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

1081

---

Define views in teradata with general syntax.

1084

---

List out teradata data types?

1061

---

How can we check the version of Teradata that we are using currently?

1107

---

Mention a few of the ETL tools that come under Teradata.

1129

---

What is the opening step in basic teradata query script?

1089

---

Write a program to show the parser component used in teradata?

1024

---

Can we collect statistics on multiple columns?

1119

---

how do you manage the production space. what are the proactive methods you can take ?

1978

---

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

1199

---

Why is the case expression used in teradata?

1132

---

What is smp and mpp platforms?

1031

---

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1781

---

What is the syntax for case when statement?

1212

---

What is upsert statement in teradata?

1186

---