Practice Test Geeks1Z0-082 - Oracle Database Administration I Practice Test
← All 1Z0-082 Flashcard Decks

Moving and Migrating Data Flashcards

6 cards from real 1Z0-082 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Moving and Migrating Data flashcards as text

  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?

    Answer: SCHEMAS=HR,OE

    The `SCHEMAS` parameter in `expdp` is used to specify a list of one or more schemas to be exported in schema-mode. The `OWNER` parameter was used in the original `exp` utility and has been replaced by `SCHEMAS` in Data Pump. `TABLES` is used for exporting specific tables, not entire schemas.

  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?

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

    The SQL*Loader control file is a text file containing DDL instructions that tell SQL*Loader where to find the data, how to parse it, which table and columns to load it into, and how to handle potential errors. It essentially provides the metadata map for the load operation.

  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?

    Answer: External Tables

    External Tables allow Oracle to treat a flat file on the server's file system as if it were a read-only database table. This enables users to query the data using standard SQL, including joins with other tables, without the need to load the data into the database first, which avoids data duplication and the overhead of insert operations.

  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?

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

    Transportable tablespaces involve physically copying datafiles. When moving between platforms with different endian formats (byte ordering), such as AIX (big-endian) and Linux (little-endian), you must use the RMAN `CONVERT` command to reformat the datafiles. Additionally, the source and target databases must have compatible character sets.

  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?

    Answer: CONTENT=METADATA_ONLY

    The `CONTENT=METADATA_ONLY` parameter tells the Data Pump utility to process only the object definitions (DDL) from the dump file. This creates the structures like tables, indexes, and views but skips the actual data load.

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

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

    A direct path load significantly improves performance for large data loads by creating formatted data blocks and writing them directly to the datafiles. This bypasses much of the SQL command processing and the database buffer cache. A conventional path load uses standard `INSERT` statements, which is a slower process.