Answer Posted / yuvaevergreen

Adding to above, teradata locks objects on first come first
serve basis. write locks are generally used for dmls like
insert,update,delete. select statement uses access lock.
exclusive locks are used for ddls like create,alter. Pseudo
lock is a concept by which teradata assigns one amp to take
care of locking the rows of the table in other amps. This
amp makes sure that other amps lock the table.

Explain BYNET.

1053

---

What is the use of virtual processor connectivity in teradata?

1084

---

What is upsert statement in teradata?

1187

---

Highlight a few of the advantages that ETL tools have over Teradata.

1133

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1021

---

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

1081

---

How do you create tables? Exact syntax, and create profiles, users in teradata?

1087

---

Explain the most common data types used in teradata?

1123

---

Explain parsing engine in teradata?

1138

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1038

---

What are aggregate tables? How do you design them using teradata?

1216

---

What are some commonly used bteq scripts?

1056

---

Explain some differences between mpp and smp?

1157

---

what are the day to day activities of teradata DBA ?

5860

---

What is a sparse index?

1119

---