Oracle Database Administration I — Question 163

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

Answer options

• A. INSERT statements can insert NULLS explicitly into a 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. UPDATE statements can have different subqueries to specify the values for each updated column.

Correct answer: A, D, E

Explanation

Option A is correct because INSERT statements can indeed include NULL values explicitly. Option D is also accurate, as DELETE statements can target multiple rows using various conditions. Option E is correct as well, as UPDATE statements can utilize different subqueries for assigning values to each column. However, option B is incorrect because INSERT INTO...SELECT...FROM statements do not automatically commit unless specified. Option C is incorrect since DML statements do not require a primary key to be defined on a table.