Question
The population of a town increases by 5% every year. If
the population of the town at the beginning of 2020 was 50,000, what will the population be at the beginning of 2023?Solution
The population increases by 5% each year, so the population at the beginning of each year is multiplied by 1.05. Population at the beginning of 2023 = 50,000 × (1.05)^3 = 50,000 × 1.157625 = 57,881.25 ≈ 57,881 Correct Option: b.
Which SQL feature allows hierarchical queries (e.g., org chart traversal)?
Which SQL operator is used to search for a pattern in a column?
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL clause is used to filter records based on aggregate functions?
Which PL/SQL cursor attribute returns `TRUE` if the most recent `FETCH` statement returned a row, and `FALSE` otherwise?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
Which of the following is a mandatory component of a PL/SQL function's definition?
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
What is the result of SELECT COUNT(NULL) on any table?
Which SQL function is used to calculate the average of a numeric column?
