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.)
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #276. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL*Loader Express Mode#Data loading#HR schema#CREATE DIRECTORY privilege