1Z0-067 · Question #126
Which three statements are true about persistent lightweight jobs?
The correct answer is A. A user cannot set privileges on them. D. They must reference an existing Scheduler Program. E. The are useful when users need to create a large number of jobs quickly. Unlike regular jobs, they are not schema objects. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has…
Question
Which three statements are true about persistent lightweight jobs?
Options
- AA user cannot set privileges on them.
- BThey generate large amounts of metadata.
- CThey may be created as fully self-contained jobs.
- DThey must reference an existing Scheduler Program.
- EThe are useful when users need to create a large number of jobs quickly.
How the community answered
(22 responses)- A77% (17)
- B9% (2)
- C14% (3)
Explanation
Unlike regular jobs, they are not schema objects. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job. Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either 'PLSQL_BLOCK' or 'STORED_PROCEDURE'.
Topics
Community Discussion
No community discussion yet for this question.