Question
The efficiency ratio of Neha, Karan, and Ishaan is
16:11:14, respectively. Together, they can complete a task in 30 days. Neha and Karan started the task, but after 20 days, Karan was replaced by Ishaan. In how many days was the entire task completed?Solution
ATQ,
Let the efficiencies of Neha, Karan, and Ishaan be 16x, 11x, and 14x units/day, respectively.
Total work = (16x + 11x + 14x) × 30 = 1230x units
Work done by Neha and Karan in 20 days = 20 × (16x + 11x) = 540x units
Remaining work = 1230x – 540x = 690x units
Time taken by Neha and Ishaan together = 690x / (16x + 14x) = 690x / 30x = 23 days
Total time to finish the work = 20 + 23 = 43 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?
Relevant for Exams:
