Multiple choice

The ___ statement is used to save changes made to a table.

  1. Save All

  2. Save Now

  3. Commit

  4. Commits
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To save changes made to a table, the Commit statement can be issued. Commit is a part of TCL or Transaction Control Language. TCL statements are those statements that are used to save or cancel the changes made to a table. Commit is used for saving the changes whereas the rollback statement is used to cancel the changes. Oracle also provides the user to commit the changes automatically by typing the statement Set autocommit on.

Keep practicing — related questions