Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

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 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
hggz
Highly Voted 4 years 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 17 times
...
dfabac
Most Recent 1 year, 10 months ago
Selected Answer: ABDF
Answer is ABDF
upvoted 1 times
...
NorwayOracle
2 years ago
Selected Answer: ABDF
You do not have to create a credential, but you need to prefix the destination with credential. Therefor e) is not correct.
upvoted 1 times
...
katetel
2 years, 8 months ago
ABDF is correct
upvoted 1 times
...
Taria24
3 years, 1 month 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 4 times
badguy001djh
3 years 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
...
badguy001djh
3 years 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
...
...
jobao
3 years, 3 months ago
Correct Answer: ABEF
upvoted 4 times
...
NorthKorean
4 years ago
A,E,F,G is answer!
upvoted 2 times
NorwayOracle
2 years ago
Database link is not mentioned in the documentation.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...