Wednesday, July 23, 2014

Infosys Placement Papers

http://www.infosysbpoeurope.eu/infosys-office.jpg 
 
Infosys Latest Selection Procedures

Infosys Selection Process consists of 2 sections:
  1. Online Test 
  2. Technical / HR Interview
1. Online Test 

It Consists of two parts:
(a) Aptitude Test:
Questions: 30
Duration: 40 minutes.
The Aptitude reasoning test pattern is distributed into 6 different topics with 5 questions each as:
(i)Picture Reasoning :
 In this section, a series of pictures are given which may consist of picture series, picture analogy or picture classification.
No of Questions: 5
(ii)Statement Reasoning:
In this section, sequence questions like seating arrangement or money distribution or height arrangement are given. A set of five questions are based directly on the statements given.
No of Questions: 5
(iii)Data Sufficiency: Here a set of two statements are given followed by 5 options which satisfy the answer for the statements. You have to decide which option best suits the answer.
No of Questions: 5
(iv)Data Interpretation: This section consists of a direct sequence of 5 questions based on the data which is provided in the form of table charts, bar charts, pie charts or line charts.
No of Questions: 5
(v)Relation Problem: This section consists of questions which are similar to the sets and relations like students with biology, maths, physics and chemistry, maths and biology, only physics, etc., and questions related as such.
No of Questions: 5
(vi)Syllogism: This section consists of statement followed by two conclusions. We need to pick out from 5 options which suits the best answer.
No of Questions: 5
(b) Verbal Ability:
Questions: 40
Duration: 35 minutes.
The Verbal Ability test pattern is distributed into 5 different topics as:
(i)Sentence Correction:
Among 4 sentences the correct one should be detected.
No of Questions: 8 
(ii)Insert Correect Phrase:
Underline a part of sentence and asked to insert correct phrase in it from given four options.
No of Questions: 8
(iii)Fill In The Blanks 
No of Questions: 8
(iv)Theme Detection
No of Questions: 6
(v)Two Reading Comprehensions
No of Questions: 10
> The key is to score well in this online test because it acts as a filter in the case of the Infosys Selection Process.

2. Interview:
  1. The key for interview is to maintain your calm, be confident, justify everything written in your resume in a positive way and yeah wear a sweet but not an annoying smile during interaction with the interviewer.
  2. At first, they asked us to submit our year wise mark sheets of the degree, 10th and 12th. The application form and the resume were stapled together with them to create a well formed application to be presented before the interviewer.
  3. The students were then divided into several groups and were allotted several panels by the volunteers.
  4. HR asked several queries like which language we have used, what was your task in the project and which server was used to run the scripts.

    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.


No comments:

Post a Comment