Question
Which SQL statement is used to modify existing data in a
database table?Solution
UPDATE is used to change or modify the existing data in the database table.
There was the leakage in the Oil container. If 10 litre of oil is leaked out per day then it would have lasted for 25 days and if the leakage was 16 lit...
Pipe ‘A’ can fill a tank in 10 hours while pipe ‘B’ can empty it in 12 hours. They were operated on alternate hours starting with pipe ‘A’. ...
Two inlet pipes 'A' and 'B' can fill an empty tank in 60 minutes and 90 minutes, respectively. Another outlet pipe 'C' can empty the tank in 180 minutes...
Pipe ‘A’ can fill 25% of a tank in 6 hours while pipe ‘B’ takes 40 hours to empty fully filled tank. Pipe ‘A’ is ope...
Pipe ‘A’ takes 60 hours to fill a tank. Pipe ‘B’ takes 120 hours to empty it. If both are opened together, find the time required to fill 50% o...
Pipes ‘P’ and ‘Q’ alone can fill a tank in 10 minutes and 25 minutes, respectively, while pipe ‘R’ can empty the same tank in 50 minutes. If...
Pipe ‘A’ can fill a tank in 12 hours while pipe ‘B’ takes 15 hours to empty it. Pipe ‘A’ is opened alone when the tank was empty and after 1...
Two inlet pipes M and N alone can fill a tank in 12 hours and 15 hours respectively and an outlet pipe P alone can empty the whole tank in 10 hours. Fir...
- Pipe ‘P’ alone can fill a tank in 12 minutes. If pipes ‘P’ and ‘Q’ are operated together, they fill the tank in 16 minutes. Find the time taken...
Pipes ‘A’ and ‘B’ can fill a tank in 6 hours and 9 hours, respectively. If pipe ‘C’ is opened along with pipes ‘A’ and ‘B’, then the...
Relevant for Exams:
