Question
A principal amount is invested at an annual simple
interest rate of R%, growing to Rs. 9,500 over 5 years and Rs. 13,100 over 9 years. Calculate the total interest earned if this principal is invested at an increased rate of (R + 7)% per annum for 2 years.Solution
Simple interest for 4 years = 13100 β 9500 = 3600 Simple interest for 1 year = 3600/4 = Rs. 900 Principal amount = 9500 β 5 Γ 900 = Rs. 5000 So, R = 900/50000 Γ 100 = 18% Desired interest = 5000 Γ 0.25 Γ 2 = Rs. 2500 Hence, option b.
Which command removes all rows but keeps table structure?
Which operator is used for pattern matching in SQL?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
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?
Deadlock in DBMS can be prevented using:
What is an SQL `VIEW`?
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?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?