Question
The average age of A, B and C is 25 years, while the
average age of B, A and D is 21 years. If the ratio of the age of C and D is 5:3, respectively, then find the age of D.Solution
Sum of ages of A, B and C = 25 × 3 = 75 years Sum of ages of B, A and D = 21 × 3 = 63 years So, C – D = 75 – 63 = 12 years Let the age of C and D be 5x and 3x years, respectively. 5x – 3x = 12 2x = 12 x = 6 So, age of D = 3x = 18 years.
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
Which of the following is a mandatory component of a PL/SQL function's definition?
Which SQL statement combines the results of two queries and removes duplicates?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which operator is used to combine results of two SELECT queries and remove duplicates?
Which of the following statements about SQL `INDEXES` is generally TRUE?
What is the main function of a PL/SQL `TRIGGER`?
Which join returns rows from the left table even when there is no matching row in the right table, filling with NULLs for the right side?
Which type of trigger fires once for each row affected by the triggering DML statement?
Which of the following is a common use case for a PL/SQL trigger?
Relevant for Exams:
