Question

Contents of the PROMOTION table​

If a new row is added to the PROMOTION table, which of the following will make the change permanent?​
a) COMMIT;
b) SAVE;
c) APPLY;
d) FINALIZE;

Answer 1

To make a change permanent after adding a new row to the PROMOTION table, the COMMIT command must be used in SQL. This action saves all changes made during the transaction to the database.

Step-by-step explanation:

When a new row is added to the PROMOTION table in a database, making the change permanent requires a specific action. The correct answer to this question is a) COMMIT. The COMMIT command in SQL (Structured Query Language) is used after a transaction to save all the changes made during that transaction to the database. This means that once the COMMIT command is executed, the new row that was added to the PROMOTION table will be saved and the change becomes permanent and cannot be undone except by executing another transaction. The other options provided, such as SAVE, APPLY, or FINALIZE, are not standard SQL commands for making changes permanent in a database transaction context.