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

Answer / kittu_chintu2005

online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running

offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state

Answer / mogal

as said above every thing is same but one more point. i.e
" in a hot backup it have fractured blocks and where as in
cold backup there is no fractured blocks"

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

If CPU is very slow What can u do to speed up?

1 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

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

0 Answers   Oracle,

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---