A,E is correct:
https://docs.oracle.com/database/121/SUTIL/GUID-EBC54840-22B7-486C-B1FD-CAFFB5FC2344.htm#SUTIL871
https://docs.oracle.com/database/121/SUTIL/GUID-0FD688BF-A25E-40D3-B835-E2CBF069F26E.htm#SUTIL945
D is not correct, there is no master table export, only master table content written to file.
What with B?
Both expdp and impdp jobs are detachable and attachable.
Regarding option B, it's not parallel execution server processes, to be exact "The value you specify for integer specifies the maximum number of processes of active execution operating on behalf of the import job. This execution set consists of a combination of worker processes and parallel I/O server processes."
Answer is AE.
B is incorrect because parallelism on import process is not related to parallel execution server processes. Task is performed by database writer processes, ie:
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: XTP_AC
Object Name: SYS_C0063284986
Object Type: SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Completed Objects: 1,120
Worker Parallelism: 1
Worker 2 Status:
Process Name: DW01
State: WORK WAITING
Worker 3 Status:
Process Name: DW02
State: WORK WAITING
A & E are correct.
You can both attach and reattach for export and import jobs.
D is incorrect because at the end of an export job, the content of the master table is written to a file.
I believe B is incorrect as datapump does not use parallel execution server process for parallel imports by default. We have to specifically provide the parallel paramter during the operation. However, I am not too sure on this rationale.
I believe we are all in agreement that C is incorrect for obvious reasons.
import and export job are both attachable. So A and D is correct (tested 11.2.0.4). But may B be correct, too.
Confused. If I see this question in exam, I mark AD.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
hggz
Highly Voted 4 years, 8 months agosoniat
3 years, 8 months agoluizyto
Most Recent 2 years, 1 month agoRay520
2 years, 4 months agodfabac
2 years, 6 months agoRay_gk
2 years, 8 months agoPerkDizzzle
5 years, 3 months agordnkrkmz
5 years, 10 months agorcgenilo27
5 years, 3 months ago