【新题】ocp 062 2019年考试新题-3

  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

  (解析:把数据库变成限制会话状态,只会对以后的登录有影响,对已经登录的会话没有影响。)

  备注来自ocp3群:1015267481)

上一篇:(20)The most mysterious star in the universe


下一篇:(8)What makes a good life? Lessons from the longest study on happiness