1Z0-062 · Question #360
Which four are true about creating and running a remote database scheduler jobs? (Choose four.)
The correct answer is 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 D. A credential is optional for a remote database job F. A database destination group must exist or be created for a job to run on multiple remote. Remote database scheduler jobs require a defined database destination and run as a user on the remote database, optionally using a credential for authentication, and can target multiple remote databases via a destination group.
Question
Which four are true about creating and running a remote database scheduler jobs? (Choose four.)
Options
- AA database destination must exist or be created for the remote database
- BIt must run as a user that is defined on the remote database
- CRemote database jobs always run as the same user who submits the job on the local database
- DA credential is optional for a remote database job
- EA credential must be created to define the remote user
- FA database destination group must exist or be created for a job to run on multiple remote
- GA destination is optional for a remote database job because DB links can be used instead
How the community answered
(25 responses)- A76% (19)
- C4% (1)
- E12% (3)
- G8% (2)
Why each option
Remote database scheduler jobs require a defined database destination and run as a user on the remote database, optionally using a credential for authentication, and can target multiple remote databases via a destination group.
A database destination object is essential for remote jobs to specify the target database connection information, enabling the scheduler to execute tasks on the designated remote system.
Remote jobs execute on the target database, thus they must run under a user account that is defined on that specific remote database and possesses the necessary privileges for the job's operations.
Remote jobs run as a user defined on the remote database, not necessarily the same user who submitted the job on the local database.
While a credential object can define the remote user for a scheduler job, it is optional if the remote connection, such as one established via a database link, already encapsulates the necessary authentication details.
A credential is not always mandatory for remote jobs as other authentication methods, like database links with embedded credentials, can be employed.
To enable a single job to execute across multiple remote databases, a database destination group must be created to logically bundle several individual database destinations, allowing the job to target all group members.
A database destination is required to define the connection to the remote database, even if a database link is utilized as part of that destination's configuration.
Concept tested: Oracle Scheduler Remote Jobs configuration
Source: https://docs.oracle.com/database/121/ADMIN/schedadmin.htm#GUID-85265507-6B1B-45F4-A151-6893B3EFC71C
Topics
Community Discussion
No community discussion yet for this question.