3.A database is open read write and the instance has multiple sessions some of which have active transactions.

You execute this command:

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

Which three are true about the active transactions?

A) They may continue to issue dml statements.

B) They may issue commit or rollback statements.

C) They may continue to issue queries.

D) They are suspended and unable to issue any statements.

E) They are terminated immediately.

F) They are rolled back automatically.

Answer：ABC

(解析：把數(shù)據(jù)庫變成限制會(huì)話狀態(tài)，只會(huì)對以后的登錄有影響，對已經(jīng)登錄的會(huì)話沒有影響。)