Question
The Reserve Bank of India (RBI) has announced the launch
of a special 100-day campaign to trace and settle unclaimed deposits in every district of the country. The campaign began from 1st June 2023. What is the purpose of the campaign?Solution
The Reserve Bank of India (RBI) has announced the launch of a special 100-day campaign to trace and settle unclaimed deposits in every district of the country. Under the campaign, which will begin on June 1, 2023, banks will trace and settle their top 100 unclaimed deposits in each district. The move is aimed at reducing the quantum of unclaimed deposits in the banking system and returning such deposits to their rightful owners.
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?