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

1 years 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

11 months ago

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

upvoted 0 times

...

Celestina

12 months ago

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

upvoted 0 times

...

Patria

12 months ago

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

upvoted 0 times

...

Stefanie

1 years 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

12 months ago

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

upvoted 0 times

...

Cristy

1 years ago

B) It allows the use of stored routines.

upvoted 0 times

...

Van

1 years ago

A) It allows a client to process scripts.

upvoted 0 times

...

Phillip

1 years ago

I agree, granting too much access can be risky.

upvoted 0 times

...

Rebecka

1 years 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

1 years 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