Bissoy.com
Doctors Medicines MCQs Q&A

If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by

If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by Correct Answer A10

A10 – Disjunctive selection by union of identifiers.

Related Questions

The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition.
The conditions regarding selection from a list of suitable candidates to be called for interview after a written examination for appointment of management-level persons to a multi-national company providing accounting services and sales are mentioned below. Candidates: a) Must have a Bachelor's degree in Basic Science with 65% or more marks or BE with 55% or more marks. b) Must have passed the examination with 70% or more marks. c) Age must be between 25 to 30 years as of 1/4/18. d) Must have 3 years of experience in an Accounting Institution and must have a Diploma in Accounting with 60% or more marks. e) Must be currently getting CTC of Rs. 6 lakh or more per annum. If the candidate: 1) If he fulfills all the other conditions other than A above, he will be designated as Junior Accountant. 2) If he fulfills all the other conditions other than (d) and (e) above, he can be designated as Trainee-Accountant. If he fulfills all the above conditions including 5 years of experience, he can be designated as a Senior Accountant. He can be designated as Manager (Accounts) if he fulfills all the above criteria including educational qualifications of CA/ ICWA/ MBA (Finance). Study all the above information and answer the following question. Varun has passed the CA exam and has a bachelor's degree in basic science and a diploma in accountancy, having scored 75% or more in the written examination during his entire career and also in the written examination. His age is 27 years and with 4 years of experience in Accountancy, he has a CTC salary of 18 lakhs per annum. To which of the following positions can he be referred? Select from the given options.
Consider two database relations R and S having 3 tuples in R and 2 tuples in S. what is the maximum number of tuples that could appear in the natural join of R and S?
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
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.
In the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. _______________ the course of the development of different life-forms heredity—which, in plain English, is unconscious memory generated in the first life-form and ______________ through all the different species—is the sole factor in the ____________ of the parent properties; while adaptation to surrounding conditions and circumstances, natural selection in the struggle _____________ existence, and partner selection in the struggle of the males for ____________ are the principalfactors in the differentiation of species. natural selection in the struggle _____________ existence, and partner selection
Read the information given below carefully and answer the given questions. For the recruitment process in an accounting organization, the following eligibility criteria are required for the candidates: i) Graduation in Commerce with minimum 60% marks. ii) At least 24 years and not more than 40 years of age as of 1-7-2016. iii) Candidates should have at least 2 years of work experience after education. iv) They should have secured 55% marks in the selection process. However, if the candidate fulfills the above criteria, except: (A) In case of (i), if the candidate is not a graduate in commerce but has a master's degree in finance with 60% marks, he/she should approach the Institute of Finance Management. (B) In case of (iii), if the candidate fulfills the eligibility criteria of at least 2 years work experience after education, not only that he has secured 75% marks in the selection process, he/she may be referred for Trainee Accountant. Based on the above information decide whether the following candidates are eligible in the selection process, and select the appropriate option. You do not have to think about anything other than the information given in the question. All the cases given to you are dated 1-7-2016. Anurag Kumar has 6 years of work experience after education. His birthday is 05-4-1992. He has scored 62% marks in the selection process. He has done his graduation in commerce and has scored 76% marks.
In a police selection 18000 applied for the post of constable. 33(1/3)% of the students applied did not attempted the test. 16(2/3)% of the students who attempted the test got failed. 23% of the students who passed the examination did not appear for the second round of selection. If 28(4/7)% of the students who appeared for the second round of selection passed the selection and selected as a constable, then what is the number of students who finally selected as the constable?
Study the following information carefully and answer the given questions. For a recruitment process in an ACCOUNTING organization, the candidates need to possess the following qualifications criteria: i) He/she must be a graduate in commerce with at least 60% marks. ii) He/she must be at least 24 years of age and not more than 40 years as of 1-7-2016. iii) He/she must have post-qualification work experience of at least 2 years. iv) He/she should have secured 55% marks in the selection process. However, if the candidate fulfills the above-mentioned criteria except: (A) at (i), and if the candidate is not a graduate in commerce but has a post-graduation degree in finance with a minimum of 60% marks, he/she should be referred to the Finance Manager of the organization. (B) at (iii), and if the candidate fulfills all the eligibility criteria of post-qualification work experience but has secured 75% marks in the selection process, he/she may be referred to the Trainee Accountant. Based on the above information, study carefully whether the following candidates are eligible for the recruitment process and mark your answer as follows. You are not to assume anything other than the information provided in each question. All the cases are given to you as of 1-7-2016. Snehlata’s date of birth is 6.2.1990. She has done her graduation and post-graduation in Commerce and secured 61% and 63% marks respectively. She has post-qualification work experience as a Senior Accountant of 3.5 years. She has secured 58.5% marks in the selection process.
Study the following information carefully and answer the given questions. For a recruitment process in an ACCOUNTING organization, the candidates need to possess the following qualifications criteria: (i) He/she should be a graduate in commerce with at least 60% marks. (ii) He/she should be of at least 24 years of age and not more than 40 years as of 1-7-2016. (iii) He/she should have post-qualification work experience of at least 2 years. (iv) He/she should have secured 55% marks in the selection process. However, if the candidate fulfills the above-mentioned criteria except: (A) at (i), and if the candidate is not a graduate in commerce but has a post-graduation degree in finance with a minimum of 60% marks, he/she should be referred to the Finance Manager of the organization. (B) at (ii), and if the candidate fulfills all the eligibility criteria but of post-qualification work experience but has secured 75% marks in the selection process, he/she may be referred to the Trainee Accountant. Based on the above information, study carefully whether the following candidates are eligible for the recruitment process and mark your answer as follows. You are not to assume anything other than the information provided in each question. All the cases are given to you as of 1-7-2016. Mamatha has done graduation in Mechanical Engineering with 59% marks. Her date of birth is 3.5.1991. She is qualified in the selection process and has secured 45% marks in it. She also has two years of post-qualification work experience.