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.

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

Describe what redo logs are.

1 Answers  

---

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  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---