Question: 1
You want a job that performs a bulk insert as soon as the loader file arrives on the local file system.
Which two would you do to accomplish this? (Choose two.)
A. Create a file watcher
B. Create a bulk loader watcher
C. Create a light weight job for bulk insert
D. Create an event-based job for bulk insert
E. Create a job chain with a step for bulk insert
Answer: A,D
Question: 2
Which four are true about creating and running a remote database scheduler jobs? (Choose four.)
A. A database destination must exist or be created for the remote database
B. It must run as a user that is defined on the remote database
C. Remote database jobs always run as the same user who submits the job on the local database
D. A credential is optional for a remote database job
E. A credential must be created to define the remote user
F. A database destination group must exist or be created for a job to run on multiple remote
databases
G. A destination is optional for a remote database job because DB links can be used instead
Answer: A,B,D,F
Question: 3
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
A. It loads data faster than conventional SQL*Loader
B. No data file needs to be specified
C. It can load data in parallel
D. It loads data more efficiently than conventional SQL*Loader
E. It requires Enterprise Manager Express to be configured
Answer: A,C
For More Information:-
Visit Now:-
https://www.dumpspass4sure.com/oracle/1z0-062-dumps.html
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.