Answer Posted / vishal sharna

offline backup is the traditional backup in which we cannot
take the backup untill the application is closed but its
quite consistent,but as we know its very cost effective to
close all the application and then take the backup,so we
will take the online backup.in this case we an take the
backup of running aplication but set the recovery log mod
to rollforward,with the help of it we can restore our
database to the most recent state.

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2623

---

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

2438

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2040

---

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?

2515

---

What is dcl? : sql server DBA

1277

---

Why would you use sql agent? : sql server DBA

1090

---

what functionality does oracle provide to secure sensitive information?

999

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2168

---

what is logical system in sap basis

1643

---

how can you find out if a table can be redefined?

1018

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2344

---

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

996

---

internal architecture

2199

---

What is the difference between clustered and non-clustered index? : sql server DBA

1091

---

What authentication modes does sql server support? : sql server DBA

1217

---