Question
What is the maximum quantum of award/compensation that
can be awarded by Ombudsman of PFRDA?Solution
PFRDA appoints an ombudsman to resolve grievances relating to the National Pension System (NPS) and Atal Pension Yojana (APY). The Ombudsman has the power to pass orders and impose fines. Ombudsman can pass awards up to Rs. 10 lakh. Grievances could include issues like delay in remitting pension contributions to the NPS account, even though they have been deducted from the subscriber’s salary.
What is the primary purpose of a `SEQUENCE` in SQL?
Deadlock in DBMS can be prevented using:
Recursive CTEs are mainly used for:
Which of the following statements about SQL `INDEXES` is generally TRUE?
Which SQL keyword is used to remove duplicate records from a query result?
Which SQL statement combines the results of two queries and removes duplicates?
Which SQL function returns the largest value in a column?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
A `BEFORE INSERT` trigger fires:
What is the primary purpose of a `SEQUENCE` in SQL?