Question
Worker ‘P’ can finish a task in 54 days, which is 18
days quicker than worker ‘Q’. If they take turns daily starting with ‘P’, find the total time (in days) to complete the task.Solution
ATQ,
Time taken by 'Q' = 54 + 18 = 72 days Let total work be 216 units (LCM of 54 and 72) Efficiency of 'P' = 216 ÷ 54 = 4 units/day Efficiency of 'Q' = 216 ÷ 72 = 3 units/day Work in 2 days = 4 + 3 = 7 units Work in 60 days = 7 × 30 = 210 units Remaining work = 216 - 210 = 6 units Time by 'P' to finish remaining = 6 ÷ 4 = 1.5 days Hence, final Answer: 60 + 1.5 = 61.5 days
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
What is the main function of a PL/SQL `TRIGGER`?
Which operator is used for pattern matching in SQL?
Which SQL constraint ensures a column cannot have NULL values?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which type of trigger fires once for each row affected by the triggering DML statement?
Which SQL command is used to remove a table completely?
Which SQL function returns the number of rows in a table?
Which SQL keyword is used to remove duplicate records from a query result?
