New Features for Administrators - Question 088

The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX tablespace.

Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace.

Which objects will be exported by this command?

exp system/manager tablespaces=SAMPLE

A. Only the EMPLOYEES table

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

C. The EMPLOYEES table and partition P1

D. The EMPLOYEES table, IPK_EMP index, and the SALES table

Answer: D

Explanation:

The EMPLOYEES table, IPK_EMP index, and the SALES table will be exported by this command, because Export utility export objects in the SAMPLE tablespace and ALL other objects corresponding to objects in the SAMPLE tablespace: other partitions for table from SAMPLE tablespace, primary key, other corresponding indexes and so on.

Incorrect Answers

A: Not only the EMPLOYEES table will be exported, but all objects corresponding to it also.

B: All other partitions of the EMPLOYEE table will be exported also.

C: Its corresponding primary key index will be exported also.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 49-51 Chapter 2: Availability Enhancements