Answer Posted / nirav gajjar

The Data Pump is a server based utility vs. the traditional
Export / Import which are client based utilities. The
Oracle Data Pump is not compatible with the Export / Import
functionality.

The Oracle Data Pump can also use NETWORK_LINK
functionality to move data and metadata from a remote
database without a dumpfile using the network technology
between the two databases.

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1973

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2093

---

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?

2678

---

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

1312

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4425

---

what do you understand by flashback feature of oracle?

993

---

What is the default port no on which sql server listens? : sql server DBA

1160

---

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

2409

---

how can you process messages in order asynchronously?

974

---

What are the commands used in dcl? : sql server DBA

1070

---

what is asm?

1047

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2812

---

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

2849

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1066

---

How would you extract DDL of a table without using a GUI tool?

2487

---