Thursday, March 7, 2019 Infosys HR and Interview questions The Hidden Mystery behind Infosys HR and No more mistakes in Infosys Interview
"It's hard to beat a person who never gives up"
One such example for the above quote is Mr. Krishnamurthy Shankar, called as (Krish Shankar)is an Executive Vice President and the Group Head of Human Resource Development at Infosys Limited since October 13, 2016. In this role, he is responsible for envisioning the road map for HR, driving strategy, and implementing operational priorities aligned with the overall organizational mandate.
Krish over 30 years
Krish has over 30 years of experience and has led several global HR functions in enterprise level roles, including restructuring, change management, performance, people alignment and driving the HR transformation agenda to deliver strategic value for the business. Mr. Shankar served as an Executive Director of Human Resources at Bharti Airtel Limited from March 2007 to August 2013. Mr. Shankar joined Bharti Airtel in March 2007 and was a member of the Airtel Management Board. Prior to joining Bharti Airtel, Mr. Shankar worked with Unilever Asia-Africa as Vice President, Human Resources. He started his career with Eicher Tractors in 1984 as Unit Personnel Officer. He has held various roles in Bharti Airtel, Hindustan Lever Ltd and Unilever, spanning the diverse areas of HR, as well as key business partnering functions. Mr. Shankar served as the Head of HR for South Asia at Philips.
Krish holds a postgraduate diploma in HR from XLRI, Jamshedpur, and has received an executive certificate in Strategy and Organization from the Stanford Graduate School of Business.
Transformation of HR
In his wide ranging experience in these organizations, he has led the transformation of HR into a strategic partner, facilitated organization-wide transformation and capability development and was instrumental in building a strong talent pool through a series of leadership development initiatives. He serves as a Member of Advisory Council at Centum Learning Limited. He is a member of the Global Mobile HR Steering Board.
Krish is an avid reader, loves wildlife photography, and trekking. A football enthusiast, he occasionally runs half-marathons. He is passionate about teaching and exploring new ideas in HR and organization development. Krish is based in Bangalore.
Is Performance Management Killing Performance? – Krish Shankar
No, I personally think that various statistics performance and how do they really track and improve performance. The original thinking around is something which what people said is very very important, I don't think performance management is killing performance, we need or the organization need systems to look at performance, evaluation, measure and improve performance. Everybody needs to do that and to develop people the way can improve. It is the process killing not the performance killing. But some of the extra processes that people work and block to see our own rate which is killing it. So I think we want to say what is the essential part of managing part and so keep that and what are the some things that actually coming in the way of that. So we should not throw a baby in a bath tub, where so many people will be talking about but i personally feel you need a good system of understanding, what your expecting for job or people living after expectations and how do you need some way to do that cross-tail and therefore you need process system whatever it is for managing and improving performance. So I think "The Process system is killing it, not the Performance management.".
Kelp HR’s Podcast session with Krish Shankar
This is a session on Industries best practices on Diversity and Inclusion Your following as Infosys is setting best example on Diversity. Krish Shankar - Diversity Inclusion is very important for Infosys, we include two parts one is the whole thing about ensuring the Antihalishment parts that is the Hygiene part and also we ensure that we create a culture where Women working and Women in Leadership, we want to take Women and grow in our company that very important and we have various programs we keep learning them and I think we have classify them in 3 or 4 things. Ensure and look at Infrastructure and whatever we do, we ensure that to have Diversity in that. A lot of Cultural Training takes place. Training the Managers, People, Antihalishment and various training on Cross Cultural that the one thing we set. Various Initiators to really fast track Womens. For Example: Women in Technology -we focus on them. Try and grow Women in Architect. We focus on all of them. Track all Women working in their company.
Krish Shankar .mp4
The DNA of company is all about entrepreneur, people have opportunity to do things that they have never done before some are, A Person came with a new Innovation in Mobile Commerce, we supported him and took him to market. New Model of Google Distribution, with our support he experimented, piloted and now its a success
And in many instance people have come up in little ideas. One such difference is the little job that is we do as you grow in our carrer. We start of with Sales, move up in Marketing and go up to larger area to do Business, work in a Region or Country Head office. We have Mobile Business, Blog band and fix land business, Enterprise business, DTH and Satellite broadcast business. In addition we are looking at Mobile Commerce, Mobile entertainment, Mobile health, Digital media and many other and few more as will go we come along and this provide people opportunity and various art of job that grow ahead.
Infosys Interview Questions
“Feel Free because It’s Time to Crack the Interview.”
It’s a proud moment to be placed in Infosys, there are 2 rounds
Written Test Interview- Technical Interview, HR Interview
Infosys Written Test
Aptitude Test Model Papers 1. In a covering, a certain distance, the speeds of A and B are in the ratio of 3:4. A takes 30 minutes more than B to reach the destination. The time taken by A to reach the destination is?
1 hour 1 1/2 hour 2 hour 2 1/2 hour
Answer: Option 3 Solution Ratio of speeds = 3:4 Ratio of times taken = 4:3 Suppose A takes 4x hrs and B takes 3x hrs to reach the destination. Then, 4x – 3x = 30/60 => x = 1/2 Time taken by A = 4x hrs = 4 * 1/2 = 2 hrs. 2. A train 110 m long is running with a speed of 60 km/hr. At what time will it pass a man who is running at 6 km/hr in the direction opposite to that in which the train is going?
5 sec 6 sec 7 sec 10 sec
Answer: Option 2 Solution Speed of train relative to man = 60 + 6 = 66 km/hr. = 66 * 5/18 = 55/3 m/sec. Time taken to pass the men = 110 * 3/55 = 6 sec. 3. A alone can do a piece of work in 6 days and B alone in 8 days. A and B undertook to do it for Rs. 3200. With the help of C, they completed the work in 3 days. How much is to be paid to C?
Rs. 375 Rs. 400 Rs. 600 Rs. 800
Answer: Option 2 Solution C’s 1 day’s work = 1/3 – (1/6 + 1/8) = 1/3 – 7/24 = 1/24 A’s wages : B’s wages : C’s wages 1/6 : 1/8 : 1/24 = 4:3:1 C’s share = 1/8 * 3200 = Rs. 400 4. A, B, and C started a business with capitals of Rs. 8000, Rs. 10000 and Rs. 12000 respectively. At the end of the year, the profit share of B is Rs. 1500. The difference between the profit shares of A and C is?
Rs. 300 Rs. 400 Rs. 500 Rs. 600 None of these
Answer: Option 5 Solution Ratio of investments of A, B and C is 8000 : 10000 : 12000 = 4 : 5 : 6 And also given that, profit share of B is Rs. 1500 => 5 parts out of 15 parts is Rs. 1500 Now, required difference is 6 – 4 = 2 parts Required difference = 2/5 (1500) = Rs. 600 5. If Rs. 510 be divided among A, B, C in such a way that A gets 2/3 of what B gets and B gets 1/4 of what C gets, then their shares are respectively?
Rs. 120, Rs. 240, Rs. 150 Rs. 60, Rs. 90, Rs. 360 Rs. 150, Rs. 300, Rs. 60 None of these
Answer: Option 2 Solution (A = 2/3 B and B = 1/4 C) = A/B = 2/3 and B/C = 1/4 A:B = 2:3 and B:C = 1:4 = 3:12 A:B:C = 2:3:12 A;s share = 510 * 2/17 = Rs. 60 B’s share = 510 * 3/17 = Rs. 90 C’s share = 510 * 12/17 = Rs. 360. 6. The current of a stream runs at the rate of 4 kmph. A boat goes 6 km and back to the starting point in 2 hours, then find the speed of the boat in still water?
10 kmph 21 kmph 8 kmph 12 kmph
Answer: Option 3 Solution S = 4 M = x DS = x + 4 US = x – 4 6/(x + 4) + 6/(x – 4) = 2 x = 8 7. In how much time would the simple interest on a certain sum be 0.125 times the principal at 10% per annum?
1 1/4 years 1 3/4 years 2 1/4 years 2 3/4 years
Answer: Option 1 Solution et sum = x. Then, S.I. = 0.125x = 1/8 x, R = 10% Time = (100 * x) / (x * 8 * 10) = 5/4 = 1 1/4 years. 8. Find the cost of fencing around a circular field of diameter 28 m at the rate of Rs.1.50 a meter?
Rs.150 Rs.132 Rs.100 Rs.125
Answer: Option 2 Solution 2 * 22/7 * 14 = 88 88 * 1 1/2 = Rs.132 9. A pupil’s marks were wrongly entered as 83 instead of 63. Due to the average marks for the class got increased by half. The number of pupils in the class is?
10 20 40 73
Answer: Option 3 Solution Let there be x pupils in the class. Total increase in marks = (x * 1/2) = x/2 x/2 = (83 – 63) => x/2 = 20 => x = 40. 10. The H.C.F of two numbers is 11 and their L.C.M is 7700. If one of the numbers is 275, then the other is?
279 283 308 318
Answer: Option 3 Solution Other number = (11 * 7700)/275 = 308. 11. If the sum of the two numbers is 22 and the sum of their squares is 404, then the product of the numbers is?
40 44 80 88
Answer: Option 1 Solution Let the numbers be x and y. Then, (x + y) = 22 and x2 + y2 = 404 Now, 2xy = (x + y)2 – (x2 + y2) 2xy= 222 – 404 = 484 – 404 = 80 xy = 40 12. Three pipes A, B and C can fill a tank from empty to full in 30 minutes, 20 minutes and 10 minutes respectively. When the tank is empty, all the three pipes are opened. A, B and C discharge chemical solutions P, Q and R respectively. What is the proportion of solution R in the liquid in the tank after 3 minutes?
5/11 6/11 7/11 8/11
Answer: Option 2 Solution Part filled by (A + B + C) in 3 minutes = 3(1/30 + 1/20 + 1/10) = 11/20 Part filled by C in 3 minutes = 3/10 Required ratio = 3/10 * 20/11 = 6/11 13. The principle that amounts to Rs. 4913 in 3 years at 6 1/4 % per annum C.I. compounded annually, is?
Rs. 3096 Rs. 4076 Rs. 4085 Rs. 4096
Answer: Option 4 Solution Principal = [4913 / (1 + 25/(4 * 100))3] = 4913 * 16/17 * 16/17 * 16/17 = Rs. 4096. 14. If the height of a cone is increased by 100% then its volume is increased by?
100% 200% 300% 400%
Answer: Option 1 Solution 100% 15. Find the one which does not belong to that group?
Walk Talk Drink Plank Lick
Answer: Option 4 Solution Walk, Talk, Drink and Lick are verbs, but not Plank. 16. A sells a bicycle to B at a profit of 20%. B sells it to C at a profit of 25%. If C pays Rs. 225 for it, the cost price of the bicycle for A is?
Rs. 110 Rs. 120 Rs. 125 Rs. 150
Answer: Option 4 Solution: 125% of 120% of A = 225 125/100 * 120/100 * A = 225 A = 225 * 2/3 = 150. 17. A person’s present age is two-fifths of the age of his mother. After 8 years, he will be one-half of the age of his mother. How old id the mother at present?
32 years 36 years 40 years 48 years
Answer: Option 3 Solution Let the mother’s present age be x years. Then, the person’s present age = 2/5 x years. (2/5 x + 8) = 1/2 (x + 8) 2(2x + 40) = 5(x + 8) => x = 40 18. In an election between two candidates A and B, the number of valid votes received by A exceeds those received by B by 15% of the total number of votes polled. If 20% of the votes polled were invalid and a total of 8720 votes were polled, then how many valid votes did B get?
2160 2420 2834 3150 None of these
Answer: Option 3 Solution Let the total number of votes polled in the election be 100k. Number of valid votes = 100k – 20% (100k) = 80k Let the number of votes polled in favour of A and B be a and b respectively. a – b = 15% (100k) => a = b + 15k => a + b = b + 15k + b Now, 2b + 15k = 80k and hence b = 32.5k It is given that 100k = 8720 32.5k = 32.5k/100k * 8720 = 2834 The number of valid votes polled in favour of B is 2834. 19. The cost of 16 pens and 8 pencils is Rs.352 and the cost of 4 pens and 4 pencils is Rs.96. Find the cost of each pen?
Rs.32 Rs.28 Rs.36 Rs.25 None of these
Answer: Option 5 Solution Let the cost of each pen and pencil be ‘p’ and ‘q’ respectively. 16p + 8q = 352 — (1) 4p + 4q = 96 8p + 8q = 192 — (2) (1) – (2) => 8p = 160 => p = 20 20. I. a2 + 11a + 30 = 0, II. b2 + 6b + 5 = 0 to solve both the equations to find the values of a and b?
If a < b If a = b If the relationship between a and b cannot be established If a > b E. If a = b
Answer: Option 2 Solution I. (a + 6)(a + 5) = 0 => a = -6, -5 II. (b + 5)(b + 1) = 0 => b = -5, -1 => a = b 21. 32% of 425 – ?% of 250 = 36
20 40 60 80 E. 70
Answer: Option 2 Solution 32/100 * 425 – x/100 * 250 = 36 => x/100 * 250 = 136 – 36 = 100 => x = (100 * 100)/250 = 40 22. The radius of a wheel is 22.4 cm. What is the distance covered by the wheel in making 500 resolutions?
252 m 704 m 352 m 808 m None of these
Answer: Option 2 Solution In one resolution, the distance covered by the wheel is its own circumference. Distance covered in 500 resolutions. = 500 * 2 * 22/7 * 22.4 = 70400 cm = 704 m 23. Which of the following has the same relationship as that of Money: Wealth?
Pity: Kindness Cruel: Anger Wise: Education Pride: Humility E. None of these
Answer: Option 1 Infosys Reasoning Test Sample Papers Infosys Reasoning sample questions are provided in this section along with detailed solutions. Before going to attend for the Infosys online test should prepare the provided questions thoroughly. 1. Statement: The employees association has appealed to the Managers of Company ‘S’ to introduce written examination for Clerical cadre recruitment to prevent selection of incompetent persons. Assumptions: I. So far the company ‘S’ used to select candidates with out conducting a written examination. II. A written examination can help to identify component persons. III. At higher level written examination may not be of much use.
Only I and II Only II and III Only II Only I and III
Answer: Option 1 Solution To appeal to start the written examination clearly hints about assumption I. Employees association assumes II that is why they have appealed so. 2. Statement: Many youngsters are addicted to social network sites on the internet. This has become a major cause of concern as these youngsters are not paying attention to their studies. Which of the following steps should the parents of such youngsters take to rid these youngsters of the addiction?
Children should be counselled to make them understand the problems that they would face in future if they neglect their studies. Social networking should be banned. Youngsters should not be allowed to access the internet. Youngsters should be made to practice yoga.
Answer: Option 1 3. Cause: The forest department has found several deadly tiger traps in the forests which fall under Maharashtra tiger reserve. These traps are usually laid by African nomads. Which of the following can be a possible effect of the above cause?
The local people and the officials may be alerted of movements of African nationals who look different by their wears and traits. A fencing may be constructed all around the reserve. All the tigers from the reserve may be shifted to zoos. The government may send army personnel to comb the place to find if there are more such traps.
Answer: Option 1 4. It may prudent to bear with a small harm for a greater benefit. Problem arises when the harm has the power to endanger future generations. Research has consistently shown that frequent exposure X-rays can cause cells in human body to be destroyed or mutated, apart from this it can cause damage to DNA cell structure, a bane that could be passed down for generations. Doctors, unmindful of such consequences, subject the patients to exposure to X-rays, even in the cases in which it can be avoided. Which of the following can be concluded/ inferred from the above passage?
Doctors think of other consequences of the treatment they provide to the patients. All the hospitals have X-ray machines. There are no government directives regarding the manufacture of X-ray machines. One cannot do away with X-ray machines in treating the patients. None of these
Answer: Option 5 Solution From the passage it is clear that the doctors do not think of using the X-ray machines. Hence, (A) cannot be concluded. The context of the passage is not about the number of hospitals that use X-ray machines. Similarly, (C) is also out of context. The passage is not referring to availability of alternatives to X-rays or otherwise. Hence, (D) cannot be concluded. 5. Study the following information carefully and answer the given questions: A word and number arrangement machine when given an input line of words and numbers rearranges them following a particular rule in each step. The following is an illustration of input and rearrangement: Input: 25 280 345 36 93 147 550 Step I: 550 280 345 36 93 147 25 Step II: 550 345 280 36 93 147 25 Step III: 550 345 280 147 93 36 25 This is the final arrangement and step III is the last step for this input. Which of the following is the last step for the following input? Input: 145 227 900 49 116 243 356
900 356 243 227 49 145 116 900 356 243 227 145 116 49 900 356 227 243 145 116 49 900 356 243 227 116 145 49
Answer: Option 2 Solution Numbers are getting arranged in descending order. The largest of the given number interchanges its place with the first number. IN case the largest number is already arranged, the second largest is interchanged with the number next to the largest number, and so on until the numbers are arranged in descending order. The series which is in strictly descending order will be the answer. 6. In the following questions, the symbols +, ×, =, ÷ and – are used with following meanings: ‘P+Q’ means ‘P is greater than Q’. ‘P×Q’ means ‘P is either greater than or equal to Q’. ‘P=Q’ means ‘P is equal to Q’. ‘P÷Q’ means ‘P is smaller than Q’. ‘P-Q’ means ‘P is either smaller than or equal to Q’. Statements: G – H, K × L, L – G Conclusions: I. G ÷ K II. L – H
if only conclusion I is true. if only conclusion II is true. if either conclusion I or II is true. if neither conclusion I nor II is true.
Answer: Option 2 7. Statement Should seniority be the only criterion for the promotion? Arguments: I. No. All the senior employees are not interested in promotion. II. Yes. Otherwise senior employees feel humiliated.
If only argument I is strong If only argument II is strong If either I or II is strong If neither I nor II is strong
Answer: Option 4 Solution I is not strong because the question of criterion arises only when the employee is really for promotion. II is not strong because a blind submission to such a feeling will do no good to the organisation. The effort should be to take measures that make employees feel that they are being cared for even though not promoted. 8. Statements I. No U is L II. No L is k III.Some N are Z IV. Some Z are magic Conclusions: I. No U is Z II. All Z being L is a possibility.
Statement 1 is true Statement 2 is true Statement 3 is true None of these
Answer: Option 2 9. The workers from asbestos industries do not protest against the health hazards and lack of medical facilities as most of them do not suffer from asbestos dust.
If the inference is definitely true If the inference is probably true If the data are inadequate If the inference is probably false If the inference is definitely false
Answer: Option 5 Solution: From the clause afraid to protest for fear of losing job the given reason can be nullified. 10. Statement: The company ‘X’ has rejected first lot of values supplied by company ‘A’ and has cancelled its entire huge order quoting use of inferior quality material and poor craftsmanship. Courses of action: I. The company ‘A’ needs to investigate functioning of its purchase, production and quality control departments. II. The company ‘A’ should inspect all the values rejected by company ‘X’. III. The company ‘A’ should inform company ‘X’ that steps have been taken for improvement and renegotiate schedule of supply.
Only I and II Only II All I, II and III II and either I or III
Answer: Option 3 Solution: As in the statement it is mentioned ‘rejection due to inferior quality material and poor craftsmanship’, it is well known that purchase dept is responsible for purchasing the inferior quality material. Again production dept is responsible for improper inspection. Hence investigation is compulsory for all the departments. Hence I follows. II follows because the claim of company ‘X’ may be wrong. III follows because relationships with a previous client should always be kept up. 11. Choose out the odd one.
Seminar Semi colon Semifinal Semicircle
Answer: Option 1 Solution: In all except seminar, Semi indicates “half”. 12. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
ISLOJ LUOQM AKDGB EPILG
Answer: Option 2 13. What will come in the place of the question mark (?) in the following series? N 5 V, K 7 T, ?, E 14 P, B 19 N
I10R H10Q H9R H10R
Answer: Option 4 14. If ‘CAT’ and ‘BOAT’ are written as ‘XZG’ and ‘YIZG’ respectively in a code language then how is ‘EGG’ to be written in the same language?
VSS URR VTT UTT
Answer: Option 3 15. Pointing to a gentleman, Deepak said, “His only brother is the father of my daughter father”, How is the gentleman related to Deepak?
Grand Father Father Brother-in-law Uncle
Answer: Option 4 11. Choose out the odd one. A. Seminar B. Semi colon C. Semifinal D. Semicircle Answer: Option A
Solution: In all except seminar, Semi indicates “half”.
- Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group? A. ISLOJ B. LUOQM C. AKDGB D. EPILG Answer: Option B
- What will come in the place of the question mark (?) in the following series? N 5 V, K 7 T, ?, E 14 P, B 19 N A. I10R B. H10Q C. H9R D. H10R Answer: Option D
- If ‘CAT’ and ‘BOAT’ are written as ‘XZG’ and ‘YIZG’ respectively in a code language then how is ‘EGG’ to be written in the same language? A. VSS B. URR C. VTT D. UTT Answer: Option C
- Pointing to a gentleman, Deepak said, “His only brother is the father of my daughter father”, How is the gentleman related to Deepak? A. Grand Father B. Father C. Brother-in-law D. Uncle Answer: Option D
Solution Father of Deepak’s daughter’s father –Deepaks Father. So the man’s brother is deepak’s Father or the man is the brother of deepak’s father i.e…, Deepak’s uncle.
Infosys English Test Model Papers
misery indifference veracity generosity
Answer: Option 4 Solution: Generosity (munificence, large-hoartodness) andtruism are synonyms. 2. WILY
twisted cunning irrational guileless
Answer: Option 4 Solution: The words wily (cunning) and guileless are antonyms. 3. We should travel ________ night, as it will be cooler.
in at with by
Answer: Option 1 4. Our cottage by the sea offers many days of relaxation with warm sunshine and soothing ______.
zephyrs dervishes stanchions ebbs
Answer: Option 1 Solution: A zephyr is a soft, gentle breeze; a breeze that blows from the west. 5. The seller lowered the prices.
The prices lowered the seller. The prices were lowered by the seller. Down went the price. The prices lowered by the seller.
Answer: Option 2 Solution: The prices were lowered by the seller. 6. Choose the correct spelled word out of the given alternatives.
Restaurent Restaurant Rastaurent Rasteraunt
Answer: Option B 7. To examine one’s own thoughts and feelings.
Meditation Retrospection Reflection Introspection
Answer: Option 4 8. Choose the best word in the given passage.
high varying no almost
Answer: Option 2 9. Will those happy days be ever forgotten by us?
Will we ever forget those happy days? Shall we ever forgot these happy days? Would we forge these happy days? Ever shall we forget those happy days?
Answer: Option A Solution: Will we ever forget those happy days? 10. The exhibition committee (P) attractive and useful (Q) to make the exhibition (R) making efforts (S) has been
SRQP QPRS SRPQ QPSR
Answer: Option 1 11. The match was over. We left for home. a) Match ———– b) We left ———– c) Besides the match ———–
Only B A & B B & C A & C
Answer: Option 2 12. To rise with the lark
to be promoted in position to order somebody to get out of bed to be able to deal with a difficult situation. to be affected by problems or insult to wake up very early
Answer: Option 5 Solution: When you wake up very early, you ‘rise with the lark’ (the name of a bird). 13. Do how I say.
as that like which
Answer: Option 1 14. Many teachers believe that the easiest way of maintaining order and discipline in classrooms is by instilling fear in the minds of the students. —– Parents too are to blame for this syndrome for they make life difficult for their children by setting unrealistic goals. (A) Its a pity that often lack in self-confidence. (B) No wonder they often lack in self-confidence. (C) It is practically impossible for the teachers to attend to each student’s problems.
A and B A and C Only A All the three
Answer: Option 1 Solution: Only statements A and B can Join the two sentences. C is different from them. 15. It was raining heavily. Hence, only few people attended the meeting. (A) Since it was raining ….. (B) Because it was ….. (C) Therefore few people …..
Only B B and C Only C A and B
Answer: Option 4 Solution: A is correct because the word ‘since’ suggests a reason. ‘As’ and ‘because’ are also used to suggest a reason. Infosys Technical Interview Questions and Answers
1) Difference between C and C++?
The major difference between C and C++ is that C is a procedural programming language and does not support classes and objects, while C++ is a combination of both procedural and object oriented programming language; therefore C++ can be called a hybrid language.
2.What is null pointer?
When referring to computer memory, a null pointer is a command used to direct a software program or operating system to an empty location in the computer memory. Commonly, the null pointer is used to denote the end of a memory search or processing event. In computer programming, a null pointer is a pointer that does not point to any object or function. A nil pointer is a false value. For example, 1 > 2 is a nil statement. In the programming language C, NULL is an available command that can be used, where nil is an available command used in the Pascal programming language.
3.What are the 4 basics of OOPS?
Abstraction, Inheritance, Encapsulation, and Polymorphism.
4.What you mean by Object Relational DBMS?
An object-relational database (ORD), or object-relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, just as with proper relational systems, it supports extension of the data model with custom data-types and methods.
5.Structural difference between bitmap and b-tree index?
Btree It is made of branch nodes and leaf nodes. Branch nodes holds prefix key value along with the link to the leaf node. The leaf node in turn contains the indexed value and rowed. Bitmap It simply consists of bits for every single distinct value. It uses a string of bits to quickly locate rows in a table. Used to index low cardinality columns.
6.what is database Schema?
The formal definition of database schema is a set of formulas (sentences) called integrity constraints imposed on a database. 7.what are the different levels of database schema?
Conceptual schema- a map of concepts and their relationships. Logical schema- a map of entities and their attributes and relations Physical schema- a particular implementation of a logical schema Schema object- Oracle database object
8.what is difference between foreign key and reference key ?
Reference Key is the primary key that is referenced in the other table (linked via the other tables Foreign Key). Foreign Key is how you link the second table to the primary tables Primary Key (or Reference Key).
9.Tell me about DSN?
A Data Source Name (DSN) is the logical name that is used by Open Database Connectivity (ODBC) to refer to the drive and other information that is required to access data. The name is used by Internet Information Services (IIS) for a connection to an ODBC data source, such as a Microsoft SQL Server database.
10.Difference between Clustered index and non clustered index ?
Clustered Index Only one per table Faster to read than non clustered as data is physically stored in index order Non Clustered Index Can be used many times per table Quicker for insert and update operations than a clustered index
Infosys HR Questions
1) Tell Me about Yourself?
2) What are your Greatest strengths?
3) Do you have any Blind Spots?
4) Why should I hire you?
5) Why did you leave your last job?
6) Where do you see yourself 5 years from now?
7) Describe your management style?
8) Are you a Team Player?
9) How would you be an asset to our Organizations?
10) Do you have any questions for me?
Click HERE @GUVI To GET Placed Immediately