1Z0-062 · Question #345
What is a requirement for creating a remote database scheduler job?
The correct answer is A. The remote database job must run as a user that is valid on the target remote database. When creating a remote database scheduler job, the job's execution context on the target remote database requires a valid user account. This ensures the job has the necessary permissions to perform its tasks on the remote system.
Question
What is a requirement for creating a remote database scheduler job?
Options
- AThe remote database job must run as a user that is valid on the target remote database.
- BA private database link must be created from the originating database to the target remote
- CThe target remote database on which the job is scheduled must be Oracle Database 11g
- DThe target remote database must be on a different host form the originating scheduler
How the community answered
(37 responses)- A78% (29)
- B5% (2)
- C3% (1)
- D14% (5)
Why each option
When creating a remote database scheduler job, the job's execution context on the target remote database requires a valid user account. This ensures the job has the necessary permissions to perform its tasks on the remote system.
A remote database scheduler job executes commands on the target database, and therefore requires a valid user identity on that target database with the necessary privileges to perform the scheduled tasks.
While a database link is typically used for remote jobs, it does not have to be a private database link; a public database link can also be used.
Oracle Database Scheduler supports remote jobs across various database versions, not exclusively Oracle Database 11g.
A remote database can be on the same host as the originating scheduler database, provided it's a separate database instance and accessible via a database link.
Concept tested: Oracle remote database scheduler job requirements
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_SCHEDULER.html#GUID-059902BF-53C7-4589-A212-D22E8D719601
Topics
Community Discussion
No community discussion yet for this question.