Question
A container contains a mixture of wine and water in the
ratio of 4:1. 150 litres of the mixture was taken out and 50 litres of water was added to it. If the water was 40% in the resultant mixture, what was the initial quantity of the mixture in the container?Solution
Wine water 4xx Total = 5 x 150 litre of mixture taken out Wine = 4/5×150 = 120 Water = 1/5×150 = 30 Left Wine in mixture =4x– 120 Left Water = (x – 30) + 50 = x + 20 According to the question (x+20)/(4x-120)=40/60 60 x + 1200 = 160x – 4800 100x = 6000 ∴ x= 60 Initial quantity of mixture = 4 x + x = 5 x Initial quantity of mixture = 5 (60) = 300 litres
Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
SQL Injection can be prevented by all EXCEPT:
In normalization, which normal form removes transitive dependencies?
Which SQL clause is used to filter groups after aggregation (i.e., having aggregated value conditions)?
Which of the following SQL constructs avoids returning duplicate rows?
When does an implicit cursor get automatically declared and managed by PL/SQL?
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which type of trigger fires once for each row affected by the triggering DML statement?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL command is used to modify existing records in a table?