Question
The ratio of age of ‘B’ after 5 years from now and
age of ‘C’ 4 years ago from now is 7:4, respectively. The present age of ‘C’ is 40% of the present age of ‘A’. If present age of ‘A’ is 50 years then find the present age of ‘B’.Solution
Present age of ‘C’ = 0.4 × 50 = 20 years 4 years ago from now, age of ‘C’ = 20 – 4 = 16 years 5 years hence from now, age of ‘B’ = 16 × (7/4) = 28 years Present age of ‘B’ = 28 – 5 = 23 years
Which SQL keyword prevents duplicate rows in result?
Which of the following SQL constructs avoids returning duplicate rows?
What is the output of this SQL snippet if the price column contains NULL values?
SELECT SUM(price) FROM products;
Which SQL constraint ensures that a column’s values are unique across the table?
Which clause is used to sort query results in SQL?
Which SQL command is used to modify existing records in a table?
What is the primary purpose of a `SEQUENCE` in SQL?
What is an SQL `VIEW`?
Which SQL function returns the largest value in a column?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
