Question
The ratio of age of A and his son is 11:3. If the
difference of their ages 5 year ago is 24, then find the sum of ages of A and his son 14 year hence?Solution
Let the present age of Raman and his son be 11x and 3x respectively. => 11x – 3x = 24 ∴  x = 3 Required sum = 14 × 3 + 28 = 70 years
Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
Which operator is used for pattern matching in SQL?
A transaction in DBMS is said to be atomic if:
What is the main function of a PL/SQL `TRIGGER`?
What is the result of SELECT COUNT(NULL) on any table?
Which command removes all rows but keeps table structure?
Which SQL function returns the largest value in a column?
Which operator is used to combine results of two SELECT queries and remove duplicates?
Which of the following can be used to avoid duplicate entries in a column?
Relevant for Exams:
