Oracle Database 23ai Administration Associate 1z0-182 Question # 18 Topic 2 Discussion

Oracle Database 23ai Administration Associate 1z0-182 Question # 18 Topic 2 Discussion

1z0-182 Exam Topic 2 Question 18 Discussion:
Question #: 18
Topic #: 2

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@host01 ~] impdp system/oracle SCHEMAS=sh,oe REMAP_SCHEMA=sh:hr DUMPFILE=orcl.dmp EXCLUDE=index TABLE_EXISTS_ACTION=replace LOGFILE=impdp.log Which two statements are true?


A.

It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.


B.

It skips only tables that exist in ORCL:SH and ORCL:OE.


C.

It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.


D.

It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.


E.

It skips only indexes that exist in both ORCL:SH and TESTDB:HR.


Get Premium 1z0-182 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.