Oracle
1Z0-072 · Question #46
ORCL.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: {oracle@host} > impdp system/oracle \ > SCHEMAS=sh,oe \ >…
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
ORCL.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: {oracle@host} > impdp system/oracle \ > SCHEMAS=sh,oe \ > REMAP_SCHEMA=sh:hr \ > DUMPFILE=orcl.dmp \ > EXCLUDE=index \ > TABLE_EXISTS_ACTION=replace \ > LOGFILE=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
(25 responses)- A8% (2)
- B12% (3)
- C4% (1)
- D76% (19)
Community Discussion
No community discussion yet for this question.