Infosys Interview Preparation Guide Download PDF
Infosys Interview Questions and Answers Infosys Technologies Limited is an information technology services company headquartered in Bangalore, India. Infosys is the second largest IT company in India with 104,850 professionals, so get preparation for a job in Infosys with the help of this Infosys Interview Questions with Answers guide
34 Infosys Questions and Answers:
Table of Contents:
1 :: What is the height of room if after entering the room with a watch ur head strikes a hanging bulb?
Oscillate the hanging bulb. Calculate the time period for one complete oscillation by Simple Harmonic Motion (SHM) of the handing bulb. Put it in the
formula T=2 * 3.14 * (L/G)^1/2
formula T=2 * 3.14 * (L/G)^1/2
2 :: There are three people A, B, C. Liars are of same type and Truth speaking people are of same type. Find out who is speaking truth and who is speaking false from the following statements:
a) A says: B is a liar.
b) B says: A and C are of same type.
lets assume A is speaking truth. It means B is a liar then it means A and C are not of same type.
3 :: Can u make 120 with 5 zeros?
Factorial (factorial (0)+factorial (0)+factorial (0)+factorial (0)+factorial (0)) = 120
4 :: Suppose Anna, Bubblo, ruth and ferra are at their monthly business meeting. Their occupations are author, biologist, chemist and doctor, but not necessarily in that order. ferra just told the biologist that ruth was on her way with doughnuts. Ann is sitting across from the doctor and next to the chemist. The doctor was thinking that bubblo was a goofy name for parent's to choose,but didn't say anything. What is each person's occupation?
Since ferra spoke to the biologist and Ann sat next to the chemist and across the doctor, ryth must be the author and Ann the biologist. The doctor didn't speak, but David did, so Bobbie is the doctor and ferra the chemist.
5 :: You are given a cake; one of its corner is broken. How will u cut the rest into Two equal parts?
Slice the cake
6 :: How will you recognize the magnet & magnetic material & non-magnetic material?
Drag one piece of material over another. There is no attractive force in the middle portion of the magnet. OR Get a piece of thread and tie up with the one bar and check for poles. If it iron bar then it moves freely and if it is magnetic bar then it fix in one direction according to poles.
7 :: If one tyre of a car suddenly gets stolen…. and after sometime u find the tyre without the screws how will u make your journey complete?
Open 3 screws, 1 from each tyre and fix the tyre.
12 :: Suppose 9 cards are there. you have to arrange them in a 3*3 matrix. cards are of 4 colors. They are red, yellow, blue and green.
Conditions for arrangement: one red card must be in first row or second row.
2 green cards should be in 3rd column.
Yellow cards must be in the 3 corners only.
Two blue cards must be in the 2nd row.
Atleast one green card in each row?
Yellow Red Green
Blue Blue Green
Yellow Green Yellow
Blue Blue Green
Yellow Green Yellow
13 :: 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.
14 :: 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
☆ 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
15 :: 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).
16 :: 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.
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.
17 :: What is DLL in Infosys?
DLL stands for Dynamic Link Library, which commonly contains functions and procedures that can be used by other programs.
18 :: 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.
19 :: What is non clustered index of Infosys?
☛ Can be used many times per table
☛ Quicker for insert and update operations than a clustered index
☛ Quicker for insert and update operations than a clustered index
20 :: What is Clustered index of Infosys?
☛ Only one per table
☛ Faster to read than non clustered as data is physically stored in index order
☛ Faster to read than non clustered as data is physically stored in index order
21 :: 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
✫ System DSN tab->click Add
✫ click->start in control panel->double click
✫ Administative Tool->click ODBC data source->click
✫ System DSN tab->click Add
22 :: What is foreign key in Infosys?
Foreign Key is how you link the second table to the primary tables Primary Key (or Reference Key).
23 :: What is Reference Key in Infosys?
The primary key that is referenced in the other table (linked via the other tables Foreign Key).
24 :: 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
✰ 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
25 :: Explain database Schema in Infosys?
The formal definition of database schema is a set of formulas (sentences) called integrity constraints imposed on a database.