（158）Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all that apply.)

A. It locks only the columns specified in the SELECT list.

B. It locks the rows that satisfy the condition in the SELECT statement.

C. It can be used only in SELECT statements that are based on a single table.

D. It can be used in SELECT statements that are based on a single or multiple tables.

E. After it is enforced by a SELECT statement, no other query can access the same rows until a COMMIT or ROLLBACK is issued.

答案：（B、D）

解析:

E（X），查询还是可以查询的。

ITPub博客

OCP 1Z0 051 158