While exporting data with Data Pump, you find that the export takes longer than expected. You
decide to stop the job and restart it during off-peak hours.
Which view would you query to determine the name and status of the stopped job?
A.
DBA_JOBS
B.
V$SESSION
C.
V$SESSION_LONGOPS
D.
DBA_DATAPUMP_JOBS
E.
DBA_DATAPUMP_SESSIONS
Explanation:
When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted.
This way, we can:* detach from and reattach to long-running jobs without affecting the job itself.
* monitor jobs from multiple locations
* stop a job: suspend it temporarily to leave other applications requesting more resources to get
them restart itlater
* kill any Datapump job anytime
* see the progress of the import or export operations
REF.: Metalink Note: 262557.1