Answer / Ranjana Gautam

Oracle Clusterware manages CRS (Cluster Ready Services) resources by maintaining consistency across multiple nodes in a RAC (Real Application Clusters) environment. It uses the following methods:
1. Resource Management: Monitors and controls resource usage across all instances in the cluster.
2. Automatic Service Restart: Restarts failed services automatically.
3. Cluster Synchronization Services (CSS): Ensures consistency of data across nodes by applying transactions in the order they were committed.

How would you determine the time zone under which a database was operating?

2 Answers  

---

Describe what redo logs are.

1 Answers  

---

what is asm?

1 Answers   Oracle,

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1 Answers   EDS,

---

what are the benefits of flashback feature?

1 Answers   Oracle,

---

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.

1 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

what is ora 600?

1 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 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?

1 Answers  

---

what do you understand by flashback feature of oracle?

1 Answers   Oracle,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---