Practice Test Geeks1Z0-071 - Oracle Database SQL Certified Associate Practice Test
← All 1Z0-071 Flashcard Decks

Data Manipulation Language (DML) Flashcards

6 cards from real 1Z0-071 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Data Manipulation Language (DML) flashcards as text

  1. Which DML statement adds a new row to a table?

    Answer: INSERT

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

  2. What does the COMMIT statement do in Oracle SQL?

    Answer: Saves all pending DML changes to the database permanently

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

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

    Answer: UPDATE employees SET salary = 9000 WHERE employee_id = 100

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

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

    Answer: All rows in the table are deleted

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

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

    Answer: MERGE

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

  6. What does ROLLBACK do in a DML transaction?

    Answer: Undoes all changes since the last COMMIT or ROLLBACK

    ROLLBACK reverses all uncommitted DML changes, restoring the data to its state at the last COMMIT.