1Z0-071 Data Manipulation Language (DML)

Question 1

Which DML statement adds a new row to a table?

Accepted Answer

INSERT

Answer

UPDATE

Answer

MERGE

Answer

CREATE

Question 2

What does the COMMIT statement do in Oracle SQL?

Accepted Answer

Saves all pending DML changes to the database permanently

Answer

Rolls back all changes since the last COMMIT

Answer

Creates a savepoint

Answer

Locks the table for exclusive access

Question 3

Which statement correctly updates the salary of employee 100 to 9000?

Accepted Answer

UPDATE employees SET salary = 9000 WHERE employee_id = 100

Answer

MODIFY employees SET salary = 9000 WHERE employee_id = 100

Answer

UPDATE employees VALUES (9000) WHERE employee_id = 100

Answer

ALTER employees SET salary = 9000 WHERE employee_id = 100

Question 4

What happens if you issue a DELETE without a WHERE clause?

Accepted Answer

All rows in the table are deleted

Answer

An error is raised

Answer

Only the first row is deleted

Answer

Only duplicate rows are deleted

Question 5

Which DML statement can both insert new rows and update existing rows in a single operation?

Accepted Answer

MERGE

Answer

UPSERT

Answer

INSERT OR UPDATE

Answer

REPLACE

Question 6

What does ROLLBACK do in a DML transaction?

Accepted Answer

Undoes all changes since the last COMMIT or ROLLBACK

Answer

Saves changes permanently

Answer

Deletes all rows in a table

Answer

Closes the database session