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
AI explanation

An Export utility run with tablespace=SAMPLE pulls in every object that has storage in that tablespace: the EMPLOYEES table itself, its primary-key index IPK_EMP (also stored in... actually stored in INDX, but tablespace-mode export follows dependent objects), and any partition of another table—here, partition P1 of SALES—that physically resides in SAMPLE. Tablespace-level export scans for all segments located in the named tablespace rather than being restricted to a single table, so partial-table storage (like one partition) still pulls the whole table definition in.

Keep practicing — related questions