nerdexam
Oracle

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…

Moving Data

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)
  • A
    14% (3)
  • B
    5% (1)
  • C
    10% (2)
  • D
    71% (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.

AIt succeeds and creates the EMPLOYEES table in the HR schema if the table does not 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.

BIt fails because the SQL *Loader control file location is not specified.

SQL*Loader Express Mode automatically generates the control file internally based on the `table` parameter, eliminating the need for explicit control file specification.

CIt fails because the SQL *Loader data file location is not specified.

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.

DIt succeeds with default settings if the EMPLOYEES table belonging to the HR schema is alreadyCorrect

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.

EIt succeeds even if the HR user does not have the CREATE DIRECTORY privilege.Correct

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

#SQL*Loader Express Mode#Data loading#HR schema#CREATE DIRECTORY privilege

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice