Question
Which of the following is not considered a part of
priority sector lending (PSL) by RBI?Solution
Investment in government securities is not classified under PSL. The other options fall under PSL categories defined by RBI.
Deadlock in DBMS can be prevented using:
To rename a column in a SELECT query result, you use:
Which SQL clause is used to group rows?
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?
Which SQL keyword removes duplicate rows automatically from results?
In normalization, which normal form removes transitive dependencies?
A transaction in DBMS is said to be atomic if:
Which SQL clause is used to filter results after a GROUP BY operation?
Which SQL function is used to calculate the average of a numeric column?