Bissoy.com
Doctors Medicines MCQs Q&A

  1. some dependent.
  2. all dependents
  3. some of his/her dependents
  4. all of his/her dependents
5 views

1 Answers

Option 4 : all of his/her dependents

Explanation:

Example:

Employee Relation:

EmpID

empName

empAge

e1

A

20

e2

B

25

e3

C

24

 

Dependent Relation:

depID

eID

depName

Age

d1

e1

X

30

d2

e1

Y

25

d3

e1

Z

20

d4

e2

P

18

d5

e2

P

17

d7

e3

Z

35

 

R1=ΠempId (employee⋈(empId = eID)∧(empAge ≤ depAge)dependent)

Output : e1,e3

R2=ΠempId(employee)

Output: e1,e2,e3

R = R2 - R1= {e1,e2,e3} - {e1,e3} = e2

  • e2 is output that is saying that set of empIds of employees whose age is greater than that of all of his/her dependents.
5 views

Related Questions

The following are the conditions for selecting list of a suitable candidates to be called for interview after the written test for the recruitment is conducted/ organized for management-level persons of a multi-national company. For providing accounting services and sales the candidates must (a) be holding a graduation in basic science with 65% or above or B. E degree with 55% and above marks (b) have passed the written test with 70% or above marks (c) the age must be in the group 25 to 30 years as on 1/4/18 (d) have experience in an accounting firms for three years and diploma in accounting with 60% or above marks (e) be presently drawing CTC of 6 Lakhs per annum and above In case the applicant who satisfies all other terms above except 1) at (a) above, then be referred as Junior Accountant 2) at (d) & (e) above then be referred as Trainee-Accountant Satisfying all the above with experience of 5 years then be referred as senior-Accountant Satisfying all the above criteria (a-e) with CA/ ICWA / MBA (Finance) then be refereed as manager (Accounts) Read all the above information and answer the following question Shravani has passed H. SC with 72% of marks. She has done diploma in accountancy with 62% of marks. She was working with an organization in the field of accounting in the field of accounting from 4 years and was drawing CTC of 6.5 Lakhs presently. She is 28yrs as on July 2018. She may referred for the position of:?
1 Answers 5 Views
The following are the conditions for selecting list of a suitable candidates to be called for interview after the written test for the recruitment is conducted/organized for management - level persons for a multi - national company. For providing accounting services and sales the candidate must (a) be holding a graduation in basic science with 65% or above or B.E. degree with 55% and above marks (b) have passed the written test with 70% or above marks (c) the age must be in the group 25 to 30 years as on 1/4/18 (d) have experience in an accounting firms for three years and diploma in accounting with 60% or above marks (e)  be presently drawing CTC of 6 Lakhs per annum and above In case the applicant who satisfies all other terms above except 1) at (a) above, then be referred as Junior Accountant 2) at (d) & (e) above then be referred as Trainee - Accountant Satisfying all the above with experience of 5 years then the referred as senior-Accountant Satisfying all the above criteria (a - e) with CA/ICWA/MBA (Finance) then be referred as manager (Accounts) Read all the above information and answer the following question Praveen has done his Masters in physics. He has no experience in accounting neither diploma. He is ready to be on training for accounting after joining. For which position he may be referred?
1 Answers 6 Views
The following are the conditions for selecting list of a suitable candidates to be called for interview after the written test for the recruitment is conducted/ organized for management-level persons of a multi-national company. For providing accounting services and sales the candidate must (a) be holding a graduation in basic science with 65% or above or B.E degree with 55% and above marks (b) have passed the written test with 70% or above marks (c) the age must be in the group 25 to 30 yrs as on 1/4/18 (d) have experience in an accounting firms for three yrs and diploma in accounting with 60% or above marks (e) be presently drawing CTC of 6 Lakhs per annum and above In case the applicant who satisfies all other terms above except 1) at (a) above, then be referred as Junior Accountant 2) at (d) & (e) above then be referred as Trainee-Accountant Satisfying all the above with experience of 5 yrs then be referred as senior-Accountant Satisfying all the above criteria (a-e) with CA/ ICWA/ MBA (Finance) then be refereed as manager (Accounts) Read all the above information and answer the following question: Radha Mohan has done her graduation in physics with 58% of marks. She has passed the written examination with 76% of marks. She is 27 yrs as on June 2018. She has the experience in the accounting company for four years with salary of 7 Lakhs per annum. She also has passed diploma in accounting with 61% of marks. She may be referred for the position of:?
1 Answers 10 Views
The following are the criteria set by a Retail outlet for the selection of candidates for the post of Store In charge in a reputed mall. 1. The candidate must be a graduate in any stream with minimum of 50% marks. 2. The candidate must have Minimum of 5 years of Sales experience in Retail. 3. The age of the candidate should not be less than 25 years and more than 34 years as on 1st October, 2019. (a) If a candidate satisfies all the criteria except 2 as given above but has an MBA degree and has minimum of 2 years of work experience in sales, she/he must be sent to the General Manager, Recruitment for further interview. (b) If a candidate satisfies all the criteria except 3, but has more than 5 years experience as a Group Manager and above in Sales managing a team of sales executives, then she/he must be sent to the Regional Manager, Sales & Marketing, for further interview Based on the above criteria and conditions, analyze and decide which of the following course of action should be taken for the candidate whose description is provided below. Please note that you are not to assume anything other than the given information. Sujoy is a graduate with 55% marks and MBA through Correspondence. He was born on Sept 20, 1990. He has 1 year of work experience as a sales executive and 2 years of experience as a Group Manager, Sales. On the basis of the information as given above, which of the following decisions would be appropriate?
1 Answers 6 Views
A reputed educational institution is to select meritorious graduates, for the award of scholarships for higher studies abroad at a premium University, who fulfill the following criteria: The candidate must - (i) have Minimum 85% marks in the final year examination of the institute. (ii) have secured at least 90 % marks in the selection test of the University abroad. (iii) not be less than 21 years and not more than 25 years of age as on 1.01.2020 In case of a candidate who satisfies all other criteria except: (a) At (i) above but has won at least one major prize/award in Debate/ Sports/ Cultural event, the case may be referred to the Director of the Institution. (b) At (ii) above but is from the reserved category, there is relaxation of age by 2 years. Based on the above criteria and conditions, analyze and decide which of the following course of action should be taken for the candidate whose description is provided below. Please note that you are not to assume anything other than the given information. Deepinder Bhalla, born on 17th December, 1997 secured 79% marks in final year. She got 92% marks in selection test and has won 3 Inter-University debate competitions.?
1 Answers 13 Views
Following are the criteria for the selection of Civil Engineers in an organization: The candidate must - (i) have a B.E. or B. Tech from a recognized university with minimum 65% marks. (ii) have secured at least 50 % marks in the selection test. (iii) have secured at least 55% marks in the interview. (iv) not be less than 22 years and not more than 27 years of age as on 1.10. 2019. In case of a candidate who satisfies all other criteria except: a) At (i) above but has more than 2 years experience, the case may be referred to the General Manager, Recruitment. b) At (ii) above but have secured 75% and above marks in the selection interview, the case may be referred to the Sr,V.P. HR. Based on the above criteria and conditions, analyze and decide which of the following course of action should be taken for the candidate whose description is provided below. Please note that you are not to assume anything other than the given information. Amita Sachdeva, born on 20th October, 1992 secured 55% marks in BE final year She got 60% marks in both selection test and interview.?
1 Answers 7 Views
The given conditions are imposed by an officer for providing the Travelling Concession to the employees. The employee A. Should have made 2 trips in a 4 calendar years. B. Should have made one trip in 1 calendar year. C. Should have made one trip within the native country, while the other could have been overseas. D. Should have made a trip with maximum of 6 people. E. The total cost of both the trips should not have exceeded Rs. 6 lakhs. In case of employee who satisfies all the other criteria except: I. At (D) above, he/she would get Rs. 4 lakhs as concession. II. At (E) above, he/she would get Rs. 3 lakhs as concession. In the inquiry underneath, data of one employee is given. You need to take one of the accompanying four choices in the light of the data given and the criteria and conditions given above. Shyam, a native of India, along with his wife and 2 children went for vacations within India. He made his first trip in February, 2016 and second one in August 2016. The total expenditure of the trips were four lakhs and forty thousand.?
1 Answers 6 Views