Oracle SQL Oracle SQL DML Operations 2

Question 1

What does ROLLBACK do in Oracle SQL?

Accepted Answer

Undoes all uncommitted DML changes in the current transaction

Answer

Deletes all rows in a table

Answer

Reverts DDL changes

Answer

Restores a previous database backup

Question 2

Which Oracle SQL feature allows you to set a named point within a transaction to partially roll back?

Accepted Answer

SAVEPOINT

Answer

CHECKPOINT

Answer

BOOKMARK

Answer

TRANSACTION MARK

Question 3

In Oracle SQL, what happens to uncommitted DML changes when a DDL statement is executed?

Accepted Answer

They are committed automatically

Answer

They are rolled back automatically

Answer

They are saved to a temp table

Answer

Nothing changes; DDL does not affect DML

Question 4

Which Oracle SQL INSERT syntax inserts data into specific columns only?

Accepted Answer

INSERT INTO table (col1, col2) VALUES (val1, val2)

Answer

INSERT INTO table VALUES (...) COLUMNS (...)

Answer

INSERT PARTIAL INTO table VALUES (val1, val2)

Answer

INSERT INTO table SET col1=val1, col2=val2

Question 5

What does DELETE FROM employees WHERE department_id = 10 do in Oracle SQL?

Accepted Answer

Removes all rows where department_id equals 10

Answer

Drops the employees table

Answer

Disables the department_id column

Answer

Marks department_id 10 as inactive

Question 6

Which Oracle SQL multi-table INSERT directs rows to different tables based on conditions?

Accepted Answer

INSERT ALL WHEN

Answer

CONDITIONAL INSERT

Answer

INSERT SWITCH

Answer

INSERT CASE