What type of index should you use on a fact table?

1 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

What is checkpoint?

3 Answers   Accenture,

---

how can you initialize log miner?

0 Answers   Oracle,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---