Answer / gogune suresh kumar

All data changes to the database are stored in redo-log
buffers.

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

3 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

---

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  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---

Give two examples of referential integrity constraints.

2 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

What is replication? : sql server DBA

0 Answers  

---

Explain the use of table functions.

1 Answers  

---