Oracle Database SQL — Question 211

Which three statements are true about Data Manipulation Language (DML)?

Answer options

• A. UPDATE statements can have different subqueries to specify the values for each updated column.
• B. INSERT INTO…SELECT…FROM statements automatically commit.
• C. DML statements require a primary key be defined on a table.
• D. DELETE statements can remove multiple rows based on multiple conditions.
• E. INSERT statements can insert NULLs explicitly into a column.

Correct answer: A, D, E

Explanation

Option A is correct because UPDATE statements can indeed use various subqueries for different column values. Option D is also correct as DELETE statements can target multiple rows with various conditions. Option E is correct since INSERT statements can explicitly include NULL values. However, options B and C are incorrect; B is wrong because INSERT INTO…SELECT…FROM statements do not automatically commit unless in autocommit mode, and C is incorrect as DML statements do not require a primary key on a table.