Oracle Exam 1Z0-071 Topic 11 Question 58 Discussion

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

Question #: 58
Topic #: 11

[All 1Z0-071 Questions]

You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:

1. SELECT

2. INSERT

3. UPDATE

4. DELETE

You connect to the database instance an perform an update to some of the rows in

EMPLOYEE_RECORDS, but don't commit yet.

Andrew connects to the database instance and queries the table

No othet user are accessing the table

Which two statements ate true at this point?

AAndrew will be able to modify any rows in the table that have not been modified by your transaction

BAndrew will be unable to see the changes you have made

CAndrew will be able to see the changes you habe made

DAndrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

EAndrew will be able to SELECT from the table, but be unable to modify any existing rows.

Show Suggested Answer

Suggested Answer: A, B

by Lashon at Jun 16, 2022, 12:28 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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