Answer Posted / suman

we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff

what are the benefits of flashback feature?

1089

---

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

1138

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2346

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2496

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1265

---

how can you connect from 10g user to 11g user??

2164

---

which background process invoke at the time of upgradation tell me???

2778

---

suppose you want to audit specific activities on sensitive data. How can you achieve that?

1056

---

What is the default fill factor value? : sql server DBA

1182

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2091

---

What are the different types of indexes available in sql server? : sql server DBA

1261

---

how can you process messages in order asynchronously?

1035

---

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

1036

---

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

1164

---

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?

2741

---