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

1106

---

What is the purpose of indexes?

1082

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1170

---

Can we collect statistics on multiple columns?

1071

---

Can you connect multiload from ab initio?

1227

---

Why does varchar occupy 2 extra bytes?

1203

---

Why are oltp database designs not generally a good idea for a data warehouse?

1062

---

What's the difference between timestamp (0) and timestamp (6)?

1202

---

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

1052

---

How many tables can you join in v2r5?

1077

---

What are the things to be considered while creating secondary index?

1104

---

What is a three-tier data warehouse?

1122

---

Difference between stored procedure and macro?

1177

---

What is multi insert?

1059

---

Different phases of multiload?

1026

---