1Z0-082 - Oracle Database Administration I Moving and Migrating Data Questions and Answers

Question 1

A DBA needs to export only the `HR` and `OE` schemas from a production database to a dump file using Oracle Data Pump. Which `expdp` parameter should be used to specify these schemas?

Accepted Answer

SCHEMAS=HR,OE

Answer

TABLES=HR.*,OE.*

Answer

OWNER=HR,OE

Answer

FULL=N SCHEMAS=(HR,OE)

Question 2

When using SQL*Loader to load data from a flat file into a database table, what is the primary purpose of the control file?

Accepted Answer

To describe the format of the input data file and map its fields to the target table columns.

Answer

To authenticate the user running the load process.

Answer

To log all errors that occur during the data load operation.

Answer

To store the data that is being loaded before it is committed.

Question 3

A data analyst needs to query data residing in a large comma-separated values (CSV) file located on the database server's file system without permanently loading it into the database. Which Oracle feature is best suited for this task?

Accepted Answer

External Tables

Answer

Database Links

Answer

SQL*Loader

Answer

Transportable Tablespaces

Question 4

You are planning to move a large tablespace from an Oracle database on an AIX server to another database on a Linux server using the transportable tablespaces method. What is a critical prerequisite for this operation?

Accepted Answer

The source and target databases must have compatible character sets and endian formats, or RMAN must be used for conversion.

Answer

The source and target databases must have the same DB_BLOCK_SIZE.

Answer

The source tablespace must be taken offline during the entire transport process.

Answer

The source and target databases must have the same database version and patch level.

Question 5

A DBA needs to perform a Data Pump Import (`impdp`) operation to create all tables and indexes from a dump file but without loading any of the row data. Which parameter and value should be specified?

Accepted Answer

CONTENT=METADATA_ONLY

Answer

INCLUDE=TABLE,INDEX

Answer

ROWS=N

Answer

CONTENT=STRUCTURE_ONLY

Question 6

Which statement accurately describes a key advantage of using a direct path load with SQL*Loader compared to a conventional path load?

Accepted Answer

It bypasses the database buffer cache and writes formatted data blocks directly to the datafiles, improving performance.

Answer

It generates significantly more redo and undo data for better recoverability.

Answer

It allows triggers and referential integrity constraints to be active on the target table during the load.

Answer

It automatically builds all indexes on the table before the data load begins.