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

How can you rebuild an index?

6 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

Does transparent data encryption provide encryption when transmitting data across network? : 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,

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

how can you initialize log miner?

0 Answers   Oracle,

---

what is the use of home directory???

1 Answers   HP,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---