How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

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

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

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

0 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

what is logical system in sap basis

0 Answers  

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

Datapump backup steps?

1 Answers  

---