Answer / ramakrishnachallapalli

To take both backups we should keep database in archive log
mode.

Neither cold backup nor hot backup identify the corrupted
blocks in backup where as rman can identify

RMAN will take the backup of database used block only where as
hot backup will take physical existing database files
completely

When a user process fails, what background process cleans up after it?

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

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

0 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

---

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?

0 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

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

1 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

what is incremental checkpoint?

1 Answers   CTS,

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---