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?

AThe DELETE command will immediately delete the row.

BThe DELETE command will wait for HR's transaction to end then delete the row.

CThe delete command will wait for HR's transaction to end then return an error.

DThe delete command will immediately return an error.

Show Suggested 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

4 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

4 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

3 months ago

C) The delete command will wait for HR's transaction to end then return an error.

upvoted 0 times

...

Mabel

3 months ago

B) The DELETE command will wait for HR's transaction to end then delete the row.

upvoted 0 times

...

Sarah

4 months ago

A) The DELETE command will immediately delete the row.

upvoted 0 times

...

Nicolette

4 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

4 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

...

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

4 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

3 months ago

C) The delete command will wait for HR's transaction to end then return an error.

upvoted 0 times

...

Loren

3 months ago

B) The DELETE command will wait for HR's transaction to end then delete the row.

upvoted 0 times

...

Tegan

3 months ago

A) The DELETE command will immediately delete the row.

upvoted 0 times

...

German

5 months ago

I believe the DELETE command will wait for HR's transaction to end then delete the row.

upvoted 0 times

...

Kattie

5 months ago

I agree with Queen, because HR granted DELETE privilege to her.

upvoted 0 times

...

Queen

5 months ago

I think the DELETE command will immediately delete the row.

upvoted 0 times

...

Oracle Exam 1Z0-071 Topic 6 Question 110 Discussion

Contribute your Thoughts:

Myra

Rocco

Jani

Mabel

Sarah

Nicolette

Cornell

Olive

Alyce

Shelia

Loren

Tegan

German

Kattie

Queen