Answer Posted / neha

in nonarchivelog mode the online redo log file are
overwritten each time a log switch occurs.LGWR does not
overwrite an online redo file group until the checkpoint
for that group is completed.ex-operating system crash
causes an instance crash.

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2408

---

how can you enable flashback feature?

949

---

Where would you look for errors from the database engine?

2848

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1934

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2546

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1984

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2434

---

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

991

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1065

---

What is dbcc? : sql server DBA

1283

---

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

1304

---

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

1176

---

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

2459

---

what is the use of ocr?

1031

---

how can a session indicate its interest in receiving alerts?

1039

---