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

ROLLBACK undoes all uncommitted DML changes in the current transaction, restoring the database to its state at the last COMMIT.

Question 2

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

Accepted Answer

SAVEPOINT

Answer

SAVEPOINT marks a named point in a transaction so that ROLLBACK TO SAVEPOINT can undo changes made after that point without canceling the entire transaction.

Question 3

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

Accepted Answer

They are committed automatically

Answer

Oracle automatically issues an implicit COMMIT before and after every DDL statement, permanently saving any pending DML changes.

Question 4

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

Accepted Answer

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

Answer

Listing column names in parentheses after the table name allows inserting values into specific columns; unspecified columns receive their default values or NULL.

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

This DELETE statement removes only the rows in the employees table where department_id equals 10, leaving other rows intact.

Oracle SQL Practice Test

Oracle SQL Practice Test

Oracle SQL Oracle SQL DML Operations 2