Answer Posted / rajesh naidu

WE CAN TAKE THE RMAN BACKUP IN THE PRIMARY DATABASE WITHOUT
CATALOG
BY CONNECTING LIKE RMAN NO CATALOG/

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

2505

---

what is the use of ocr?

1073

---

How to start SQL Server in minimal configuration mode?

8077

---

what is a crs resource?

1236

---

what is the role of dip user in our database?

2461

---

How would you extract DDL of a table without using a GUI tool?

2532

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

2041

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1121

---

how can you schedule a job in database?

1192

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1045

---

Explain materialized views and how they are used.

2496

---

How can you control the amount of free space in your index pages? : sql server DBA

1372

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1135

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2612

---

What is transparent data encryption? : sql server DBA

1251

---