Answer / Kunjan Bharti

Recovery in Oracle Database refers to the process of making a corrupted or inconsistent database consistent after an error, failure, or disaster. Recovery involves applying redo log entries or archived redo logs to restore the database to a consistent state. Restoring, on the other hand, is the process of replacing the entire database files with backup copies.

What is the Query Optimizer. How you optimize your qeury.

2 Answers   Ericsson,

---

default triggers available for reports

1 Answers  

---

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

4 Answers  

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,

---

8. Supporting AP, AR and GL?

1 Answers   Oracle,

---

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

1 Answers  

---

what is difference between inner join & nested query or subqueries

1 Answers  

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1 Answers  

---

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

1 Answers   IBM, Oracle,

---

How would you go about increasing the buffer cache hit ratio?

1 Answers  

---

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

---