Question
Alisha had Rs. 7500 with her. She invested 20% of the
sum at 7% p.a. and the rest at 13% p.a., both at simple interest for 6 years each. Find the total interest received by Alisha.Solution
ATQ, Interest received by Alisha at 20% of the sum = (0.20×7500×7×6)/100=Rs.630 Interest received by Alisha on 80% of the sum = (0.80×7500×13×6)/100=Rs.4680 Therefore, total interest received = 630 + 4680 = Rs. 5310
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?
Relevant for Exams:
