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 :
A, B and C enter into a partnership, A invest 3X + 1000, B invest X + 3000 and C invest X + 1500 for one year if B share is 20000 from total profit of 4...
‘A’ and ‘B’ started a business by investing Rs.7500 and Rs. 9000, respectively. 4 months later, ‘C’ joined them with an investment equal to ...
A invest twice the sum invested by B and withdraws half of sum after 4 months and again withdraws half of the remaining sum after 6 months. Find ratio o...
Manoj and Naveen started a business with the investment of Rs. (y-900) and Rs. (y+1300) respectively. After four months of the start of business, the in...
Raj invested Rs.35000 in a business. After 6 months, Rohan joins him with an investment of Rs.P. If at the end of the year the profit is Rs.60000 and pr...
If a sum of money is to be divided among A, B, C such that A’s share is equal to twice B’s share and B’s share is 6 times C’s share then their s...
P started a business with an investment of Rs.10000, after 6 months Q joined him with Rs.12000 and after another 6 months R joined them with Rs.15000. I...
P, Q, and R invest ₹15,000, ₹20,000, and ₹25,000, respectively, to start a business. At the end of the year, the total profit is ₹60,000. P, as ...
P and Q started a business by investing Rs.5600 and Rs.4000 respectively. After 4 months, Q increased his investment by a certain percentage such that a...
‘M’ started a business with an investment of Rs. 4500. After 2 months ‘N’ joins the business with an investment of Rs. 3000. If the total profit...