I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

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

0 Answers   Value Labs,

---

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

Explain the use of table functions.

1 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---