Answer Posted / rizwan

In traditional datapump exp/imp utility we can not stop the job when it's processing.
whereas in newly expdp/impdp utility we can stop and restart the job
for example, we are exporting the 5 mb size of table and,suppose we want to stop this job so it is possible in expdp but not through exp utility.

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1057

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1060

---

what is the diffrence between core dba and apps dba?

2552

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1893

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2601

---

How would you go about verifying the network name that the local_listener is currently using?

3194

---

how can you connect from 10g user to 11g user??

2092

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1080

---

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

2699

---

What is dcl? : sql server DBA

1237

---

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?

2653

---

Which autogrowth database setting is good? : sql server DBA

1126

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2249

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1184

---

Why would you call update statistics? : sql server DBA

972

---