Answer Posted / arun

schema is a combination of fact & dimension table.(in simple way)

Why does for update in oracle 8 cause an ora-01002 error?

998

---

Explain oracle instance.

1171

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

---

What is Virtual Private Database in Oracle?

1083

---

How to do paging with oracle?

993

---

How to write numeric literals in oracle?

1178

---

What are the common oracle dba tasks?

1139

---

What is bulk load in oracle?

1068

---

What is the difference between view and materialized view in Oracle?

1148

---

In the oracle version 9.3.0.5.0, what does each number shows?

1292

---

query optmization techniques and quwry analyser+projects+ppts

2416

---

Can you have more than one content canvas view attached with a window ?

2328

---

How to define an explicit cursor in oracle?

1032

---

What are a collation and state the different types of collation sensitivity?

1164

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5538

---