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.)
When a user performs updates on a table but does not commit, the changes are not visible to other users until a commit is done. Therefore, Andrew will be unable to see the changes you have made. However, Andrew will be able to modify any rows in the table that have not been modified by your transaction, as only the rows affected by your uncommitted transaction will be locked.
AE Correct
AE is correct
AE is correct
AE correct
AE Correct
A E are correct
AE is correct