Oracle Exam 1Z0-149 Topic 3 Question 18 Discussion

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

Question #: 18
Topic #: 3

[All 1Z0-149 Questions]

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

AFunction based indexes remain usable when replacing the function on which the index depends.

BObject privileges to execute a replaced function must be regranted to those users who had the privilege.

CThis clause can be used only for procedures and functions.

DA function definition can be modified without dropping and re-creating it.

EObject privileges to execute a replaced function are retained by those users who had the privileges.

Show Suggested Answer

Suggested Answer: A, E

by Carmelina at Dec 24, 2023, 12:34 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Rashad

6 days ago

This is a tricky one, but I'm going with B and D. Gotta love those object privileges! *wink wink*

upvoted 0 times

...

Yesenia

11 days ago

I'm not sure about statement E, but I think statement A is true because it mentions that function based indexes remain usable.

upvoted 0 times

...

Jeannine

12 days ago

E seems like the correct answer to me. Why would we need to regrrant privileges if the users already had them?

upvoted 0 times

...

Glory

12 days ago

I agree with you, Leonardo. I also believe statement E is true as it mentions that object privileges are retained.

upvoted 0 times

...

Leonardo

13 days ago

I think statement D is true because it allows modifying a function without recreating it.

upvoted 0 times

...

Ashley

15 days ago

I believe statement E is also true. It mentions that object privileges are retained for users.

upvoted 0 times

...

Lashawn

18 days ago

I think D is the right answer. Being able to modify a function definition without dropping and re-creating it is a huge time-saver.

upvoted 0 times

...

Rodolfo

22 days ago

I agree with Lynda. Statement D makes sense for efficiency in managing named subprograms.

upvoted 0 times

...

Lynda

26 days ago

I think statement D is true because it allows modifying a function without dropping it.

upvoted 0 times

...