Oracle
1Z0-072 · Question #5
1Z0-072 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-072 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-072 to see the answer
You've previewed enough free 1Z0-072 questions. Unlock 1Z0-072 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.