Question
Which database management system feature helps ensure
that all transactions are completed successfully and consistently?Solution
Atomicity is a property of database transactions that ensures each transaction is completed entirely or not at all. This means that if a transaction cannot be completed successfully, it will be rolled back to its previous state, maintaining the database's integrity and consistency. a) Data Integrity ensures the accuracy and consistency of data but is not specifically about transaction completion. c) Concurrency Control manages simultaneous transaction execution but does not guarantee complete transaction success. d) Durability ensures that once a transaction is committed, it is permanent, but it does not address incomplete transactions. e) Consistency ensures that transactions lead to a valid state of the database but does not handle incomplete transactions directly.
An item is marked at 25% above its cost price. A discount is given on the marked price, and the profit earned from selling the item is three-fifths of t...
- Manoj bought a laptop and sold it to Raj at 25% profit. Raj then sold it to Simran making a 12% profit. If Simran paid Rs. 700, what was Manoj’s purchase...
Three partners ‘A’, ‘B’ and ‘C’ started a business by investing in the ratio 2:5:6 respectively and the ratio of time for which they made th...
A shopkeeper sold an article at profit of 10%. Had he bought it at 10% less and sold it for Rs. 3 more, then he would have earned a profit of 25%. Find ...
Two cycles were sold at 1499 Rs each. First was sold at 25% profit and second at 25% loss. Find the overall profit or loss.
The difference between the cost price and sale price of an article is Rs.600 and the profit is 30%. Find the selling price.
A certain article is marked up by 30% above its cost price and sold for Rs. 5200, making a profit of 25%. Find the marked price of the article.
A school bag is sold for Rs.540 after giving two successive discounts of 10% and 20%. If school bag is marked up by Rs.500 above its cost price, then fi...
The difference between the selling price on a discount of 32% and two successive discounts of 20% each on a certain bill is ₹25. Find the actual amoun...
A watch was sold with a 20% profit. The marked price of the watch over its cost price is Rs. 960. If the ratio of profit earned to discount offered is 1...
