重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: SELECT 查询算是DML吗？ [打印本页]

作者: Inkcup 时间: 2025-11-30 16:49
标题: SELECT 查询算是DML吗？
在OCP082参考题中：

31.In which three situations does a new transaction always start?

A) when issuing the first Data Manipulation Language(DML) statement after a COMMIT or ROLLBACK statement was issued in the same session

B) when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

C) when issuing a DML statement after a DML statement failed in the same session

D) when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

E) when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

F) when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

答案：ABE

选项A中，所说的DML一般是指增、删、改这三种“写”操作，查虽然也是DML，但这是一个“读”操作，因此A选项正确。

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)