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

1116

---

What is the purpose of indexes?

1090

---

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

1179

---

Can we collect statistics on multiple columns?

1077

---

Can you connect multiload from ab initio?

1234

---

Why does varchar occupy 2 extra bytes?

1208

---

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

1066

---

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

1205

---

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

1062

---

How many tables can you join in v2r5?

1085

---

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

1113

---

What is a three-tier data warehouse?

1127

---

Difference between stored procedure and macro?

1182

---

What is multi insert?

1061

---

Different phases of multiload?

1029

---