Oracle
1Z0-072 · Question #48
oracle.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle \ > SCHEMAS=sh,ee \ >…
The correct answer is D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR. E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR. See the full explanation below for the reasoning.
Question
oracle.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle \
SCHEMAS=sh,ee
REMAP_SCHEMA=sh:hr
DUMPFILE=orcl.dmp
EXCLUDE=index
TABLE_EXISTS_ACTION=replace
CONTENT=metadata_only Which two are true? (Choose two.)
Options
- AIt skips only tables that exist in both ORCL:SH and TESTDB:HR.
- BIt drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.
- CIt skips all indexes of ORCL:SH and ORCL:OE.
- DIt skips only indexes that exist in both ORCL:SH and TESTDB:HR.
- EIt drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.
How the community answered
(43 responses)- A9% (4)
- B2% (1)
- C7% (3)
- D81% (35)
Community Discussion
No community discussion yet for this question.