10-04-2017, 07:50 PM
infosys interview questions for experienced
Infosys is global leader in IT services and software. It is an Indian software company. It is an Indian multinational company that is enlisted on the NASDAQ and Bombay Stock Exchange. The company is headquartered in Bangalore, Karnataka. Based on the revenue, it was the third largest IT company in India. The company was founded in 1981 By the combined effort of N. R. Narayana Murthy, Nandan Nilekani, N. S. Raghavan, S. Gopalakrishnan, S. D. Shibulal, K. Dinesh and Ashok Arora. Since then the company has crossed many hurdles and has reached this height of success. Here are the Infosys technical interview questions and answers.
Before going through the sample papers of Infosys technical interview questions we should see the common errors by aspirants in the interview:
1. One common mistake by candidates is to arrive late in the interview process.
2. Don t Dress up too flashy. Try to dress up in a conservative suit and minimal amount of jewelry, wear low heals polished.
3. Playing zombie is one more problem. Actually people out of nervousness cannot talk and thus become stiff and cant make eye contact.
4. No Smoking, No Gum and No Drinking.
5. Not being able to articulate ones own strength and weaknesses.
Infosys technical interview questions:
1.What are the 4 basics of OOP?
Abstraction, Inheritance, Encapsulation, and Polymorphism.
2.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.
3.what is database Schema?
The formal definition of database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
4.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
5. 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 page link the second table to the primary tables Primary Key (or Reference Key).
6. 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. To set this name, use the ODBC tool in Control Panel.
click->start in control panel->double click Administative Tool->click ODBC data source->click System DSN tab->click Add
7.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
8. What is the difference between an EXE and a DLL?
The term EXE is a shortened version of the word executable as it identifies the file as a program. On the other hand, DLL stands for Dynamic Link Library, which commonly contains functions and procedures that can be used by other programs.
9.Tell how to check whether a linked list is circular.
Create two pointers, each set to the start of the list. Update each as follows:
while (pointer1) {
pointer1 = pointer1->next;
pointer2 = pointer2->next; if (pointer2) pointer2=pointer2->next;
if (pointer1 == pointer2) {
print ( circular\n );
}
}
Thus, these are the most commonly asked Infosys technical interview questions. Read these Infosys technical interview questions for better Interview process.
Infosys interview questions are very tricky and you need to do regular homework and hard work to crack the questions. Infosys is one of the leading multinational software companies that places a huge number of employees every year. This very company is tied up with a number of top Engineering and Management colleges in the country and a number of students from several institutions got placed in here every year. Getting placed at Infosys is like a dream come true and this is why this leading IT company is the main focus of so many students. So let us get a detailed look at the question pattern and types of Infosys interview questions and how to crack it as well.
A Brief Idea about the Infosys Interview
But it is not an easy task to crack Infosys interview at the first go. Since Infosys hugely deal with the fresh candidates and place the student through college campus interviews this is why its question pattern is a bit different from the other companies. Students are very much bothered about how they can crack the Infosys interview? How are the Infosys interview questions? Which pattern does it follow? How to get prepared for it and much more.
Two Rounds of the Infosys Interview
There are mainly two rounds in the interview process of this leading IT software company. The first round is Aptitude and the second round is HR interview.
You must act in a very decisive manner in order to prepare for the Infosys interview questions. As we have already said earlier that the question pattern of Infosys interview is way different from other companies this is why while preparing for Infosys you must be dedicated to it.
The best and the most interesting part of this company is that even being an IT solution company Infosys never asks questions on technical matters. This lessens the burden to a great extend however since the extend of reading reduces it is expected of a candidate to pay as much attention as possible so that he or she can deliver the best with full perfection.
The specialty of Infosys interview questions is all the questions are very much practical most importantly the verbal part.
In the question paper there is an English language test for which you have to be very good in grammar and vocabulary. This is at the same time the most scarring part that students can score 100% marks in this segment. So if you feel you are anywhere lacking in English start preparing a hit it at your best. You will face questions like correct the following sentence, write the synonyms of the words given, write the correct answer etc. More you practice these more you will become perfect and chances to score high will also increase.
After that comes the aptitude round which includes quantitative and logical questions. This part is to test and play with your brain and merit and this is the most tricky part of all the rounds. This is where they judge your analytical power and as well as how well you have prepared yourself.
After being successful in this segment the HR round interview starts an this round is way easier than the previous one and the questions are also much familiar. In this segment questions are of the regular interview types. Let us see the questions you may be asked in the HR interview round.
Common Infosys Interview Questions
As we have already said these questions are many familiar and friendly. You may be asked
Tell me about yourself
Your career goal
Your hobbies
They can even ask you about your family background- When they ask you about your family background, you need to be little clever. They do not prefer candidates with BUSINESS background. If your father is a businessman, make sure you are able to convince them that you are interested in working for them and you are not going to join your father s business. Trust me, this is really a very important point you should keep in mind. Moreover, if you are the only child of your parents, please prepare yourself how you can convince them that being the only son/daughter wont be an issue anytime.
Are you ready to handle a team under pressure? How would you manage your team
What will be your motto to motivate your team?
Do you get puzzled under pressure?
What is your biggest strength and weakness?
Tell us something about your biggest failure and achievement
Why this college and this stream?
Why Infosys?
What do you know about Infosys?
Why should Infosys hire you?
Do you have any query?
Tricky Infosys Interview Questions
These very common and professional ones. Apart from that the company even asks you very friendly even sometimes funny question as well like
What is favorite movie and song?
Who is your favorite actor?
Which kind of movie you like to see?
Your dream vacation spot?
Your favorite cuisine?
As a whole the interview session of this company is not impossible to crack. All you need is to prepare yourself as well as possible and at the same time learning other tricks to crack an interview like fluent communication skill, presence, attire etc.