Question
A and B together started a business with initial
investment in the ratio of 1:4, respectively. The time-period of investment for A and B is in the ratio of 4:7, respectively. Find the profit share of B, if the profit share of A is Rs. 7000.Solution
Ratio of the profit share of A to B = (1 × 4): (4 × 7) = 1: 7 Profit share of B = (7/1) × 7000 = Rs. 49000
What is an SQL `VIEW`?
Which of the following is a mandatory component of a PL/SQL function's definition?
Materialized views differ from normal views because:
Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
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?
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?
What is the correct sequence of operations for using an explicit PL/SQL cursor?
Which SQL constraint ensures a column cannot have NULL values?
Which SQL clause is used to filter records based on aggregate functions?
