On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the

Post by answerhappygod »

On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:S>sqlldrhr/hr@pdb table=employeesWhich two statements are true about the command?

A. It succeeds with default settings if the employees table exists in the hr schema.
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. E. It succeeds and creates the employees table in the HR schema.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply