1Z0-071 Data Manipulation Language (DML)

Question 1

Which DML statement adds a new row to a table?

Accepted Answer

INSERT

Answer

INSERT adds one or more new rows to a table using either the VALUES clause or a subquery.

Question 2

What does the COMMIT statement do in Oracle SQL?

Accepted Answer

Saves all pending DML changes to the database permanently

Answer

COMMIT makes all DML changes since the last COMMIT or ROLLBACK permanent and visible to other sessions.

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

UPDATE uses the SET clause to assign new values and a WHERE clause to target specific rows.

Question 4

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

Accepted Answer

All rows in the table are deleted

Answer

DELETE without a WHERE clause removes every row from the table while keeping the table structure intact.

Question 5

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

Accepted Answer

MERGE

Answer

MERGE (also called an upsert) matches source rows to target rows and inserts new ones or updates existing ones conditionally.

1Z0-071 - Oracle Database SQL Certified Associate Practice Test