Start learning 50% faster. Sign in now
Transaction Control Language (TCL) commands in SQL are used to manage transactions in a database, ensuring that operations are executed reliably. COMMIT is a TCL command that finalizes a transaction, making all its changes permanent in the database. For example, in a banking application, if a transaction involves debiting one account and crediting another, the COMMIT command ensures these changes are saved only when both operations succeed. This guarantees data integrity. Without TCL commands like COMMIT, rollback mechanisms would not work effectively, and transactional integrity could be compromised. Why Other Options Are Incorrect :
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
Which of the following best defines the concept of the "Internet of Things" (IoT)?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?