Question
Novita's current age is 37.5% greater than Suzuka's,
with a difference of 15 years between their ages. Calculate the ratio of Novita's age to Suzuka's age 5 years from now.Solution
Let present age of Suzuka be '8x' years. So, present age of Novita = 8x X 1.375 = '11x' years ATQ; 11x - 8x = 15 Or, 3x = 15 So, x = 5 5 years hence from now, Age of Novita = 11x + 5 = 55 + 5 = 60 years Age of "b' = 8x + 5 = 40 + 5 = 45 years Required ratio = 60:45 = 4:3
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?