Question
A borrowed Rs. 9500 from B for his business. How much
amount A will return to B at the end of 36 months such that the sum was borrowed at simple interest of 25% p.a.?Solution
ATQ, Principal (P) = Rs. 9500 Rate (R) = 25% per annum Time (T) = 36 months = 3 years Simple Interest (SI) formula:
Total amount to return = 9500+7125 =Â Rs.16,625 Hence, A will return Rs.16,625 after 36 months.
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?