228k views
0 votes
The ____________________ command is used to permanently update a table and allow other users to view the changed data. ​

a. PERMANENT
b. COMMIT
c. UPDATE
d. APPLY

User Ress
by
8.5k points

1 Answer

4 votes

Final answer:

The COMMIT command is used to permanently update a table and make the changes visible to other users. COMMIT finalizes transactions in a database, adhering to the ACID principles.

Step-by-step explanation:

The command used to permanently update a table and allow other users to view the changed data in SQL is the COMMIT command. This command is essential when performing transactions in a database management system. After making changes to a database with commands such as INSERT, DELETE, or UPDATE, a COMMIT must be issued to permanently save those changes. If the commit is not performed, the changes can be rolled back and will not be seen by other users accessing the database. It's part of the transaction control language in SQL, which ensures the atomicity, consistency, isolation, and durability (ACID) properties of database transactions.

User Kukis
by
7.9k points