Question
'M' allocates 20% of his income to food and 40% of the
remaining amount to rent. The expenditure on education is four times higher than his savings, which constitute 1/18th of his income. In addition, his miscellaneous expenses, excluding food, rent, and education, amount to Rs. 9100. Determine the combined amount spent by 'M' on food and rent.Solution
ATQ, Let the total income of 'M' be Rs.'18a' Therefore, savings of 'M'= (1/18) × 18a = Rs.'a' Amount spend by him on education = 4 × a = Rs. 4a Amount spent by him on food = 0.2 × 18a = Rs. 3.6a Amount spent by him on rent = 0.4 × 0.8 × 18a = Rs. 5.76a ATQ, 18a – (a + 4a + 3.6a + 5.76a) = 9100 Or, a = 9100/3.64 = Rs. 2500 Required spending = (5.76a + 3.6a) = 9.36a = Rs.23400
Which SQL feature allows hierarchical queries (e.g., org chart traversal)?
Which SQL operator is used to search for a pattern in a column?
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL clause is used to filter records based on aggregate functions?
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
Which of the following is a mandatory component of a PL/SQL function's definition?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
What is the result of SELECT COUNT(NULL) on any table?
Which SQL function is used to calculate the average of a numeric column?
Relevant for Exams:
