1Z0-062 · Question #362
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
The correct answer is A. It loads data faster than conventional SQL*Loader C. It can load data in parallel. SQLLoader Express Mode in Oracle 12c is designed for speed and ease of use, leveraging parallel processing to load data faster than conventional SQLLoader.
Question
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
Options
- AIt loads data faster than conventional SQL*Loader
- BNo data file needs to be specified
- CIt can load data in parallel
- DIt loads data more efficiently than conventional SQL*Loader
- EIt requires Enterprise Manager Express to be configured
How the community answered
(29 responses)- A86% (25)
- B3% (1)
- D3% (1)
- E7% (2)
Why each option
SQL*Loader Express Mode in Oracle 12c is designed for speed and ease of use, leveraging parallel processing to load data faster than conventional SQL*Loader.
SQL*Loader Express mode often employs direct path load and can leverage parallel processing, which allows it to process and load data into the database at a significantly higher rate compared to conventional SQL*Loader.
SQL*Loader Express mode, like any data loading utility, requires a source data file to be specified from which the data will be loaded into the database.
Leveraging Oracle's built-in parallel execution capabilities, SQL*Loader Express mode can automatically perform parallel data loading operations, maximizing throughput by utilizing multiple processes.
While SQL*Loader Express mode is designed for improved performance (faster), 'more efficiently' is a broader term, and 'faster' is a more direct and specific benefit of its design.
SQL*Loader Express mode is a command-line utility and does not require the configuration or use of Oracle Enterprise Manager Express to function.
Concept tested: Oracle SQL*Loader Express Mode features
Source: https://docs.oracle.com/database/121/SQLLR/sqlldr_express.htm#SQLLR00200
Topics
Community Discussion
No community discussion yet for this question.