Infosys technical interview questions and answers

Infosys technical interview questions and answers

About Infosys:

placement criteria for infosys

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