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

Direct-path export bypasses the SQL statement processing layer, writing data directly to the export file, which is significantly faster than conventional path. Export cannot export tablespaces or data files directly (only schema objects). FULL export respects schema boundaries. Transportable tablespaces are faster than export/import for table transfer.

Keep practicing — related questions