QUESTION 36-SQL*Loader

QUESTION 36
On your Oracle 12c database, you invoked SQL*Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command? (Choose two.)
A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
B. It fails because no SQL *Loader data file location is specified.
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D. It fails because no SQL *Loader control file location is specified.
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Note:
* SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.

 

问题36

在你的Oracle 12c数据库上，你调用SQL*Loader来加载数据到HR模式的EMPLOYEES表中，通过发出以下命令:

$> sqldr hr/hr@pdb table=employees . $> sqldr hr/hr@pdb table=employees . $>

关于这个命令，哪两个陈述是正确的?(选择两个。)

A.如果属于HR的EMPLOYEES表已经在数据库中定义，则默认设置成功。

B.由于没有指定SQL *Loader数据文件的位置而失败。

C.如果HR用户没有CREATE ANY DIRECTORY权限，则会失败。

D.由于没有指定SQL *Loader控制文件的位置而失败。

正确答案:交流

部分:(一)

解释

解释/参考:

解释:

注意:

当您指定sqldr命令和(可选)建立会话特征的参数时，将调用SQL*Loader。