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

Exam 1z0-149 All Questions

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

Exam 1z0-149 topic 1 question 4 discussion

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

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

  • A. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
  • B. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
  • C. A deterministic function's results always depend on the state of session variables.
  • D. The NOCOPY hint asks the compiler to pass the actual parameters by value.
  • E. A function is deterministic if it always returns the same result for a specific combination of input values.
  • F. The PARALLEL_ENABLE clause can be specified for a nested function.
  • G. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.
Show Suggested Answer Hide Answer
Suggested Answer: BEG 🗳️
by PurpleStudio at March 12, 2023, 5:29 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
UnoriginalMe
2 months, 3 weeks ago
B, E, G
upvoted 1 times
...
TheOracleWasTaken
1 year, 4 months ago
he PARALLEL_ENABLE clause can appear in the following SQL statements: CREATE FUNCTION Statement CREATE PACKAGE Statement CREATE TYPE BODY Statement https://docs.oracle.com/en/database/oracle/oracle-database/21/lnpls/PARALLEL_ENABLE-clause.html#GUID-CFF3C7D3-6438-44C2-9FAF-569F246C37CA
upvoted 1 times
...
PurpleStudio
1 year, 10 months ago
B and E and G are TRUE!
upvoted 3 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