Oracle
1Z0-072 · Question #5
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. USER1 has EMP_table with primary key EMP_ENO. PK resides in TBS1. USER1's EMP_IDX residing in ORCL is an index on UL_EMP_ENAME. TBS1…
The correct answer is B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK. See the full explanation below for the reasoning.
Question
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. USER1 has EMP_table with primary key EMP_ENO. PK resides in TBS1. USER1's EMP_IDX residing in ORCL is an index on UL_EMP_ENAME. TBS1 is exported from ORCL by using this command: [oracle@host01 ~]$ expdp system/oracle tablespace=tbs1 directory=exp_dir dumpfile=tbs1.dmp The TESTDB database has a TBS1 tablespace but no TBS2. The SYSTEM user in TESTDB executes this command: [oracle@host01 ~]$ impdp system/oracle directory=exp_dir dumpfile=ul.dmp tablespace=tbs1 What is the result and why?
Options
- AIt imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
- BIt imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
- CIt fails because TESTDB has TBS1.
- DIt imports only EMP.
- EIt fails because TESTDB does not have TBS2 to create EMP_IDX.
How the community answered
(55 responses)- A15% (8)
- B71% (39)
- C2% (1)
- D9% (5)
- E4% (2)
Community Discussion
No community discussion yet for this question.