1Z0-062 · Question #276
In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data: $> sqlldr hr/hr table=employees Which two statements are true about this command? (Choose two.)
The correct answer is D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege. This question examines the behavior of SQL*Loader Express Mode, which simplifies data loading by automatically deriving control file information and assuming default data file names. It requires the target table to pre-exist and can succeed without needing the user to create…
Question
In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:
$> sqlldr hr/hr table=employees Which two statements are true about this command? (Choose two.)
Options
- AIt succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
- BIt fails because the SQL *Loader control file location is not specified.
- CIt fails because the SQL *Loader data file location is not specified.
- DIt succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already
- EIt succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
How the community answered
(21 responses)- A14% (3)
- B5% (1)
- C10% (2)
- D71% (15)
Why each option
This question examines the behavior of SQL*Loader Express Mode, which simplifies data loading by automatically deriving control file information and assuming default data file names. It requires the target table to pre-exist and can succeed without needing the user to create new directory objects if suitable ones already exist.
SQL*Loader Express Mode, like standard SQL*Loader, does not create tables; it loads data into existing tables, so the EMPLOYEES table must already exist.
SQL*Loader Express Mode automatically generates the control file internally based on the `table` parameter, eliminating the need for explicit control file specification.
SQL*Loader Express Mode automatically assumes the data file is named `table_name.dat` (e.g., `employees.dat`) in the current directory, so an explicit location is not required for the command to attempt execution.
SQL*Loader Express Mode, invoked with the `table` parameter, automatically generates the control file and assumes a data file name based on the table name (e.g., `employees.dat`). This mode requires the target table (`EMPLOYEES`) to exist prior to execution and processes the load using these default settings.
SQL*Loader Express Mode internally uses external tables for data loading. While external tables require a directory object and associated read/write privileges, the `CREATE DIRECTORY` privilege is only needed to *create* a new directory object. If a suitable directory object already exists in the database and the HR user has been granted `READ` and `WRITE` privileges on it, the Express Mode command can proceed successfully without the HR user explicitly possessing `CREATE DIRECTORY`.
Concept tested: SQL*Loader Express Mode functionality and privileges
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/sql-loader-express-mode.html
Topics
Community Discussion
No community discussion yet for this question.