Oracle Database SQL — Question 53

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 and perform an update to some of the rows in EMPLOYEE_RECORDS, but do not commit yet.

Andrew connects to the database instance and queries the table.

No other users are accessing the table.

Which two statements are true at this point? (Choose two.)

Answer options

• A. Andrew will be unable to see the changes you have made.
• B. Andrew will be unable to perform any INSERTs, UPDATEs, or DELETEs on the table.
• C. Andrew will be able to SELECT from the table, but be unable to modify any existing rows.
• D. Andrew will be able to see the changes you have made.
• E. Andrew will be able to modify any rows in the table that have not been modified by your transaction.

Correct answer: A, E

Explanation

Answer A is correct because until you commit your changes, Andrew cannot see them due to transaction isolation. Answer E is also correct since Andrew can modify rows that you haven't changed, as his transaction is independent of yours. The other options are incorrect because Andrew retains the ability to perform SELECT operations and can modify unaffected rows.