Oracle Exam 1Z0-888 Topic 3 Question 93 Discussion

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

Question #: 93
Topic #: 3

[All 1Z0-888 Questions]

Why should you be selective when granting the PROCESS privilege to an account?

AIt allows a client to process scripts.

BIt allows the use of stored routines.

CIt allows a client to see another user's queries with the SHOW PROCESSLIST command.

DIt allows a client to control running processes on a server.
References:

Show Suggested Answer

Suggested Answer: D

by Ilona at May 30, 2024, 03:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Serina

6 months ago

Personally, I'd go with Option B. Allowing the use of stored routines seems like a pretty powerful privilege to hand out willy-nilly. Better to be selective with that one.

upvoted 0 times

Johanna

5 months ago

It's better to control who can use stored routines on the server.

upvoted 0 times

...

Celestina

5 months ago

Definitely, it's important to be selective with that privilege.

upvoted 0 times

...

Patria

6 months ago

I agree, granting the PROCESS privilege for stored routines can be risky.

upvoted 0 times

...

Stefanie

6 months ago

Haha, I bet the person who wrote this question has had to deal with some serious server meltdowns from users who got a little too process-happy. Option D is the way to go, for sure.

upvoted 0 times

Bernadine

5 months ago

D) It allows a client to control running processes on a server.

upvoted 0 times

...

Cristy

6 months ago

B) It allows the use of stored routines.

upvoted 0 times

...

Van

6 months ago

A) It allows a client to process scripts.

upvoted 0 times

...

Phillip

6 months ago

I agree, granting too much access can be risky.

upvoted 0 times

...

Rebecka

6 months ago

I think Option C is the one to go with. Being able to see other users' queries could be a privacy concern, so we should be careful about who we grant that privilege to.

upvoted 0 times

...

Rusty

6 months ago

Option D is the correct answer. Granting the PROCESS privilege allows a client to control running processes on the server, which could be a security risk if given to the wrong account.

upvoted 0 times