nerdexam
Oracle

1Z0-032 · Question #44

On Monday night, using the Oracle Export utility you exported your application tables by using the following command: $ exp apps/apps tables=(ORDERS, CUSTOMERS, ITEMS, INVENTORY) \\ direct=Y \\…

The correct answer is A. direct. See the full explanation below for the reasoning.

Question

On Monday night, using the Oracle Export utility you exported your application tables by using the following command:

$ exp apps/apps tables=(ORDERS, CUSTOMERS, ITEMS, INVENTORY) \ direct=Y \ file=$ORACLE_HOME/backup/files.dmp \ resumable=y \ resumable_name=APPS_EXP \ resumable_timeout=60 On Tuesday morning, you observe that the CUSTOMERS table has been dropped accidentally. You try to import it by executing the following command:

$ imp apps/apps tables=(CUSTOMERS) \ direct=Y \ file=$ORACLE_HOME/backup/files.dmp \ resumable=y \ resumable_name=APPS_EXP \ resumable_timeout=60 \ ignore=Y But the command errors out, displaying LRM-00101: unknown parameter name error. Which parameter must you remove for the import to be successful?

Options

  • Adirect
  • Bignore
  • Ctables
  • Dresumable
  • Eresumable_timeout

How the community answered

(23 responses)
  • A
    83% (19)
  • B
    4% (1)
  • C
    9% (2)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice