Question
Which of the following SQL commands is used to make
permanent changes to the database?Solution
The "COMMIT" command is used to make permanent changes to the database, saving the changes made in a transaction.
Income of Ravi is Rs. 52,800, out of which he spent 35% on daily expenses, 5% on phone bills and saves the rest. If his income is increased by 15% and h...
A number when reduced by 35% gives 195. Find the number?
In order to maximise his gain, a theatre owner decided to reduce the price of tickets by 10% and as a result of this, the sales of tickets increased by ...
A man donated 10%, 16% and 28% of his income to three NGOs ‘A’, ‘B’ and ‘C’, respectively. They spent 75%, 80% and 50% of respective sums re...
'M', 'N', and 'O' appeared in an exam. 'M' scored 40% marks in an exam which was 20 more than passing marks. Whereas 'N' scored 30% marks in the exam wh...
Raj saves Rs. 4500 more if he spends 65% of his income instead of 80%. Find the savings of Sanjay whose income is 25% more than that of Raj, and spends ...
40 Litres of water is added to 60 litres of a solution containing 40% alcohol . What is the concentration of alcohol in solution now?
Rajesh spent 40% and 20% of his monthly salary on food and rent, respectively. Of the remaining amount, he gave 15% and 30% to his mother and brother, r...
Sara has 150 kg of oranges (rotten and fresh). She sold 50% of the total oranges such that out of the remaining oranges, 30% are rotten. Find the percen...
There are 500 students in a college. 45% of them are boys. Among the boys and girls, 35% and 50% respectively are interested in music. How many students...
Relevant for Exams:
