Oracle Exam 1Z0-888 Topic 3 Question 93 Discussion

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

Question #: 93
Topic #: 3

Consider:

Which statement best describes the meaning of the values in the ref columns?

Aworld.City.CountryCode is used as the primary key for the Country table.

BNo indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

Cworld.City.CountryCode is used to sort the rows in the City table.

DNo indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.

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

11 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

10 months ago

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

upvoted 0 times

...

Celestina

10 months ago

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

upvoted 0 times

...

Patria

10 months ago

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

upvoted 0 times

...

Stefanie

11 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

10 months ago

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

upvoted 0 times

...

Cristy

10 months ago

B) It allows the use of stored routines.

upvoted 0 times

...

Van

11 months ago

A) It allows a client to process scripts.

upvoted 0 times

...

Phillip

11 months ago

I agree, granting too much access can be risky.

upvoted 0 times

...

Rebecka

11 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

11 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