Oracle Exam 1Z0-908 Topic 10 Question 39 Discussion

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

Question #: 39
Topic #: 10

You encountered an insufficient privilege error in the middle of a long transaction.

The database administrator is informed and immediately grants the required privilege:

GRANT UPDATE ON world.city TO 'user1';

How can you proceed with your transaction with the least interruption?

ARoll back the transaction and start the transaction again in the same session.

BRe-execute the failed statement in your transaction.

CChange the default database and re-execute the failed statement in your transaction.

DClose the connection, reconnect, and start the transaction again.

Show Suggested Answer

Suggested Answer: B

by Ronny at May 04, 2022, 11:53 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!