Multiple choice technology databases

The employees table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command ? exp system/manager tablespace=SAMPLE

  1. Only the EMPLOYEES table.

  2. Only the EMPLOYEES table and its corresponding primary key index.

  3. The EMPLOYEES table and partition P1.

  4. The EMPLOYEES table, IPK_EMP index, and the SALES table.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When you export by tablespace using exp with tablespace=SAMPLE, Oracle exports all database segments stored in that tablespace. This includes tables, indexes, and partitions. The SAMPLE tablespace contains the EMPLOYEES table and its primary key index IPK_EMP (stored separately in INDX but associated with EMPLOYEES). Partition P1 of SALES is also in SAMPLE, so the entire SALES table definition is exported (though only P1's data is in SAMPLE).

Keep practicing — related questions