Question
In a company with 800 employees, the average age of male
employees is 42 years and that of female employees is 41 years. If the average age of all the employees in the company is 41 years and 9 months, then the number of female employees is. type-sscSolution
Male               Female 42                   41            41yrs 9m 9m      :          3m 3         :          1 4 unit = 800 1 unit= 200 So now Female = 200.
Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
Which of the following statements about SQL `INDEXES` is generally TRUE?
What is the correct sequence of operations for using an explicit PL/SQL cursor?
Which clause is used to sort query results in SQL?
Which command removes all rows but keeps table structure?
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?
Which of the following is a mandatory component of a PL/SQL function's definition?
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which SQL constraint ensures that a column’s values are unique across the table?
Which SQL keyword prevents duplicate rows in result?
Relevant for Exams:
