Question
Ankush puts Rs. 8,000 into two separate Systematic
Investment Plans (SIPs) at a compound interest rate of 20% per annum. In SIP 'X', the investment is for 2 years with annual compounding, while in SIP 'Y', the investment period is 18 months with semi-annual compounding. Calculate the difference in interest generated by the two SIPs.Solution
ATQ, Compound interest = Sum × {1 + (rate of interest/100) }time period - Sum For SIP 'X': Interest earned = 8000 × {1 + (20/100) }2- 8000 = 8000 × (1.2)2 - 8000 = 8000 × (1.44 - 1) = Rs.3,520 For SIP 'Y': Effective rate of interest = 20 ÷ 2 = 10% per term Effective time period = (18/12) × 2 = 3 terms So, interest earned = 8000 × {1 + (10/100) }3 - 8000 = 8000 × (1.1)3- 8000 = 8000 × (1.331 - 1) = Rs. 2,648 So, required difference = 3520 - 2648 = Rs. 872
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which of the following statements about SQL `INDEXES` is generally TRUE?
What is the correct sequence of operations for using an explicit PL/SQL cursor?
Which clause is used to sort query results in SQL?
Which command removes all rows but keeps table structure?
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?
Which of the following is a mandatory component of a PL/SQL function's definition?
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL constraint ensures that a column’s values are unique across the table?
Which SQL keyword prevents duplicate rows in result?
Relevant for Exams:
