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.

What is dbcc? : sql server DBA

1219

---

how can you enable flashback feature?

896

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2294

---

how can you create a user-defined lock?

962

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2061

---

how can you record information about current session?

981

---

What is fill factor? : sql server DBA

1185

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4387

---

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

1237

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1053

---

how can you get actual data change values from previous transactions in oracle?

1038

---

when does an alert gets signaled?

985

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

940

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2617

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

988

---