Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

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

0 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---