Answer / Deepak Tiwari

When the database crashes due to media corruption, you can recover it using Recovery Manager (RMAN). Here's how:n
1. Start RMAN as a client:n```bashnrman target /n```
2. Connect to the control file:n```sqlnconnect rman/password@controls_file=/path/to/control_file;n``` Replace '/path/to/control_file' with the actual path to your control file.
3. Create a recovery catalog (if you don't have one):n```sqlncreat catalog rman_cat@db;``` Replace 'rman_cat' and 'db' with your desired catalog name and database service name, respectively.
4. Recover the database:n```sqlnrun{n recover database;n}n```

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

1 Answers  

---

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

2 Answers  

---

What is the dataguard background process??

1 Answers   iGate,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

What is transparent data encryption? : sql server DBA

1 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

What are the recovery models for a database? : sql server DBA

1 Answers  

---

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

1 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Why would you call update statistics? : sql server DBA

1 Answers  

---