Answer / guest

online backup:

1.Inconsistent
2.database in open state.
3.Archive mode must set

offline:

1.consistent
2.db in close
3.No need archive mode

Answer / 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.

Oracle 11g new features?

2 Answers  

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

what is grd?

0 Answers   Oracle,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

how can you schedule a job in database?

0 Answers   Oracle,

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---