Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Which of the following statements are true/false?
1. In case an employee whose minimum rate of wages is fixed under this Act, works overtime, the employer need not pay the money for the extra hours devoted by the employee.
2. If an employee whose minimum rate of wages has been fixed under this Act, works for a less number of hours than the requisite number of hours on a given day, he shall be entitled to receive wages in respect ofwork done by him on that day as ifhe had worked for a full normal working day.
3. In case an employee is involved in two or more classes of work, he shall be paid on the basis of pieces involved.
4. If an employee is employed on piece work for which minimum time rate and not a minimum piece rate has been fixed under this Act, the employer shall pay to such employee wages at not less than the minimum time rate.
Which of the following is correct in context of Minimum Wages Act, 1948?
1. In case an employee whose minimum rate of wages is fixed under this act, works overtime, the employer is bound to pay the money for the extra hours devoted by the employee.
2. In case an employee is involved in two or more classes of work, he shall be paid on the piece basis.
3. If an employee is employed on piece work for which minimum time rate and not a minimum piece rate has been fixed under this act, the employer shall pay to such employee wages at not less than the minimum time rate.
Consider the relational schema given below, where eId of the relation dependent is a foreign key referring to empId of the relation employee. Assume that every employee has at least one associated dependent in the dependent relation. Employee (empId, empName, empAge) Dependent(depId, eId, depName, depAge) Consider the following relational algebra query: ΠempId(employee)-ΠempId (employee⋈(empId = eID)∧(empAge ≤ depAge)dependent) The above query evaluates to the set of empIds of employees whose age is greater than that of
A company paid Rs. 6,00,000 as bonus to its employees at different levels A, B and C. Each employee at level A receives one and half times of the amount that was paid to each employee at level B and each employee at level B was paid twice the amount paid to the employee at level C. If 50 employees were on level A, 75 on level B and 100 on level C, how much amount was paid to each employee of level A ?
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
The profit – sharing ratio of two partners is 2 : 3 if another partner is added with 40% of the profit – sharing ratio and the profit – sharing ratio of the initial two partners remains the same. Find the new profit – sharing ratio.
Which of the following statements are true/ false?
1. Every employer shall be bound to pay to every employee in respect of the accounting year commencing on any day in the year 1979 and in respect of every subsequent accounting year, a minimum bonus which shall be 9.33% of the salary or wages earned by the employee during the accounting year or one hundred rupees, whichever is higher, whether or not the employer has any allocable surplus in the accounting year.
2. Bonus will be paid in cash to the employees.
3. If the allocable surplus exceeds the amount of minimum bonus payable to the employees, the employer is bound to pay to every employee in respect of that accounting year bonus which shall be an amount in proportion to the salary or wages earned by the employee during the accounting year subject to a maximum of 10% of such salary or wage.
4. Bonus needs to be paid within a period of eight months from the close of the accounting year.
Which of the following statements are true/false?
1. Gratuity shall be payable to an employee on the termination of his employment after he has rendered continuous service for not less than five years.
2. Each employee, who has completed one year of service, shall make nomination for the purpose of receiving gratuity.
3. For every completed year of service in excess of six months, the employer shall pay gratuity to an employee at the rate of fifteen day's wages based on the rate of wages last drawn by the employee concerned.
4. An employer who contravenes, or makes default in complying with, any of the provisions of the Payment of Gratuity Act shall be punishable with imprisonment for a term which may extend to one year, or with fine which may extend to twenty thousand rupees, or with both.
Consider the following relational schema: employee(empId,empName,empDept) customer(custId,custName,salesRepId,rating) salesRepId is a foreign key referring to empId of the employee relation. Assume that each employee makes a sale to at least one customer. What does the following query return? SELECT empName FROM employee E WHERE NOT EXISTS (SELECT custId FROM customer C WHERE C.salesRepId = E.empId AND C.rating <> ’GOOD’);
Consider the relation Emp-Dept with SSn as key Ename SSn EAddr Dept. No Dept. Name Dept. Manager SSn   Which of the following is (are) invalid operation(s)? a) Inserting an employee without name and address b) Inserting an employee with only SSn c) Inserting a department with no employee d) Inserting an employee without SSn