nerdexam
Oracle

1Z0-062 · Question #305

You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use.

The correct answer is C. SQL*Loader with a direct data path. https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1007501

Moving Data

Question

You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use.

Options

  • Aexternal table
  • BOracle data Pump
  • CSQL*Loader with a direct data path
  • DSQL*Loader with a conventional data path
  • EEnterprise Manager Database Express

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    12% (3)
  • C
    81% (21)
  • E
    4% (1)

Explanation

https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1007501

Topics

#SQL*Loader#direct path load#SGA#data loading

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice