ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam
Go to Exam

Exam 1z0-148 topic 1 question 4 discussion

Actual exam question from Oracle's 1z0-148
Question #: 4
Topic #: 1
[All 1z0-148 Questions]

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

  • A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
  • B. To execute chunks in parallel, users must have CREATE JOB system privilege.
  • C. No specific system privileges are required to create or run parallel execution tasks.
  • D. Only DBAs can create or run parallel execution tasks.
  • E. Users with CREATE TASK privilege can create or run parallel execution tasks.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Reference -
https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm#ARPLS67331
(security model)
by Rakeshpro at Sept. 19, 2022, 3:44 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Rakeshpro
2 years, 4 months ago
Selected Answer: B
DBMS_PARALLEL_EXECUTE is a SYS-owned package which is granted to PUBLIC. Users who have the ADM_PARALLEL_EXECUTE_TASK role can perform administrative routines (qualified by the prefix ADM_) and access the DBA view. Apart from the administrative routines, all the subprograms refer to tasks owned by the current user. To execute chunks in parallel, you must have CREATE JOB system privilege. The CHUNK_BY_SQL, RUN_TASK, and RESUME_TASK subprograms require a query, and are executed using DBMS_SQL. Invokers of the DBMS_SQL interface must ensure that no query contains SQL injection.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago