Question 2
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2.
The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1.
USER1.EMP_IDX residing in TBS2 is an index on U1.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=u1.dmp tablespace=tbs1
What is the result and why?
It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
It fails because TESTDB has TBS1.
It fails because TESTDB does not have TBS2 to create EMP_IDX.
Correct answer: B