1. Interview pattern of Infosys consists of three parts which is

1) Aptitude
2) Technical
3) HR interview or HR Round or General round.

2. Aptitude section consists of

(I) Aptitude section
(ii) Logical section
(iii) Technical section
Generally you will be given 50 questions in the Aptitude section which is split accordingly amongst the three sections. During this interview process you might also be checked for English. A test in English may also be present.

3. In logical reasoning do prepare on

1) Puzzle problems
2) Cube questions
3) Data interpretation and sufficiency.
4) Series, etc.

4. Verbal questions can be prepared if you have good grammar and command in the language.

Number of questions for the written or aptitude test does vary.
Some of the questions are as follows: -
1) In a 500 meters race, B gives `A` a start of 160 meters.

The ration of the speeds of `A` and `B` is 2:3 who wins by how much?
2) A, B and C are three participants in a kilometer race. If A can give B a start of 40 meters and B can give C a start of 25 meters, how many meters A can give C a start?
3) A passenger in train `P` travelling at 1 km/min uses his stop watch and finds that another train `Q` travelling in the opposite direction, completely passed his window in 3 seconds. If the length of the train `Q` is 87.50 m. Try to find its speed in Km/hr or in any conversion?.
4) The minute hand of a clock overtakes the hour hand at intervals of 65 minutes of correct time. How much does the clock gain or lose in 12 hours?
5) A certain sum of money lent at a certain rate of compound interest grows to 1.44 times its value in 2 years. If the same sum is lent at simple interest at the same rate, in how many years would it double itself?
These are some of the questions or the type of questions which you would be facing during the interview of Infosys. Try to answer them answering them gives you an edge over the interview.

5. For verbal reasoning it is better to review Barron`s as it has complete reference for all your queries. Some of the questions concerning to verbal are: -

1) Synonyms and antonyms: -
(i) Anachronism
(ii) Amphitheater
(iii) Ameliorate
(iv) Soporific
(v) Sophist
Etc
You will also have comprehension from which you have to answer the questions.

6. Aptitude round may have these type of questions. Either these questions were asked in previous interviews or they are in the same format with name changes.

1) What is the area of a rectangle whose length is twice its width and whose perimeter is equal to that of a square whose area is 1?

2) Write ten numbers from the least to the greatest which have a remainder 3 after dividing it by seven. What is the series formed and what is the CD?

3) A cylindrical glass container is 20 centimeters tall and has a diameter of 10 centimetres. On the inside wall, three centimeters from the upper circular base, there is a drop of honey. On the lateral surface, diametrically opposite it, there is a fly. Which is the shortest route for the fly to reach the honey or destination?

4) Each packet of computer floppies contains a coupon that is equally likely to bear the letters D, E or F. If `x` packets are purchased, what is the probability that the coupons cannot be used to spell `FED`?

5) How many numbers greater than 5000 can be formed with four of the digits 3, 4, 5, 6, 7 where no digit can be repeated.

7. Some of the interview questions asked by the HR are as follows: -

1) Why Infosys and why not other companies what interests you in infy?
2) How did you career paved a way to the industry standards?
3) Why do you choose software industry when you are from different background?
5) What are all the programming languages you know and explain about certain programming language architecture?
6) What will be your ideal holiday spot?

8. What are the 4 basics of OOP in Infosys?

Abstraction, Inheritance, Encapsulation, and Polymorphism.

9. Explain Object Relational DBMS in Infosys?

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.

10. Explain database Schema in Infosys?

The formal definition of database schema is a set of formulas (sentences) called integrity constraints imposed on a database.

11. Explain the different levels of database schema of Infosys?

✰ 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

12. What is Reference Key in Infosys?

The primary key that is referenced in the other table (linked via the other tables Foreign Key).

13. What is foreign key in Infosys?

Foreign Key is how you link the second table to the primary tables Primary Key (or Reference Key).

14. Explain DSN in Infosys?

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

15. What is Clustered index of Infosys?

☛ Only one per table
☛ Faster to read than non clustered as data is physically stored in index order

16. What is non clustered index of Infosys?

☛ Can be used many times per table
☛ Quicker for insert and update operations than a clustered index

17. What is EXE in Infosys?

The term EXE is a shortened version of the word executable as it identifies the file as a program. On the other hand.

18. What is DLL in Infosys?

DLL stands for Dynamic Link Library, which commonly contains functions and procedures that can be used by other programs.

19. 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 ("circularn");
}
}
Thus, these are the most commonly asked Infosys technical interview questions. Read these Infosys technical interview questions for better Interview process.

20. Can you please explain the 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).

21. Can you please explain the 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

22. Can you please explain the difference between 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.