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.

what are the types of connection load-balancing?

940

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1917

---

how to restore files with rman?

2243

---

what do you understand by fine-grained auditing?

1015

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2582

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1940

---

How can you control the amount of free space in your index pages? : sql server DBA

1237

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1987

---

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

2794

---

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

2645

---

how does an oracle clusterware manage crs resources?

1027

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1923

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2230

---

What is transparent data encryption? : sql server DBA

1118

---

when does an alert gets signaled?

985

---