Oracle SQL Oracle SQL DML Operations

Question 1

Which Oracle SQL statement inserts multiple rows in a single operation using a subquery?

Accepted Answer

INSERT INTO ... SELECT

Answer

INSERT ALL

Answer

INSERT INTO ... VALUES ()()()

Answer

BULK INSERT

Question 2

What does the MERGE statement do in Oracle SQL?

Accepted Answer

Performs INSERT, UPDATE, or DELETE based on matching conditions in a single statement

Answer

Combines two tables permanently

Answer

Merges duplicate rows within a table

Answer

Joins two schemas together

Question 3

Which Oracle SQL statement removes ALL rows from a table without logging individual row deletions?

Accepted Answer

TRUNCATE TABLE table

Answer

DELETE FROM table

Answer

DROP TABLE table

Answer

REMOVE ALL FROM table

Question 4

In Oracle SQL, which DML statement modifies existing rows in a table?

Accepted Answer

UPDATE

Answer

MODIFY

Answer

ALTER

Answer

CHANGE

Question 5

What does the RETURNING clause do in an Oracle SQL DML statement?

Accepted Answer

Returns affected row values into a variable or bind variable

Answer

Rolls back the DML operation

Answer

Returns the number of rows affected

Answer

Returns to the previous transaction state

Question 6

Which Oracle SQL statement permanently saves changes made by DML operations?

Accepted Answer

COMMIT

Answer

SAVE

Answer

APPLY

Answer

FINALIZE