Question paper for MNC Company

Will you please provide me the previous year interview Question paper of Infosys?

[Raman Vij]

As you are looking for the previous year interview Question paper of Infosys so here it is given below

Infosys Previously asked Technical and Hr 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. Structural difference between bitmap and b-tree index ?

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

5.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

6. 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).

7. 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

8.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

9 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.

10.Scenarios in which web application should be used and desktop application should be used?

11.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");
}
}
12.Why is it difficult to store linked list in an array?

13.what is the difference between socket and session?

14.What is a default gateway?

15.What is SMTP?

16.What is an interrupt?

17.What is debugger?

18.What port does telnet use?

19.Given an array of 1s and 0s arrange the 1s together and 0s together in a single scan of the array. Optimize the boundary conditions.

20.Define Data Abstraction. What is its importance?


Infosys Technical Interview

These are the most common interview mistakes:
(a). Arriving late.

(b). Dressing wrong : make powerfully positive. Dress right in a conservative suit, subdued colors, little jewelry (but real gold, or silver, or pearls), low heels (polished) and everything clean and neat.

(c). Play zombie : If you are nervous you can't smile and make the eye contact

(d). No smoking, no gum, no drinking.

(e). Research failure : Find out the company's products and services, annual sales, structure and other key information

(f). Can't articulate your own strengths and weaknesses.

(g). Winging the interview : Write out any answers you have difficulty with, and practice until your delivery is smooth (but not slick).

(h). Talk, Talk, Talk. : interrupting the interviewer and answering to a simple question with a fifteen-minute reply

(i). Failure to connect you to the job offered.

(j). Not asking questions - and asking too many : Use your research to develop a set of questions that will tell you whether this is the job and the company for you.

(k). Bad-mouth anyone : You don't want to look like a complainer.

(l). Asking about compensation and /or benefits too soon.

(m). Failure to ask for the job : when the interview over, convey your interest in the job and ask what the next step is.

Sir I am looking for the question paper for and IT MNC Company so can you please provide me the same

[Shaleen]

Hey buddy below I am giving you the CISCO aptitude question paper

1. The largest 4 digit number exactly divisible by 88 is:
A. 9944
B. 9768
C. 9988
D. 8888



2. One pipe can fill a tank three times as fast as another pipe. If together the two pipes can fill the tank in 36 minutes, then the slower pipe alone will be able to fill the tank in:
A. 81 min.
B. 108 min.
C. 144 min.
D. 192 min.



3. A large tanker can be filled by two pipes A and B in 60 minutes and 40 minutes respectively. How many minutes will it take to fill the tanker from empty state if B is used for half the time and A and B fill it together for the other half?
A. 15 min
B. 20 min
C. 27.5 min
D. 30 min



4. The H.C.F. of two numbers is 23 and the other two factors of their L.C.M. are 13 and 14. The larger of the two numbers is:
A. 276
B. 299
C. 322
D. 345



5. Let N be the greatest number that will divide 1305, 4665 and 6905, leaving the same remainder in each case. Then sum of the digits in N is:
A. 4
B. 5
C. 6
D. 8



6. A train can travel 50% faster than a car. Both start from point A at the same time and reach point B 75 kms away from A at the same time. On the way, however, the train lost about 12.5 minutes while stopping at the stations. The speed of the car is:
A. 100 kmph
B. 110 kmph
C. 120 kmph
D. 130 kmph



7. Tea worth Rs. 126 per kg and Rs. 135 per kg are mixed with a third variety in the ratio 1 : 1 : 2. If the mixture is worth Rs. 153 per kg, the price of the third variety per kg will be:
A. Rs. 169.50
B. Rs. 170
C. Rs. 175.50
D. Rs. 180



8. A vendor bought toffees at 6 for a rupee. How many for a rupee must he sell to gain 20%?
A. 3
B. 4
C. 5
D. 6



9. Out of 7 consonants and 4 vowels, how many words of 3 consonants and 2 vowels can be formed?
A. 210
B. 1050
C. 25200
D. 21400



10. The average weight of A, B and C is 45 kg. If the average weight of A and B be 40 kg and that of B and C be 43 kg, then the weight of B is:
A. 17 kg
B. 20 kg
C. 26 kg
D. 31 kg



11. A father said to his son, "I was as old as you are at the present at the time of your birth". If the father's age is 38 years now, the son's age five years back was:
A. 14 years
B. 19 years
C. 33 years
D. 38 years



12. A train running at the speed of 60 km/hr crosses a pole in 9 seconds. What is the length of the train?
A. 120 metres
B. 180 metres
C. 324 metres
D. 150 metres



13. 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?
A. Rs. 375
B. Rs. 400
C. Rs. 600
D. Rs. 800



14. A and B invest in a business in the ratio 3 : 2. If 5% of the total profit goes to charity and A's share is Rs. 855, the total profit is:
A. Rs. 1425
B. Rs. 1500
C. Rs. 1537.50
D. Rs. 1576

15. The cost price of 20 articles is the same as the selling price of x articles. If the profit is 25%, then the value of x is:
A. 15
B. 16
C. 18
D. 25



16. FAG, GAF, HAI, IAH, ____
A. JAK
B. HAL
C. HAK
D. JAI



17. SCD, TEF, UGH, ____, WKL
A. CMN
B. UJI
C. VIJ
D. IJT



18. If a person walks at 14 km/hr instead of 10 km/hr, he would have walked 20 km more. The actual distance travelled by him is:
A. 50 km
B. 56 km
C. 70 km
D. 80 km



19. In a shower, 5 cm of rain falls. The volume of water that falls on 1.5 hectares of ground is:
A. 75 cu. m
B. 750 cu. m
C. 7500 cu. m
D. 75000 cu. m



20. A sum of money at simple interest amounts to Rs. 815 in 3 years and to Rs. 854 in 4 years. The sum is:
A. Rs. 650
B. Rs. 690
C. Rs. 698
D. Rs. 700