Oracle
1Z0-072 · Question #15
oracle@host[~] impdp system/oracle \ > SCHEMAS=ee \ > REMAP_SCHEMA=sh:hr \ > DUMPFILE=orcl.dmp \ > EXCLUDE=index \ > TABLE_EXISTS_ACTION=replace \ > SQLFILE=impdp.log Which two are true? (Choose two.)
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@host[~] impdp system/oracle \
SCHEMAS=ee
REMAP_SCHEMA=sh:hr
DUMPFILE=orcl.dmp
EXCLUDE=index
TABLE_EXISTS_ACTION=replace
SQLFILE=impdp.log 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
(22 responses)- A18% (4)
- B5% (1)
- C5% (1)
- D73% (16)
Community Discussion
No community discussion yet for this question.