Question
A invests Rs 6000 in a business for the whole year. B
joins him later with an investment of Rs 8000. At the end of the year, the profit is divided between A and B in the ratio 3 : 2. After how many months from the start did B join the business?Solution
Profit is shared in the ratio of (capital × time). A’s investment-time = 6000 × 12 = 72000 Let B join after x months, so he invests for (12 − x) months. But simpler: let B’s investment time be t months. B’s investment-time = 8000 × t Ratio: A : B = 72000 : 8000t = 3 : 2 Divide by 1000: 72 : 8t = 3 : 2 Cross-multiply: 72 × 2 = 3 × 8t 144 = 24t t = 6 So B was in business for 6 months, meaning he joined after 12 − 6 = 6 months from the start.
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
SQL Injection can be prevented by all EXCEPT:
Which SQL operator is used to search for a pattern in a column?
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which SQL function returns the largest value in a column?
Which SQL command is used to modify existing records in a table?
Recursive CTEs are mainly used for:
What is the primary purpose of a PL/SQL `CURSOR`?
Which of the following can be used to avoid duplicate entries in a column?