Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Location Chicago IL, USA

Exam 1z0-062 topic 2 question 6 discussion

Actual exam question from Oracle's 1z0-062
Question #: 6
Topic #: 2
[All 1z0-062 Questions]

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
Show Suggested Answer Hide Answer

Suggested Answer: ABDF


Highly Voted 1 year ago
ABDF is correct: https://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN033 A. By not specifying a destination attribute, in which case the job runs locally. B. Remote database jobs must run as a user that is valid on the target database D. You can specify a job credential by specifying a named credential object or by allowing the credential attribute of the job to remain NULL. F. You can also create a destination group, which consists of a list of destinations, and reference this destination group when creating a job. In this case, the job runs on all destinations in the group.
upvoted 10 times
Most Recent 2 weeks, 3 days ago
Should be ABEF. Here is a remote database. D: By allowing the credential attribute of the job to remain NULL, in which case a local database job runs as the job owner. (See Table 28-1.) The job owner is the schema in which the job was created.
upvoted 2 times
2 days, 19 hours ago
For G:In the docs, it says that "You define where a job runs by specifying a one or more destinations. Destinations are also Scheduler objects and are described later in this section. If you do not specify a destination, it is assumed that the job runs on the local database." ref https://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN-GUID-6BADB539-62DB-468D-9685-A855FC133902
upvoted 1 times
2 days, 19 hours ago
For D:In the docs,the description of paramter destination_name,which is using in DBMS_SCHEDULER.CREATE_JOB, memtions that "If the credential_name argument of CREATE_JOB is NULL, each destination must be preceded by a credential, in the following format:credential.destination.The credential must already exist. If the credential_name argument is provided, then it serves as the default credential for every destination that is not preceded by a credential." ref https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72300
upvoted 1 times
2 months, 2 weeks ago
Correct Answer: ABEF
upvoted 1 times
1 year ago
A,E,F,G is answer!
upvoted 2 times