Oracle Exam 1Z0-116 Topic 10 Question 35 Discussion

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

Question #: 35
Topic #: 10

[All 1Z0-116 Questions]

Which two privileges can be restricted at the column level?

ASELECT

BINSERT

CREVOKE

DUPDATE

EGRANT

FDELETE

Show Suggested Answer

Suggested Answer: A, D

by Brock at Nov 21, 2023, 02:53 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Farrah

2 months ago

Wait, so I can't restrict the GRANT privilege at the column level? That's like the database equivalent of being able to give but not take away superpowers. What a letdown.

upvoted 0 times

Beula

7 days ago

Yeah, it's a limitation but we have to work with what we have.

upvoted 0 times

...

Xenia

12 days ago

I guess they want to make sure certain powers can't be taken away at a granular level.

upvoted 0 times

...

Cornell

13 days ago

It would be useful to restrict GRANT at the column level, but unfortunately it's not possible.

upvoted 0 times

...

Melodie

16 days ago

You can only restrict SELECT and UPDATE privileges at the column level.

upvoted 0 times

...

Cammy

27 days ago

Yeah, it's a bit disappointing that you can't restrict the GRANT privilege.

upvoted 0 times

...

Alesia

29 days ago

No, you can't restrict the GRANT privilege at the column level.

upvoted 0 times

...

Tamekia

1 months ago

You can restrict SELECT and UPDATE privileges at the column level.

upvoted 0 times

...

Carey

2 months ago

This is a tricky one. I was going to choose A and D, but now I'm second-guessing myself. Maybe I should just stick to the classics and go with A and D.

upvoted 0 times

...

Ira

2 months ago

I'm not sure about C and E, but I'm pretty confident that A, D, and F are the correct answers. You can definitely restrict SELECT, UPDATE, and DELETE at the column level.

upvoted 0 times

...

Brandon

2 months ago

Hmm, I think C and E are also valid options. You can REVOKE and GRANT privileges at the column level, right?

upvoted 0 times

Ayesha

27 days ago

That's right. REVOKE and GRANT can be used to restrict privileges at the column level.

upvoted 0 times

...

Micheal

28 days ago

Yes, you are correct. C and E are valid options for restricting privileges at the column level.

upvoted 0 times

...

Denae

29 days ago

That's right. REVOKE and GRANT can be used to restrict privileges at the column level.

upvoted 0 times

...

Markus

2 months ago

Yes, you are correct. C and E are valid options for restricting privileges at the column level.

upvoted 0 times

...

Selma

2 months ago

A and D seem like the obvious choices here. I'm pretty sure you can restrict SELECT and UPDATE at the column level.

upvoted 0 times

...

Michel

3 months ago

I believe REVOKE and GRANT can also be restricted at the column level, not just SELECT and UPDATE.

upvoted 0 times

...

Josephine

3 months ago

I agree with Ryan. SELECT and UPDATE are the privileges that can be restricted at the column level.

upvoted 0 times

...

Ryan

3 months ago

I think the privileges that can be restricted at the column level are SELECT and UPDATE.

upvoted 0 times

...