If application A issues the following SQL statement, which of the following statements about
concurrency is true?
SELECT deptno, deptname, mgrno FROM dept WHERE admrdept = ‘A00’ FOR READ ONLY
WITH RS
A.
Rows accessed by application A can be seen by other applications.
B.
Rows accessed by application A cannot be seen by other applications.
C.
Application A can see uncommitted changes made by other applications.
D.
Results produced by re-execution of the statement by application A will not be affected by other
applications.