Multiple choice

Which of the following statements concerning the Export/Import Utilities is true?

  1. The direct-path feature allows a user to extract database objects faster than the conventional-path.

  2. The Export Utility can be used to make a logical backup of a table, a tablespace, or a table's associated data files.

  3. The FULL database export mode exports all database objects regardless of the schema.

  4. Performing an export/import of a tablespace is quicker than using the transportable tablespace method to transfer a table and its data.

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Export/Import direct-path feature extracts data faster than conventional-path export because it bypasses the SQL evaluation layer and reads data directly from disk blocks, formatting it as Oracle export format. This reduces CPU overhead and processing time. Option B is incorrect because Export cannot directly export tablespaces or data files (those are physical storage structures, not logical database objects). Option C is incorrect because FULL export mode only exports objects in schemas that the user has privileges to access, not all objects regardless of schema. Option D is incorrect because transportable tablespaces (which copy data files) are much faster than export/import for moving large volumes of table data.