Answer Posted / harsha

Error code is the code for the error for ex 3807 is the error code for the error "object does not exist"
To know the error codes type
select * from dbc.errormsgs
in the Queryman
Error level is the severity set for the corresponding error code
if error level is
0- Success
4- Warning
8- User Error
12- Fatal error
16- Typical Error

What is called partitioned primary index (ppi)?

1013

---

What is a node in teradata?

998

---

What is the difference between teradata and oracle?

1027

---

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

1042

---

Difference between inner join and outer join?

1026

---

Highlight the advantages of PPI(Partition Primary Index).

1077

---

How to run a query in teradata?

1074

---

What are the different functions performed in development phase?

1080

---

What are the main components of teradata system?

1135

---

What is node? How many nodes and amps used in your previous project?

1110

---

List out some of the primary characteristics of teradata.

1006

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2204

---

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

1096

---

Which is faster fastload or multiload?

1115

---

what is sysdba and sysdbc ? which has high priority ?

3831

---