exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 1 question 137 discussion

Actual exam question from Oracle's 1z0-062
Question #: 137
Topic #: 1
[All 1z0-062 Questions]

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

  • A. You can detach from a data pump export job and reattach later.
  • B. Data pump uses parallel execution server processes to implement parallel import.
  • C. Data pump import requires the import file to be in a directory owned by the oracle owner.
  • D. The master table is the last object to be exported by the data pump.
  • E. You can detach from a data pump import job and reattach later.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
hggz
Highly Voted 4 years, 8 months ago
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?
upvoted 7 times
soniat
3 years, 8 months ago
ABE is the correct answer
upvoted 3 times
...
...
luizyto
Most Recent 2 years, 1 month ago
Selected Answer: AE
A and E
upvoted 1 times
...
Ray520
2 years, 4 months ago
Selected Answer: AE
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."
upvoted 1 times
...
dfabac
2 years, 6 months ago
Selected Answer: AE
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
upvoted 1 times
...
Ray_gk
2 years, 8 months ago
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.
upvoted 1 times
...
PerkDizzzle
5 years, 3 months ago
B & D are correct Ref: https://docs.oracle.com/database/121/SUTIL/GUID-6BDC1CC8-8596-402D-B016-602985B97AB6.htm#SUTIL808
upvoted 2 times
...
rdnkrkmz
5 years, 10 months ago
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.
upvoted 2 times
rcgenilo27
5 years, 3 months ago
You mean E?
upvoted 3 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago