Question
The current age ratio of Amit to Bishnu stands at 5:8.
Given that the ratio of Amit's age 9 years in the future to Bishnu's age 1 year in the past is 4:5, ascertain the age of Amit 5 years ahead from the present moment.Solution
Let, the present age of 'Amit' and 'Bishnu' be '5a' years and '8a' years. ATQ, [(5a + 9) /(8a - 1) ] = (4/5) Or, 5 × (5a + 9) = 4 × (8a - 1) Or, 25a + 45 = 32a - 4 Or, 32a - 25a = 45 + 4 Or, 7a = 49 Or, a = (49/7) So, a = 7 So, the age of 'Amit' 5 years hence from now = 5a + 5 = (5 × 7) + 5 = 40 years
Which SQL command is used to modify existing records in a table?
A materialized view differs from a normal view because it:
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
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 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?
SQL Injection can be prevented by all EXCEPT:
What is an SQL `VIEW`?
Deadlock in DBMS can be prevented using:
What is the primary purpose of a `SEQUENCE` in SQL?
Which SQL statement combines the results of two queries and removes duplicates?
Relevant for Exams:
