Oracle Exam 1Z0-149 Topic 6 Question 12 Discussion

Actual exam question for Oracle's 1Z0-149 exam

Question #: 12
Topic #: 6

[All 1Z0-149 Questions]

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

AThe PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

BThe NOCOPY hint asks the compiler to pass the actual parameters by reference.

CA deterministic function's results always depend on the state of session variables.

DThe NOCOPY hint asks the compiler to pass the actual parameters by value.

EA function is deterministic if it always returns the same result for a specific combination of input values.

FThe PARALLEL_ENABLE clause can be specified for a nested function.

GA 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

Suggested Answer: A, D

by Cherry at Aug 07, 2023, 04:24 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-149 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Ramonita

1 months ago

Option D is a trap! The NOCOPY hint is about passing parameters by reference, not value.

upvoted 0 times

...

Fatima

1 months ago

Wait, is the PARALLEL_ENABLE clause only for functions? I'm so confused. I'll just pick E, G, and hope for the best.

upvoted 0 times

...

Justine

1 months ago

Haha, option C is funny. Session variables? Really? I'll go with E, F, and G.

upvoted 0 times

Evelynn

14 days ago

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.

upvoted 0 times

...

Lewis

20 days ago

F) The PARALLEL_ENABLE clause can be specified for a nested function.

upvoted 0 times

...

Marva

22 days ago

E) A function is deterministic if it always returns the same result for a specific combination of input values.

upvoted 0 times

...

2 months ago

I'm not sure about the NOCOPY hint, but I think options A and G are also true.

upvoted 0 times

King

19 days ago

The NOCOPY hint asks the compiler to pass actual parameters by reference, so option B is not true.

upvoted 0 times

...

Nakita

21 days ago

Option G is correct because a function with PARALLEL_ENABLE can be executed in parallel in a SELECT statement.

upvoted 0 times

...

Audra

1 months ago

I think option E is true because a deterministic function always returns the same result for a specific input.

upvoted 0 times

...

3 months ago

I think option E is true because a deterministic function always returns the same result for a specific input.

upvoted 0 times

...