Answer / kittu_chintu2005

Export/Import: traditional backup of oracle database, we can't resume the export/import job if we stop the job in middle. We can't attach any job to running job @ exp/imp. We need not to create a file structure @ oracle level

Datapump: It's introduced from 10g. We can resume the datapump job if we stop the job in middle. We can attach a datapump job to running job. We need create file structure @ oracle level and OS level.

Answer / kranthi shiva

Datapump is having better performance than export/import
Datapump--it is having byte
it is having parallelism concept
Incremental backups
we can restart the job, kill and resume the job.
Export/Import-- here we cannot resume the job
it is having bit level or block level
it is not having incremental backup

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

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

1 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

How many memory layers are in the shared pool?

3 Answers  

---

Give two examples of referential integrity constraints.

2 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

why we use cursors

1 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---