Answer / rajat sharma

Data integrity is provided by various constrains
(UNIQUE,CHECk etc.) provided to us by SQL. By these
constrains the user cannot even make a mistake in inserting
the data.

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 is a crs resource?

0 Answers   Oracle,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

How can we see the database version in os level

6 Answers   Oracle,

---

Describe what redo logs are.

1 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

How do you resize a data file?

2 Answers  

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

How would you force a log switch?

4 Answers  

---