Answer Posted / yuvaevergreen

PPI arranges the rows in a data block using the value that
we mention in ddl. Range processing would be faster.
Basically rowid would not be used instead value would be used.


create table emp
(
emp char(10),
hiredate date
)
upi(emp)
partition by range_n
(hiredate between date '2000-10-10' and date '2010-10-10'
each interval '1' year);

If a Node is busy what are the steps you can take to avoid ?

2347

---

What is oltp?

914

---

What are the different functions performed in development phase?

1013

---

Why managing the data is important?

957

---

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

956

---

How is MLOAD Client System restarted after execution?

1057

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

770

---

How do you define Teradata?

982

---

What are the different softwares used with their functions in teradata?

966

---

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

979

---

What is spool space?

1074

---

Different phases of multiload?

936

---

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

929

---

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

1012

---

What do you mean by teradata intellicloud?

977

---