nerdexam
Oracle

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.

Managing Data and Concurrency

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)
  • A
    76% (19)
  • C
    4% (1)
  • E
    12% (3)
  • G
    8% (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.

AA database destination must exist or be created for the remote databaseCorrect

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.

BIt must run as a user that is defined on the remote databaseCorrect

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.

CRemote database jobs always run as the same user who submits the job on the local database

Remote jobs run as a user defined on the remote database, not necessarily the same user who submitted the job on the local database.

DA credential is optional for a remote database jobCorrect

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.

EA credential must be created to define the remote user

A credential is not always mandatory for remote jobs as other authentication methods, like database links with embedded credentials, can be employed.

FA database destination group must exist or be created for a job to run on multiple remoteCorrect

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.

GA destination is optional for a remote database job because DB links can be used instead

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

#Oracle Scheduler#remote job#database destination#credentials

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice