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

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2082

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1078

---

How to start SQL Server in minimal configuration mode?

7921

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2337

---

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

986

---

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?

1973

---

what is ora 24313?what is the procedure to exclude that error?

2548

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2699

---

What the different types of replication and why are they used? : sql server DBA

1159

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2556

---

how can you initialize log miner?

1113

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

969

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2390

---

what functionality does oracle provide to secure sensitive information?

969

---

What purpose does the model database server? : sql server DBA

1150

---