Question
The National Investigation Agency (NIA), with
headquarters in New Delhi, has special jurisdiction to investigate offenses related to:Solution
The National Investigation Agency (NIA), headquartered in New Delhi, has special jurisdiction to investigate offenses related to terrorism and certain acts threatening national security. Established in 2008 following the Mumbai terror attacks, the NIA is empowered to investigate terror-related crimes across states without special permission from state governments.
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?
