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

1 Answers  

---

Is it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---

1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?

1 Answers   IBM,

---

Difference between pre-select and pre-query

0 Answers  

---

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,

---

Define Transaction ?

5 Answers  

---

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 Answers  

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---

How data locks are respected in oracle?

0 Answers  

---

how to make an oracle object

0 Answers  

---

How can we find out the duplicate values in an oracle table?

0 Answers  

---