Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Oracle Exam 1Z0-071 Topic 6 Question 110 Discussion

Actual exam question for Oracle's 1Z0-071 exam
Question #: 110
Topic #: 6
[All 1Z0-071 Questions]

Table HR.EMPLOYEES contains a row where the EMPLOYEES _ID is 109.

User ALICE has no privileges to access HR.EMPLOYEES.

User ALICE starts a session.

User HR. starts a session and successfully executes these statements:

GRANT DELETE ON employees TO alice;

UPDATE employees SET salary = 24000 WHERE employee_id = 109;

In her existing session ALICE then executes:

DELETE FROM hr.employees WHERE employee_id = 109;

What is the result?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Sage at Jan 13, 2025, 10:40 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Myra
2 months ago
I wonder if the HR department has a sense of humor. Maybe they'll grant ALICE full admin privileges as a prank. That would make for an interesting day at the office!
upvoted 0 times
...
Rocco
2 months ago
I hope the correct answer isn't something like 'The database will self-destruct in 5 seconds.' That would be a real plot twist!
upvoted 0 times
Jani
1 months ago
C) The delete command will wait for HR's transaction to end then return an error.
upvoted 0 times
...
Mabel
1 months ago
B) The DELETE command will wait for HR's transaction to end then delete the row.
upvoted 0 times
...
Sarah
1 months ago
A) The DELETE command will immediately delete the row.
upvoted 0 times
...
...
Nicolette
2 months ago
This is a tricky one, but I think B is the right answer. ALICE has to wait for HR's transaction to finish before she can delete the row, otherwise it would be a permissions issue.
upvoted 0 times
...
Cornell
2 months ago
D all the way! The delete command will immediately return an error. ALICE can't delete from a table she doesn't have access to, even if HR grants her DELETE privileges.
upvoted 0 times
...
Olive
2 months ago
Hmm, I'm going to go with C. The delete command will wait for HR's transaction to end then return an error. ALICE doesn't have permissions to delete from that table, so it should fail even after the UPDATE is done.
upvoted 0 times
...
Alyce
2 months ago
I think the correct answer is B. The DELETE command will wait for HR's transaction to end then delete the row. ALICE doesn't have direct access to the HR.EMPLOYEES table, so the DELETE can only happen after HR's UPDATE transaction is complete.
upvoted 0 times
Shelia
9 days ago
C) The delete command will wait for HR's transaction to end then return an error.
upvoted 0 times
...
Loren
10 days ago
B) The DELETE command will wait for HR's transaction to end then delete the row.
upvoted 0 times
...
Tegan
13 days ago
A) The DELETE command will immediately delete the row.
upvoted 0 times
...
...
German
3 months ago
I believe the DELETE command will wait for HR's transaction to end then delete the row.
upvoted 0 times
...
Kattie
3 months ago
I agree with Queen, because HR granted DELETE privilege to her.
upvoted 0 times
...
Queen
3 months ago
I think the DELETE command will immediately delete the row.
upvoted 0 times
...

Save Cancel