Question
According to the provisional payroll data of ESIC ,19.88
lakh new employees have been added in the month of July, 2023 out of which _________are the total number of employees up to the age group of 25 years.Solution
According to the provisional payroll data of ESIC ,19.88 lakh new employees have been added in the month of July, 2023.   Around 27,870 new establishments have been registered and brought under the social security umbrella of the Employees’ State Insurance Corporation in the month of July, 2023, thus ensuring more coverage.Data reveals that more jobs have been generated for the youth of the nation as out of the total 19.88 lakh employees added during the month, 9.54 lakh employees up to the age group of 25 years constitute the majority of new registrations which is 47.9 % of the total employees.  Gender-wise analysis of payroll data indicates that net enrolment of female members has been 3.82 lakh in July, 2023.
Which command removes all rows but keeps table structure?
Which operator is used for pattern matching in SQL?
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?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
Deadlock in DBMS can be prevented using:
What is an SQL `VIEW`?
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
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?
