New Features for Administrators - Question 031

You use the TABLESPACES option of the Export command to export, not transport, the contents of a set of tablespaces. What are the only contents of the dump file?

A. 1. Non-partitioned tables in the tablespace set
2. Partitioned tables that have all their partitions in the tablespace set
3. Indexes on all the exported tables

B. 1. Non-partitioned tables in the tablespace set
2. Partitioned tables that have at least one partition in the tablespace set.
3. Indexes on all the exported tables

C. 1. Non-partitioned tables in the tablespace set
2. Partitioned tables that have all their partitions in the tablespace set
3. Indexes on the exported tables if the indexes are in the tablespace set or have at least one partition in the tablespace set

D. 1. Non-partitioned tables in the tablespace set
2. Partitioned tables that have at least one partition in the tablespace set
3. Tables (including all partitions, if they exist) that have an index in the tablespace set

4. Indexes on all the exported tables

Answer: B

Explanation:

If you use the TABLESPACES option of the Export command to export the contents of a set of tablespaces, content of dump file will be: non-partitioned tables in the tablespace set, partitioned tables that have at least one partition in the tablespace set, indexes on all the exported tables.

Incorrect Answers

A: It’s not required that partitioned tables have to have ALL their partitions in the tablespace set them to be exported with this option.

C: It’s not required that partitioned tables have to have ALL their partitions in the tablespace set them to be exported with this option. Also ALL indexes on all the exported tables will be exported.

D: Tables that have an index in the tablespace set will not be exported.

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

Chapter 2: Availability Enhancements