Saturday, February 13, 2010

Accenture Placement papers Freshers

Accenture has five selection rounds, all are elimination rounds

Round I

This is an aptitude round, there are 3 sections,
Section I: English (Vocab, Comprehension etc)

Section II: Aptitude (R.S. Agarwal should be suffecient)

Section III: Reasoning, pickup any GRE book , it should be sufficient

The aptitude round is pretty much simple

Round II

THis is a GD round, this is also elimination, SO don’t forget to make a
point, they don’t normally see how relevant you speak, its just that you
should speak something and make yourself heard.

Round III

This is an HR round, this is also an elimination round, it will be a casual
talk, for god sake don’t say any thing contoversial and don’t contradict
yourself.

Round IV

This is a technical round, they will normally ask you questions pertaining
your field of interest and will focus on the projects that you have done,
you should be able to talk about your projects with confidence.

Round V

This is a combination of hr and technical , again the same stuff is
repeated,you need to just hold on , coz you are almost there.

The bottom line is that you should be a good communicator and show
confidence,


This is the selection procedure :

1)Test :normal agarwal apptitude,English synonyms,RC’s……….(cat pattern basically)

2) GD: ANy general topic picked (make sure u make one valid pt and make ur voice heard int eh crowd of 10 ppl)

3)Hr round: normal Hr Ques(goals long& short ,background,strenghs, weaknesses)

4)Technical rnd:Questions abt the projects u have done(B very well prepared with it)

5)Final rnd:Questions abt ur fav topic(i picked c/c++) .

The questions asked were from the following
sections:
1)numerical :
profit & loss, percentages, mixtures,
time and distance, time and work.
2)analytical :
venn diagrams ( if in a class of 40
students, 10 speak only telegu, 20 speak both telegu
and tamil….), probability, drawing conclusions…
3) verbal : was basically easy — just synonyms,
choose the correct one.., passage.

Section 1
1a> In this section 2 passages were there on basis of that u have to answer 10 questions (5 question each ) First passage was based on ball tempering by Indian team with mix of lagan story .In this answer of first question was (Ball tempering) the second passage was based on Gadar movie.(same story).
Synonyms:
1)Candid:ans frank
2)Specifaction :ans documentation
3) Extradite =deport
4) Cursory= scold
5) ———-= very high
fill up the blanks with proper word(5 questions)
pick the sentence which has grammatical mistake.(5 questios).

Section 3-Verbal (20 questions)
Here few questions are from logical reasoning (eg.)(6 questions)
Sentences: ( type of question) (logical deductions)
i>some cats are dog
ii> no dog is lion
conclusion :
i> some dogs are lion
ii> some dog are cats
options:
a> only 1 follows
b> either I or ii follows
c> none follows

2 questions on +means *, %mean -, etc..
answers of those questions are 4 and -20/3..

letter series example aabb-abda-bbaa this type one question
a question of this type
find the next term in AM ,BA ,JM like this

Apptitude Questions

1) it has 20 mixutre conatins mil and water in the ratio 3:5,replace 4 litres of mixture with 4 litres of water what is the final ratio of milk and water.
2) + means * and * means / and / means % what is the value of these question
2+3*5/7 it was two question of these type.
3) The equivalent compound ratio of 5:6::7:10::6:5 ( question of this type this is not
exact question).
3) work can be done by 8 men and 10 women in 25 days, the same work can be done
by 10 children and 5 women . in how many days 2 children and 3 men
(similar to this)
4) one man or two women or three boys can do a work in 44 days then one man, one women and one boy together can fininsh the same work in —- dyas
5) (998-1)(998-2)(998-3) ..(998-n)=——- when n>1000 ans is zero
6) in how many ways can a lock be opened if that lock has three digit number lock if
i) the last digit is 9
ii) and sum of the first two digits is less than or equal to the last digit.
numbers are from 0-9
7)if a man reduces the selling price of a fan from 400 to 380 his loss increases by 20% .cost price of fan is.
8) there are 76 persons. 53 can read hindu,46 can read times,39 can read deccan
and 15 can read all.if 22 can read hindu and deccan and 23 can read deccan and times
then what is the number of persons who read only times and hindu ans 18

9) in pure milk if 20% replaced by water and in this again 20% is replaced by water and again 20% is replaced by water then what is the praportion of milk in that mixture

10) after 10 years A will be twice the age of B before 10 years.and now if the difference is 9 years between them then what is the age of B after 10 years ans 49
11)races and games —- 2 questions from this chapter like (A beats B by 10 meters and B beats C by 15 metres the A beats C by )
12)in the year 1990 there are 5000 men 3000 women 2000 boys .in 1994 men are increased by 20% women are increased by ratio of boys and women (this type of question but some what difficult I mean it takes too much time to solve)

1 It has 20 mixutre conatins mil and water in the ratio 3:5,replace 4 litres of mixture with 4 litres of water what is the final ratio of milk and water.

2 Work can be done by 8 men and 10 women in 25 days, the same work can be done
by 10 children and 5 women . In how many days 2 children and 3 men can do the same work.

3 What is the equivalent compound ratio of 5:6::7:10::6:5

4 There are 76 persons. 53 can read hindu,46 can read times,39 can read deccan and 15 can read all.if 22 can read hindu and deccan and 23 can read deccan and times then what is the number of pe…
18
5 One man or two women or three boys can do a work in 44 days then one man, one women and one boy together can finish the same work in —- days
6 In how many ways can a lock be opened if that lock has three digit number lock if

i) the last digit is 9

ii) and sum of the first two digits is less than or equal to the last…
7 After 10 years A will be twice the age of B before 10 years.and now if the difference is 9 years between them then what is the age of B after 10 years
49a

8 In pure milk if 20% replaced by water and in this again 20% is replaced by water and again 20% is replaced by water then what is the proportion of milk in that mixture
9 If a man reduces the selling price of a fan from 400 to 380 his loss increases by 20% .What is the cost price of fan
10

+ means * and * means / and / means % what is the value of 2+3*5/7

There are three sections.

Section 1-ENGLISH

1. In this section2 passages were there on basis of that u have to answer 10 questions (5 question each ) First passage was based on ball tempering by Indian team with mix of lagan story .In this answer of first question was (Ball tempering) the second passage was based on Gadar movie.(same story).

II Synonyms:

1.Candid:ans frank
2.Specifaction :ans documentation
3. Extradite =deport
4. Cursory= scold
5. ———-= very high

III .fill up the blanks with proper word(5 questions) pick the sentence which has grammatical mistake (5 questios).

Section IV-Verbal (20 questions)

Here few questions are from logical reasoning (eg.)(6 questions)
Sentences: ( type of question) (logical deductions)

1 i some cats are dog
ii no dog is lion
conclusion :
i some dogs are lion
ii some dog are cats
options:
a only i follows
b either I or ii follows
c none follows

2 Questions on +means *, %mean -, etc..
answers of those questions are4 and -20/3..

3 Letter series example aabb-abda?bbaa this type one question a question of this type
4. find the next term in AM ,BA ,JM like this
APTITUDE

1. It has 20 mixutre conatins mil and water in the ratio 3:5,replace 4 litres of mixture with 4 litres of water what is
the final ratio of milk and water.
2. + means * and * means / and / means % what is the value of these questio 2+3*5/7 it was two question of
these type.
3. The equivalent compound ratio of 5:6::7:10::6:5 ( question of this type this is not exact question).
4. Work can be done by 8 men and 10 women in 25 days, the same work can be done by 10 children and 5 women . in how many days 2 children and 3 men (similar to this)
5. One man or two women or three boys can do a work in 44 days then one man, one women and one boy together can fininsh the same work in —- dyas
6. (998-1)(998-2)(998-3)????..(998-n)=——- when n>1000ans is zero
7. In how many ways can a lock be opened if that lock has three digit number lock if
i) The last digit is 9
ii) and sum of the first two digits is less than or equal to the last digit. numbers are from 0-9
8. If a man reduces the selling price of a fan from 400 to 380 his loss increases by 20% .cost price of fan is.

9. There are 76 persons. 53 can read hindu,46 can read times,39 can read decca and 15 can read all.if 22 can read hindu and deccan and 23 can read deccan and times then what is the number of persons who read only times and hindu???ans 18

10. In pure milk if 20% replaced by water and in this again 20% is replaced by water and again 20% is replaced by water then what is the praportion of milk in that mixture.

11. After 10 years A will be twice the age of B before 10 years.and now if the difference is 9 years between them then what is the age of B after 10 years ans 49
12. Races and games —- 2 questions from this chapter like (A beats B by 10 meters and B beats C by 15 metres the A beats C by )
13. In the year 1990 there are 5000 men 3000 women 2000 boys .in 1994 men are increased by 20% women are increased by ratio of boys and women (this type of question but some what difficult I mean it takes too much time to solve) better to go through the following chapters in both Objective arithmetic and Quantitative Aptitude by RS Aggarwal, ratio and praportion (4 questions), ages (3 ques ), races and games,time and distance ,time and work, percentages.

For GD

Per team 8 members and they tell us to choose a topic of ourown interest The topics we faced are Advantages
and disadvantages of Internet Betting in cricket should legalized or not Education system in India A discussion on Iraq and America war After finishing the GD you will be given a form.

This interview was conducted for 1 year or more exp. guys in C++.

1) Firstly he asked me about the project and i was thoroughly grilled.
2)Then he asked to list the various types of storage classes and asked me to explain the scope & lifetime
of each one.. (Auto,Static,Register,Extern,and also mutable(only used for classes) )
3) Right shift/Left shift + 1’s complement concepts
then asked me to give the output of this:-
i = 10;
int j = i >> 10;
cout

I appeared in Accenture Technical Interview.

Here is the stuff they asked.

1 dynamic binding
2 normalizations, different normal forms with examples
3 primary key, foreign key, super key
4 waterfall model, spiral model
5 system booting process
6 testing basics
7 what is the output of select * from table1,table2
8 ur latest project, be confident in that
9 multivalued dependency
10 C programs for factorial, palindrome, bubble sort

If you are a recent graduate, This is what you need:
BE CONFIDENT and KNOW WHAT YOU ARE TALKING ABOUT! Smile and show them why you want to work for accenture. Most of the ppl who interview you dont know too much technical, so you should be able to explain them in a way they will understand. Have a mock interview with your friend. and make your resume in their format.

. The Accenture Interview was one of the most easiest interviews that I have ever faced. For people more than 3 years of experience,there are 3 rounds.I had gone for Testing interview.

Round -1
Technical — Basic Questions on testing , like difference between integration and system testing, defect life cycle, elements of a test plan, whether I have used automated tools,basic questios bout Winrunner and Test Director, responsibilities in my last job etc

Round 2 -
HR Interview– Your Strengths, weakness, whether you have gone abroad, why did u leave the last company, if you any gap in education what was the reason etc.

Round 3 -
Senior Management Interview - They will ask you in detail about any one project, why do u want to work in accenture, what is your exposure to quality,whether your last comapny was a CMM level company etc

The questions asked were from the following

sections:

1)numerical :
profit & loss, percentages, mixtures,
time and distance, time and work.

2)analytical :
venn diagrams ( if in a class of 40
students, 20 play hockey, 15 play football…), probability, drawing conclusions…

3) verbal : was basically easy — just synonyms,
choose the correct one.., passage.
the test was easy. there were

60 questions( 60 mins).

other rounds:

2) GD: ANy general topic picked (make sure u make one valid pt and make ur voice
heard int eh crowd of 10 ppl)

3)Hr round: normal Hr Ques(goals ,background,strenghs, weaknesses, research about
accenture, why do u prefer accenture to tcs)

4)Technical rnd:Questions abt the projects u have done(B very well prepared with
it),Questions abt ur fav topic(i picked java)

Written :
Same Previous Pattern :
1. Englisi - 20 questions. –easy
2. Apt. - Easy Questions..
1. in a theatre the ratio of car & two
wheeler is 1:8 Total no of tyres are 100
find how many cars and two
wheelers?
Remaining Set Theory….

3. Reasoning :
using +-*? problems……
pattern matching & easy problems.
logical reasoning problems :

some cats are lions.
all lions are tigers.
some problems in that manner.

2. dollar problem(encode).(3 ques)

4. c : easy programs like #pragma startup &
ptr programs

5. c++ : Little bit tough.(see previous
papers).
6. DBMS(only for MCA not for BE) : tough
section.

GD:

topics are
1. leaders are born or made.
2. education is necessary for politician or not.
3. india wants to continue relationship with pak
or not.

HR Round:
1. when will u complete the course?
2. when will u join in Accenture?
3. willing to relocate?
4. do u have passpot & driving license?
5. why Accenture?
6. what companies u have applied?
7. infosys or verizon or accenture which is best
and why?
8. tell abt urself?
9. what do u know abt accenture?

Tech-round:

panel - 1

1.Tell About ur self?
2.Explain SDLC?
3.what is waterfall and spiral model?
4.what is linked list and its types.
5.what are the rules for RDBMS and who developed it?
6.commands in DDL,DML,DCL & TCL?
7.About Normalization and asked real time
impelmentation?
8.About Packages in Oracle?
9.Abt Triggers and when it will trigger?(before,after)
10.maximum no. of triggers for row and column in a
table?
11.about Primary key and foreign Key?

other question from the same panel:
1. what is OS?
2. what is Data Structures?
3. what is the function of OS?

if u specified unix in ur resume they asked unix
commands in vi editor.
types of editors in unix?

panel - 2:

1.abt Project?
2.some questions from project?
3.tell abt oops concept?
4.difference bet. c++ & java?
5.factorial program in java?
6.fibonacci series in java using array?
7.count the no. of occurances ‘accenture’ in a file?

the details of selection procedure were as follows:

a written exam was conducted on 8 in meerut consisting of a written
test with five sections & approx. 75 minutes duration.three sections were based on
topics such as verbal,quant.& reasoning.rest two were questions were from C & C++.but
there was individual time limit for each section.

next round was a h.r. interview on 21 in delhi.the interviewer asked just
three questions as follows:
why was there a gap in your education after 10+2?
what do u know ab’t accenture?
why do u want work for accenture?

next round was a technical interview on same day & all the questions were
based on
final year project & microprocessor (mainly interrupts & interfacing).

as far as h.r. is concerned be sure to have a good & convincing answer if u
have a gap in eduacation.next important thing i feel that he was looking for was
confidence.

regarding technical e.c. students should prepare microprocessor.also questions
were asked on signals & systems & common C programs(palindrome,largest of three
numbers etc). from other candidates.just keep u’r basics clear.also all freshers should
have a good knowledge of final year project.

Sanjeev went through a job interview and said:


1.English-easy
2.Mental aptitude-R.S should be enough
3.Reasoning-R.S or Barrons
4.C
5C++

Tha time limit was 75 minutes and 75 questions were there.


total :- 450
written clear :- 80
HR clear :- 45
tech (final) clear :- 28
pattern of written paper and whatever the questions r remember….i m giving to u.
it was a objective paper without negative marking.there was 5 sets common for all and 1 extra(DBMS) set only for M.C.A.’s.
All set conatined 15 question each only and the time given for dbms set (for m.c.a.’s) was 15 minutes and then 75 min common for all.
set were
1- english
2- maths
3- reasining
4- C
5- c++
all were bunch together,time management was upto u.

SET DBMS.

1- data model is
a) entity b) constriants c) entity relationship d) all the above
ans:- c

2- choise the correct one
select emp.name ,emp.age from emp1,emp2 where emp.sno = 456;
a) cluster b) non-cluster c) index d) none of these

3- what is index?
a) atrendum selectio of colum
ans) a

4- match the following
1- one to one a) manager to employ
2- one to many b) employ to employ
3- many to one c) unique object
4- many to many d) employ to manager
a) 1-a ,2-b ,3-c,4-d b) 1-c,2-d,3-a,4-b c) 1-c,2-a,3-d,4-b d) 1-d,2-b,3-a,4-c
ans) c

5-

Select first.name from first where first.age = (select first.age from first where first.sno = 3);
a) max b) allen c) rony d) noneof these

THERE were 3 question on same type of queries(u should be good in foreign key relationship and relationship with in a single table).
One question was based on INDEX.
Also one more mapping relationship given based upon the figure.

SET ENGLISH

5 question based upon SIMPLE preposition (dam easy)
3 question from article.
5 questions from a single passage.
4-5 questions of synonyms.(from a given line..one word was bold….for that).

SET MATHS

VERY –VERY EASY question from R.S. aggarwal…..(logical based maths).

SET REASONING

3 questions based upon equality of number’s …means
three no’s given ……
a) if all equal
b) if 1,2 same
c) if 2,3 same
d) none…..
DAM –easy

3 questions based upon equality of symbols …means

if + means * and * means / and – means + and + means –
then mean of 28*40/4+2-6

8 question upon set theory means
if 100 r selecting in maths
and 90 in physics
120 in chemistry
& 22 in phy& maths both ,33 in maths & chemisty both
44 in ches & phy…11 in all
then
1) how many only in maths…….
2) Only in physics……
3) Only in chemistry…….
4) how many in atleast 2……
likewise……all were DAM –EASY ,if u r easy with VAN-DIAGRAM…..first make the van-diagram and then use the formula.

SET C

4 QUESTION on pointers…
3 on file handling….
2 on functions….
3 structurs and unions
2 from bitwise
1 from memory & space(how much memory this will take)

dear ,if I will say it was DAM-TUFF…I THINK I WILL BE INSULTING of the level of the questions….the syntax of the questions were ununderstandable…some questions were taking more then 1 page….forget abt the solving..noone could read them in 15 mins….
It was total LUCK…try to solve 4-5 …which u can and then put a intelligent guess( or same opt on all) on other……
U can use test ur C skills and explore in C…but paper level was too much from them also.only application part’s were there.

SET C++

Inheritance
Scope of protected
Virtual function
Static member function
File handling
Question) If error is not catch by first catch statement then what will happen….4 scenario were given…choose 1 among them.

Copy constructor

And other’s were ununderstandable that from which topic they were and which concept we have to folloe????????????????
Really I cann’t inselt this part too by saying DAM-TOUGH……….
Ur luck was really very needed……

Hr – interview

1- IF U HAVE ANY QUESTION THEN ASK ME…..( IT WAS ASKED AS A FIRST QUESTION IN INTERVIEW FROM MANY….)
2- UR FAMILY BACKGROUND…
3- UR EDUCATION BACKGROUND…
4 – IF I WILL NOT SELECT U THEN WHAT U WILL DO ????
5- TELL ME ABT URSELF..
6 – WHAT U THINK…U SHOULD DEVOLP IN URSELF..
7- WHY U WANT TO JOIN ACCENTURE…

TECHNICAL INTERVIEW

1- WHAT IS THE NEED OF NORMALISATION IN DATA BASE.
2- 1-5 ALL NORMALISE FORMS( FROM MANY THEY DIRECTLY ASKED 4TH AND 5TH NORMANILISE..(MOSTLY FROM M.C.A.’S)
3- WHAT IS SEMAFORE IN O.S. .
4- WHAT IS PAGING AND DEMAND PAGING.
5- HOW MEMEORY WORKS IN a computer system.
6- How recursion works in C.
7- WHICH DATASTRUCTURE USED IN RECURSION.
8- Deference between structure N union.
9- What is ERP…..(ACCENTURE having work in ERP…as we m.c.a’s having ERP in 3rd sem so…the person highlighted or wrote sth in resume ,THEY asked abt ERP from them only).
10- What is reengineering in ERP.
11- IF U HAVE TOO much cash in ur hand, then what u will do in behalf of the company…..
12- Why u want to join accenture….
13- Tell me abt urself.
14- What abt ur strength & weakness.
15- Why I should hire u ??????
16- Why ur area of interest is “OOPS”…..(MOSTLY USED TO ASKED OOPS AND THEY ASK SAME QUESTION FROM MANY).
17- If u have any question, ask me…..

Pramod went through a job interview and said:


There are three sections.
Section 1-ENGLISH
1a> In this section2 passages were there on basis of that u have to answer 10 questions (5 question each ) First passage was based on ball tempering by Indian team with mix of lagan story .In this answer of first question was (Ball tempering) the second passage was based on Gadar movie.(same story).
Synonyms:
1)Candid:ans frank
2)Specifaction :ans documentation
3) Extradite =deport
4) Cursory= scold
5) ———-= very high
fill up the blanks with proper word(5 questions)
pick the sentence which has grammatical mistake.(5 questios).

Section 3-Verbal (20 questions)
Here few questions are from logical reasoning (eg.)(6 questions)
Sentences: ( type of question) (logical deductions)
i>some cats are dog
ii> no dog is lion
conclusion :
i> some dogs are lion
ii> some dog are cats
options:
a> only follows
b> either I or ii follows
c> none follows

2 questions on +means *, %mean -, etc..
answers of those questions are4 and -20/3..

letter series example aabb-abda?bbaa this type one question
a question of this type
find the next term in AM ,BA ,JM like this

apti questions:
1) it has 20 mixutre conatins mil and water in the ratio 3:5,replace 4 litres of mixture with 4 litres of water what is the final ratio of milk and water.
2) + means * and * means / and / means % what is the value of these question
2+3*5/7 it was two question of these type.
3) The equivalent compound ratio of 5:6::7:10::6:5 ( question of this type this is not
exact question).
3) work can be done by 8 men and 10 women in 25 days, the same work can be done
by 10 children and 5 women . in how many days 2 children and 3 men
(similar to this)
4) one man or two women or three boys can do a work in 44 days then one man, one women and one boy together can fininsh the same work in —- dyas
5) (998-1)(998-2)(998-3)????..(998-n)=——- when n>1000ans is zero
6) in how many ways can a lock be opened if that lock has three digit number lock if
i) the last digit is 9
ii) and sum of the first two digits is less than or equal to the last digit.
numbers are from 0-9
7)if a man reduces the selling price of a fan from 400 to 380 his loss increases by 20% .cost price of fan is.
8) there are 76 persons. 53 can read hindu,46 can read times,39 can read deccan
and 15 can read all.if 22 can read hindu and deccan and 23 can read deccan and times
then what is the number of persons who read only times and hindu???ans 18

9) in pure milk if 20% replaced by water and in this again 20% is replaced by water and again 20% is replaced by water then what is the praportion of milk in that mixture

10) after 10 years A will be twice the age of B before 10 years.and now if the difference is 9 years between them then what is the age of B after 10 years ans 49
11)races and games —- 2 questions from this chapter like (A beats B by 10 meters and B beats C by 15 metres the A beats C by )
12)in the year 1990 there are 5000 men 3000 women 2000 boys .in 1994 men are increased by 20% women are increased by ratio of boys and women (this type of question but some what difficult I mean it takes too much time to solve)

First Round:

Tell me about yourself?
WHat do u know about Accenture?
etc..

Second Round:

This was a techical round.
1) Explain architecture of .NET
2) Questions on deploying .Net application
3) Questions on SQL server Index

1) Difference between DataElement & DTD ?
2) Difference between Entity beans in EJB 1.1 & EJB 2.0 ?
3) If there are 100 beans in JNDI & the context.lookup() method takes time to
lookup. How do you handle the situation to make it easy retrieval of the bean ?
4)Servlet is Java class. Then why there is no constructor in Servlet ? Can we write
the constructor in Servlet ?
5) What is a Singleton class. How do you write it ? Tell examples ?
6) Can a JSP be used as controllor in MVC architecture ? If NO, why ?
7) What is the difference between using a HttpSession & a Stateful Session bean ?
Why can’t HttpSession be used instead of Session bean ?
8)Can we override init() method of a Servlet ?
9) Can we call destroy() method forcefully ?

the pattern was :
15 C questions—easy
15 C++ —tough
15 DBMS—medium
15 verbal reasnoing
15 logical —
set theorey is importnat –6 questions overall
mental application
=============
1. patterns like ZZZZZERETTT ZZZZZERETEE ZZZZZEREETE…….
and comparisons on them like which of them r similar and how many r not simmilar
also —3 questions
2. if +is replaced by - ,- by * ,* by / ….sort of then they will give a arithmetic
expression .
solve it using rules of precednce after subsitituion …. —-2 questions
3 .if $ represents 1 and 0 is reprented by * then they as u
find product of 12*56*14 and represent in binary wiht above symbols
example 4 would be rep. as $** . —5 questions
4. four realtionships based —–3 questions
5. simple symonms —-
6. prefer RS agarwal verbal and non verbal to barrons GRE and important topics from
rs agarwal.
actually in accenture there was no aptitude ….
7. english was easy
passage. ..easy way for passage solving is read questions first than read
passage .so that u can find the answers easily.
hr round
_________
tell me about urself
ur family background
ur long and short term goals
where do u see urself 5 yrs from now
talk for 2 minutes on any topic—to test ur communication skills.
best is talk about thier company….they will be impressed about the reasearch u
have done and it shows the interest in their comapny and ur work
techinal round
============
ur background
os questions ..
dbms features ….and questions ,normalization
queries
differences between c++ and java
java features
oops features ,virtual polymorphisim ,freind function and syntax, types of
polymorphism .
SDLC lifecycle and important phase as per u
testing stages and types—unit testing ,module testing ,sub systems
testing,integration testing and acceptance testing.
types of inheritance
project :
if u have mentioned project they will grill u on this .so be prepared for this …
be cool and confident .
speak clear ,slow and loud .


Hexaware Placement Papers

Hexaware Placement Papers written test papers
Directions for questions 1-10: Expand the following terms:-

1. ODBC
Ans: Open Database Connectivity.

2. HTML
Ans: Hyper Text Markup Language.

3. RISC
Ans: Reduced Instruction Set Computing.

4. ASCII
Ans: American Standard Code For Information Interchange.

5. ANSI
Ans: American National Standard Institute.

6. XML
Ans: Extended Markup Language.

7. FLOPS
Ans: Floating Point Operating Per Second.

8. SQL
Ans: Sequential Query Language.

9. QBE
Ans: Query By Example.

10. ALE
Ans: Address Latch Enable.

11. What is lagging in DBMS?
Ans: Reduced Redundancy.

Directions 12 to 20: For the following questions find the odd man out.

12. Unix
OS/2
CMOS
MSDOS

Ans: CMOS.

13. Oracle
Informix
Sybase
LISP

Ans: LISP

14. Laser
Inkjet
Dotmatirx
Mouse

Ans: Mouse

15. Dir
Cls
Csh
Copy

Ans: Csh

16. Bit
Byte
Nibble
Digit

Ans: Digit

17. Hard Disk
Floppy Drive
CD ROM
Cache

Ans: Cache

18. SQL
QUEL
QBE
ORACLE

Ans: Oracle

19. C++
JAVA
VC++
PASCAL

Ans: PASCAL

20. Projection Operation
Selection Operation
Intersection
Set Difference Operation

Ans: Intersection

21. Which of the following is a universal gate?

(a) OR

(b) AND

(c) XOR

(d) NOR

Ans: NOR

22. The default back end of the VB is

(a) Oracle

(b) Sybase

(c) Informics

Ans: Sybase

23. What is meant by Superconductivity?
Ans: No reistance

24. Viscosity
Ans: Friction

25. What is the Lock Based Protocol used for?
Ans: Concurrency Control in DBMS.

Directions for question 25 to 32: Convert the decimal numbers on the left to the required form.

25. 9's complement of 28
Ans:71

26. Binary of 58
Ans: 111010.

27. Octal of 359
Ans: 547

28. Hexadecimal of 650
Ans: 28A

29. BCD of 18
Ans: 0001 1000

30. BCD of 34.8
Ans: 0011 0100.1000

31. Excess-3 code of 6
Ans: 1001

32. Excess-3 code of 9
Ans: 1100

33. If Ax + By = 1F16;
Cx + Dy = 2510.
Find the value of x and y?

34. Semaphore is used for

(a) Synchronization
(b) Dead-lock avoidence
(c) box
(d) none


Ans: A

35. For addressing 1 MB memory, the number of address lines required,

(a) 11
(b) 16
(c) 22
(d) 24

Ans: B

36. Which of the following remains in memory temporarily

(a) Resident portion of COMMAND.COM
(b) Transient portion of COMMAND.COM
(c) API
(d) Disk BIOS

Ans: B

37. Pick the odd man out
(a) IO.SYS
(b) MSDOS.SYS
(c) ROM-BIOS
(d) COMMAND.COM

Ans: c

38. OS/2 is a
(a) Single User OS
(b) Multi User OS
(c) Multi Tasking OS
(d) None of these

Ans: C

39. Bootstrap loader program is a program belonging to

(a) ROM startup software
(b) ROM extension software
(c) ROM BIOS software
(d) ROM Basic software

Ans: A

40. The entry of starting cluster of a file is present in

(a) Boot Parameters
(b) Directory
(c) FAT
(d) Partition Table and master boot program

Ans: C

Aptitude Section

Directions for questions 1-6: Find the correct meaning of the following phrases:-

1. A man of letters
2. A man of straw
3. To be in the air
4. To bite the dust
5. Man of few words
6. Penny wise pound foolish.
7. Find the reminder when 333666777888999 is divided by 3 or 9 or 11 ?
8. Which is the biggest perfect square amongst the following:-

15129, 12348, 23716, 20736

9. The greatest area of the following

(a) The radius of circle is 4
(b) The square of diagonal is 4
(c) The square of side is 4

10. The area of the maximum size of the circle described from the 10 square inch square?

11. In the series 0, 3, 8, 15,__, What is the next number?

12. X < 0, Y <> 0

then what is the possibility that the result is always positive?

Ans: xy

13. 3 red and 4 blue balls are in a basket. A member of PPTeam is drawing balls from the basket. What is the probablity of getting the 3 red balls simultaneously?

14. Let ax2 + bx + c = 0

If the sum of the equal roots is equal to the product of the same roots. Then which of the following hold true?

(a) a + b = 0
(b) a = 0
(c) c = 0
(d) a + c = 0

15. A fold density is 19 times greater than the water and for copper it is 9 times. At what ratio you can mix gold and copper to get 15 times denser than water.

Ans: 3 : 2

16. Find the value of (1.99)2

Ans: 3.9601


17. There is a room with 6' x 8'. A 1' tile is fixed along the 4 walls in one row. How many 1" tiles require to finish the work.

Ans: 24

18. 2 persons can finish a job in 8 days. First person alone can finish the work in 24 days. How many days
does the second person take to finish the job?
Ans: 12 days 19. A 4" cube is painted in all its faces and then it is cut down into 1" blocks. How many 1" blocks are there even without a single face being painted?

Ans: 8

20. A cylinder is inserted in a sphere d/h = 2/3. Find the surface area of the cylinder?

21. In a car wheel, two spokes cover 15 degree. Then for the entire car, how many spokes are there?
Ans: 24

22. What is the angle of degree suspended when two hands of clock showing the time 2:30?
Ans: 105 degrees

23. The age difference between two brothers is 3 years. After 6 years the ratio between the age is 9:8. What are their ages?
Ans: 21 and 18

24. A person's salary is getting reduced by 20%. What percentage should be added to get back his original salary?
Ans: 25%

25. Two persons start at the same point, walk in opposite directions with 5 km/hr and 5.5 km/hr respectively. What is the distance separated after 2 and half hrs?
Ans: 26.25 (approx)

26. A person starts walking at a speed of 5 km/hr through half the distance, rest of the distance he covers with a speed 4km/hr. Total time of travel is 9 hours. What is the maximum distance he can cover?
Ans: 40km

27. Initially two cups of same volume are present with milk filled upto 3/5th and 4/5th of their volumes. Water is then filled. Then two mixtures are mixed. Find the ratio of water to milk in the mixture.
Ans: 3 : 7

28. 16 grams of radioactive material decays into 8 grams in 10 years. How long will it take to decay to 1 gram?
Ans: 70 yrs

29. In a rectangle the length is increased by of the original length. By what proportion should the width be reduced so that the area will be the same?
Ans: 33

30. Find the nth number in the series is 1, -3, 5, -7.___
Ans: (-1)*(2n-1)

31. If a square is formed by the diagonal of the square as an edge, what is the ratio between the area?
Ans: 2

32. The perimeter of a rhombus is 52 units. One of its diagonal is 24 units. What is its second diagonals length?
Ans: 10

33. A cubical rectangular bar has the dimensions with the ratio 5 : 4 : 3. Its volume is 7500. What is the surface area of the bar?
Ans: 2350

34. In a class total 34 students, 16 are have a brother, 15 are have sisters, 9 students don't have either brothers or sisters. Find the number of students having both brother and sisters.
Ans: 6

35. A batsman scored 18 runs in his 18th innings and that makes his average 18. Find his average upto the 17th innings?
Ans: 19

36. 6 women can do 75 units of work in 8 days by working 5 hrs/day. In how many days can 4 women do 30 units of work by working 8 hrs/day?

37. A persons salary is decreased by steps of 20%, 15% and 10%. What will be the percentage decrease, if the salary is decreased in a single shot?

38. The ratio of the length : breadth : height of a cuboid is 5 : 4: 3, and the volume is 7500. What will be its surface area?

39. If the circumference of a circle is 100 units, Then what will the length of the arc described by an angle of 20 degree?

40. 3 Persons started placementpapers with a capital of Rs.3000. B invest Rs.600 less than A, C invest Rs.300 less than B. Then what is the share amount of B in a profit of Rs.886?

Directions for 41-50: Which of the following is the correct spelling for the word.


41. Supercede and Supersede

42. Recommend and Reccomend

43. Superitendent and Superitendant

44. Separate and Seperate

45. Succeed and Suceed

46. Coolly and Cooly

47. Despair and Dispair

48. Ridiculous and Rediculous

49. Indespensible and Indepensable

50. Tranquility or Tranquillity

C Test

Directions: For the given sample program give the output of the program.


30 Marks

main()
{
int a[]={ 2,4,6,8,10 };
int i;
change(a,5);
for( i = 0; i <= 4; i++) printf("\n %d",a[i]); } change( int *b, int n){ int i; for( i = 0; i < n; i++) *(b+i) = *(b+i) + 5; } The selection process consisted of 3 rounds 1. Written test The pattern is total 100 questions 1 hour time 1. check out the old 98 hexaware paper few qs are from that 2. few qs on tracing the output(simple ons). 3. basic question on computer awarness(very simple ones like expand WAP, etc very simple ones 4 choose the odd man out type of questions ex A E I O choose the odd man. 5 simple math qs like 199^2 - 24^2 etc. 6 opposites and synonymsmanage your time properly 2. GD. 3. Technical/ HR Interview. The selection process consisted of 3 rounds 1. Written test The pattern is total 100 questions 1 hour time 1 Check out the old 98 hexaware paper few qs are from that 2 Few qs on tracing the output(simple ons) 3 Basic question on computer awarness(very simple ones like expand WAP, etc very simple ones.) choose the odd man out type of questions 4 Choose the odd man out type of questions ex A E I O choose the odd man. ex A E I O choose the odd man. 5. Ssimple math qs like 199^2 - 24^2 etc. 6 opposites and synonyms manage your time properly.. No negaive markings 2. GD.:Is internet suitable for Youngers?) IS MBA needed? . etc 3. Technical/ HR Interview.( Interview was very cordial and they asked abt my personal life, native places,my projects, and other technical skills I have. it was really interesting one.. ) 1. 1,!,2,@,3,#,4,$,5, what is next in the series Ans : %. 2. Which is the oldest computing device still in use Ans : Abacus 3. Wat is WAP? Ans : Wireless Application Protocol 4. Nibble is equal to Ans:4 bits 5. Solving Algos : A simple program was given and the output was asked for different values of inputs. 6. I dont remember the exact ques. I am just giving a sample, which is similar to the one given there. 7 S= 0; C = 0 Read A,B While ((2A+3B) < 100) { S = 3A - 2B c = c + 1 } Print a,s,c Following this there were 5 quetions. every ques carried 1 mark. a. Wat is the output if a = 26 b = 12 b. wat is the output if a = 24 b = 16 etc.. c In Mathematics some ques were simple and others were a bit time consuming. d. |X| + X = 0 wat is the value of X a) 1 b) 0 c) 1,0 d) None of these e. If 38473ABC(This was not the exact no given) is divisible by 75 what is ABC in the same order x + 1/x = 2 x^100 + 1/x^100 f(z) = 1/1-x find f(f(f(1/x))) The following questions got repeated from the pattern found in 8 In the series 0, 3, 8, 15,__ What is the next number?Ans : 24 9. X < 0, Y <> 0 then which of the following is always positive? Ans. (x + y)^2
10 Let ax2 + bx + c = 0If the sum of the equal roots is equal to the product of the same roots. Then
which of the following hold true Ans. b+c = 0

11 Find the value of (1.99)2 Ans.3.9601

12 There is a room with 6' x 8'. A 1' tile is fixed along the 4 walls in one row. How many 1" tiles
require to finish the work.Ans. 24

13 2 persons can finish a job in 8 days. First person alone can finish the work in 24 days. How
many days does the second person take to finish the job? Ans. 12 days
14 In a car wheel, two spokes cover 15 degree. Then for the entire car, how many spokes are
there? Ans. 48.

15 What is the angle of degree suspended when two hands of clock showing the time 2.30.
Ans. 105 degrees

16 A person's salary is getting reduced by 20%. What percentage should be added to get back
hisoriginal salary? Ans. 25%
17 Two persons start at the same point, walk in opposite directions with 5km/hr and 5.5km/hr
respectively.

18 What is the distance separated after 2 and half hrs? Ans. 26.25
19 A person starts walking at a speed of 5km/hr through half the distance, rest of the distance he
covers with a
20 speed 4km/hr. Total time of travel is 9 hours. What is the maximum distance he can cover?
Ans. 40km.

21 In a rectangle the length is increased by of the original length . By what proportion should the width
be reduced so that the area will be the same? Ans33

22 Find the nth number in the series is 1, -3, 5, -7.___Ans. (-1)^(n-1)*(2n-1)
23 If a square is formed by the diagonal of the square as an edge, what is the ratio between the area ?
Ans. 2

24. The perimeter of a rhombus is 52 units. One of its diagonal is 24 units.What is its second diagonals
length?Ans. 10

24 A cubical rectangular bar has the dimensions with the ratio 5 : 4 : 3. Its volume is 7500. What is the

surface area of the bar?Ans. 2350

25 3 persons started placementpapers with a capital of Rs.3000 . B invest Rs.600 less than A, C
invest
Rs.300 less than B. Then what is the share amount of B in a profit of Rs.886 ? Ans: Rs. 265.8

26 Wat I felt with this test was it was better to go thro all the 100 ques, cos some easy ones were
there
at the last. If U think U can certainly solve a problem but its time consuming just leave it and
proceed to the next one. Some of the ques were very easy, even U no need to use pen and paper.

SYNONYMS,ANTONYMS & INCORRECT SPELLINGS

Some Usefull Words

1. acrimonous
2. inconspicious
3. bland
4. abate
5. cusp
6. profligate
7. vigour
8. lighten
(check the spellings in dictionary)


APTITUDE SECTION -

odd man out-like man in

1. A E I O ans o - (rest are made of lines now tell me are a big zero)
2. (fig) circle star rectangle another symbol ans star - rest are flowchart symbols
3. programs documents settings properties
ans properties (others appear in START menu - he! my favourite question)
4. processor ,motherboard ,display card, mouse
ans mouse - (others are inside the cabinet -- need out of the box thinking)

Computer Awareness

5. where is SIM card found ans mobile phone (by the way can you expand SIM)
6. what is the lock symbol appearing in bootom of the browser mean
ans. connection secured (confusing another choice is Verisign secured - you will see tick mark when it is
Verisign authorised)
7. expand WAP ans Wireless Application Protocol
8. expand CORBA ans Common Object Request Broker Architeture
9. 92.168.100.4 - means what ans IP Address crack choice a)sums choice b)your head
10. Find the reminder when 333666777888999 divided by 3 or 9 or 11 ?
11. Which is the biggest perfect square amongst the following :
15129, 12348, 23716, 20736
12. In the series 0, 3, 8, 15,__ What is the next number?
13. X < 0, Y <> 0 then what is the possibility that the result is always positive? Ans. (xy)^2
14. Let ax2 + bx + c = 0 If the sum of the equal roots is equal to the product of the same roots.Then which
of the following hold true
(a) a + b = 0
(b) a = 0
(c) c = 0
d) a + c = 0
15. Find the value of (1.99)2 Ans. 3.9601(dont calc - should be near to 4)
16. There is a room with 6' x 8'. A 1' tile is fixed along the 4 walls in one row. How many 1" tiles
require to finish the work.Ans.24
17. 2 persons can finish a job in 8 days. First person alone can finish the work in 24 days. How many days
does the second person take to finish the job? Ans. 12 days
18. In a car wheel, two spokes cover 15 degree. Then for the entire car,how many spokes are there?Ans. 24.
19. What is the angle of degree suspended when two hands of clock showing the time 2.30. Ans. 105 degrees
20. A person's salary is getting reduced by 20%. What percentage should be added to get back his original
salary?Ans. 25%
21. Two persons start at the same point, walk in opposite directions with 5km/hr and 5.5km/hr respectively.
What is the distance separated after 2 and half hrs?Ans. 26.25 (approx)
22. A person starts walking at a speed of 5km/hr through half the distance, rest of the distance he covers with
aspeed 4km/hr. Total time of travel is 9 hours. What is the maximum distance he can cover?Ans.40 km

23. In a rectangle the length is increased by of the original length . By what proportion should the width be reduced
so that the area will be the same?Ans. 33

24. Find the nth number in the series is 1, -3, 5, -7.___Ans. (-1)*(2n-1)
25. If a square is formed by the diagonal of the square as an edge, what is the ratio between the area?Ans. 2
26. The perimeter of a rhombus is 52 units. One of its diagonal is 24 units.What is its second diagonals length?
Ans. 10

27. A cubical rectangular bar has the dimensions with the ratio 5 : 4 : 3. Its volume is 7500. What is the surface
area of the bar? Ans. 2350
28. A persons salary iis decreased by steps of 20%, 15% and 10%. What will be the percentage decrease, if the
salary is decreased in a single shot?
29. 3 persons started placementpapers with a capital of Rs.3000 . B invest Rs.600 less than A, C invest Rs.300 less
than B. Then what is the share amount of B in a profit of Rs.886 ?

30. 178^2 -22^2 (USE (A+B)(A-B))
31. f(x) = x! g(x)=x^10 h(x)= 10^x for large values of x which is greater?
32. f(x) = 1/(1-x) find(f(f(f(x)))
33. x+(1/x) = 2.5 find x^2 + (1/x^2)
34. 2^(2^n) = 256 find 2^(2n)
35. x=0 y=0 6x+7y=42 find position(lies inside/out/on) of (4,5) in the triangle
36. 22 Jun 2003 is sunday which year previously did 22 jun became sunday
37. A man walked 30m west 5m south 10m west 35m north to reach tollgate find the dist from start to gate.ans. 50m (use pythogoras)
38. area of square = sum of areas of rect1(41*27) and rect2(41*14). find square side.ans. 41
39. find next in series 31,29,31,30,31,? ans. 30 he!he!he!(they rep jan,feb,mar,.... hit your head) Walk/Swim
thro Coding
40. Input a,b
s=0; c=a; d=b;
while(d<>0)
{ s=s+c;
d=d-1;
} Print s
for given values of a,b find the output
5questions for different values of a,b
41. Input a,b
while(3a+2b<100) { s=s+a; a=a+2; b=b-1; } for given values of a,b (i remember one 29,5) find the output Tips1. Do the coding first and you are out - They are time consuming - Save the worst for last 2. Be choosy - take the easy (questions) first - So scan scan scan 3. best path in hexaware tree language ----> odd man out ----> computer awareness ----> easy sums -----> difficult sums----> coding do this or find the path to your home.

4.SPEED kills but also wins. Put your brain in 5th gear
5.Blind goose guess - mark a or e - they are more probable
6. Write your q paper code proper or your are a man overboard
7. There is minimum no of q to be attempted(so they didnt say explicitly) and no negative marking. So be
generous!waste your ink! cross off for all questions
8. They will ask u in the pep talk in GD waht is the first or last question or your code.
So watch out all those DANGER-PAST-QUESTIONS-FORGOT type fellows

Group Discussion

1. No GD only shout!!! - Our LOk Sabha Style
2. Shout at top of your voice and shout some meaningful points
3. Please train ur vocal chords! Drink our good pure(pun intended) water before GD
4. IF u cant then carry a loudspeaker
5. 10 per group max 3 groups
6. final interview they select 3 from each group
7. Dont think 1-proposer 1-opposer 1-moderator it could 3-proposer or 3 opposer too.
8. If your group is silent Please follow GD rules.
9. 30 minutes of shouting(3min-choose the topic, 2min-prepare,20min-shout)
10. They might also give you a topic.
11. Please dont wait for your chance - Grab
12. Be ready to summarise. Try to say all the points told and say conclusion is yet to be reached.
13. 2 or 3 choosen people will summarise.
14. Dont ever make unruly gestures. You are out immediately.
15. Be ready for any topic .Only general topic - no subject, economics style Inside Out
Questions you want to ask but dont know to whom
1.Whats the noise? They want to add 500 more in its payroll by christmas
I dont know how much % is freshers
2. How much they can fill your purse?
7500 for first 6 months
10,000 for next 6 months
20,000 thereafter
Indian rupees! No dollar dreams ;-)
3. Any strings?
You have to sign a bond for 1 year and you become James Bond
4. If I break? Your dad pays 1.5 lacs to them.
5. Where they put you? Chennai, Bangalore, Mumbai - should be ready pack your bags in a jiffy
(and many times too)
6. What if I get out in GD or test Pray those in interview should refuse to sign the bond Offer goes
down the line in each campus
7. Any perks One free Cadburys perk on joining Dont like it take Halwa!!!!
8. To how much people they would offer in my college Works out to 5-15% of test takers.


Monday, February 08, 2010

Digital Globals .Net Interview Questions

 Digital GlobalsTechnical FAQs ( .NET , Database , General )


.NET Interview Questions
 1.Difference between VB dll and assemblies in .NET
 2.What is machine.config and web.config
 3.Tell about WSDL
 4.About web methods and its various attributes
 5.What is manifest
 6.Types of caching
 7.What does connection string consists of
 8.Where do you store connection string
 9.What is the difference between session state and session variables
 10.How do you pass session values from one page to another
 11.What are WSDL ports
 12.What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET
 13.What is abstract class
 14.What is difference between interface inheritance and class inheritance
 15.What are the collection classes
 16.Which namespace is used for encryption
 17.What are the various authentication mechanisms in ASP.NET
 18.What is the difference between authentication and autherization
 19.What are the types of threading models
 20.How do you send an XML document from client to server
 21.How do you create dlls in .NET
 22.What is inetermediate language in .NET
 23.What is CLR and how it generates native code
 24.Can we store PROGID informatoin in database and dynamically load the component
 25.Is VB.NET object oriented? What are the inheritances does VB.NET support.
 26.What is strong name and what is the need of it
 27.Any disadvantages in Dataset and in reflection
 28.Advantage of vb.net over vb
 29.What is runtime host
 30.How to send a DataReader as a parameter to a remote client
 31.How do you consume a webservice
 32.What happens when a reference to webservice is added
 33.How do you reference to a private & shared assembly
 34.What is the purpose of System.EnterpriseServices namespace
 35.About .Net remoting
 36.Difference between remoting and webservice
 37.Types of statemanagement techniques
 38.How to register a shared assembly
 39.About stateless and statefull webservice
 40.How to invoke .net components from com components,give the sequence
 41.How to check null values in dataset
 42.About how soap messages are sent and received in webservice
 43.Error handling and how this is done
 44.Features in .net framework 1.1
 45.Any problem found in vs.et
 46.Optimization technique description
 47.About disco and uddi
 48.What providers does ado.net uses internally
 49.Oops concepts
 50.Disadvantages of vb
 51.XML serialization
 52.What providers do you use to connect to oracle database?

Database
53. Types of joins

General
54. What are various life cycle model in S/W development




Microsoft .Net Interview Questions

Microsoft Technical FAQs ( .NET , Database , General )

• HR (Screening)

1. Tell about yourself
2. Tell about your work experience
3. Tell about projects
4. Tell about your current project and your role in it
5. What is your current salary p.a.

• Technical

.NET

6. How do you manage session in ASP and ASP.NET
7. How do you handle session management in ASP.NET and how do you implement them. How do you handle in case of SQLServer mode.
8. What are different authentication types. How do you retreive user id in case of windows authentication
9. For a server control, you need to have same properties like color maxlength, size, and allowed character throughout the application. How do you handle this.
10. What is custom control. What is the difference between custom control and user control
11. What is the syntax for datagrid and specifying columns
12. How do you add a javascript function for a link button in a datagrid.
13. Does C# supports multi-dimensional arrays
14. How to transpose rows into columns and columns into rows in a multi-dimensional array
15. What are object oriented concepts
16. How do you create multiple inheritance in C#
17. ADO and ADO.NET differences
18. Features and disadvantages of dataset
19. What is the difference between and ActiveX dll and control
20. How do you perform validations
21. What is reflection and disadvantages of reflection
22. What is boxing and how it is done internally
23. Types of authentications in IIS
24. What are the security issues if we send a query from the application
25. Difference between ByVal and ByRef
26. Disadvantages of COM components
27. How do we invoke queries from the application
28. What is the provider and namespaces being used to access oracle database
29. How do you load XML document and perform validation of the document
30. How do you access elements in XML document
31. What is ODP.NET
32 Types of session management in ASP.NET
33. Difference between datareader and dataset
34. What are the steps in connecting to database
35. How do you register a .NET assembly
36. Usage of web.config
37. About remoting and web services. Difference between them
38. Caching techniques in .NET
39. About CLS and CTS
40. Is overloading possible in web services
41. Difference between .NET and previous version
42. Types of chaching. How to implement caching
43. Features in ASP.NET
44. How do you do validations. Whether client-side or server-side validations are better
45. How do you implement multiple inheritance in .NET
46. Difference between multi-level and multiple inheritance
47. Difference between dataset and datareader
48. What are runtime hosts
49. What is an application domain
50. What is viewstate
51. About CLR, reflection and assemblies
52. Difference between .NET components and COM components
53. What does assemblyinfo.cs consists
54. Types of objects in ASP

Database

55. What are the blocks in stored procedure
56. How do you handle exceptions. Give the syntax for it
57. What is normalization and types of normalization
58. When would you denormalize
59. Difference between a query and strored procedure
60. What is clustered and non-clustered indexes
61. Types of joins
62. How do you get all records from 2 tables. Which join do you use
63. Types of optimization
64. Difference between inline query and stored procedure

Project related

65. Tell about your current project
66. Tell about your role
67. What is the toughest situation you faced in the development
68. How often you communicate with the client
69. For what purposes, you communicate with the client
70. What is the process followed
71. Explain complete process followed for the development
72. What is the life cycle model used for the development
73. How do communicate with team members
74. How do you say you are having excellent team management skills
75. If your client gives a change and asks for early delivery. How will you manage.
76. How will gather requirements and where do you record. Is it in word / Excel or do you have any tool for that
77. What is the stage when code is delivered to the client and he is testing it.
78. What are the different phases of SDLC
79. How do you handle change requests
80. How do you perform impact analysis
81. How do you write unit test cases.
82. About current project architecture


Satyam .Net Interview Questions

Satyam Technical FAQs ( .NET , Database , General )
.NET Interview Questions

1.Types of threading models in VB.net
2. Types of compatability in VB and their usage
3. Difference between CDATA and PCDATA in XML
4. What is Assync in XML api which version of XML parser u worked with
5. Types of ASP objects
6. Difference between application and session
7. What is web application virtual directory
8. Can two web application share a session and application variable
9. If i have a page where i create an instance of a dll and without invoking any method can I send values to next page
 10.Diffeernce between Active Exe and /Dll
 11.Can the dictionary object be created in client’s ccope?
 12.About MTS and it’s purpose
 13.About writting a query and SP which is better
 14.I have a component with 3 parameter and deployed to client side now i changed my dll method which takes 4 parameter.How can i deploy this without affecting the clent’s code
 15.How do you do multithreading application in VB
 16.About Global .asax
 17.Connection pooling in MTS
 18.If cookies is disabled in clinet browser will session work
 19.About XLST
 20.How do you attach an XSL to an XML in presenting output
 21.What is XML
 22.How do you make your site SSL enabled
 23.Did you work on IIS adminisdtration

• HR questions
24. About educational background
25. About work experience
26. About area of work
27. Current salary, why are looking for a change and about notice period
28. About company strength, verticals, clients, domains etc.
29. Rate yourself in different areas of .NET and SQL


Sunday, February 07, 2010

TCS Technical .Net Interview Questions

TCS Technical FAQs ( .NET , Database , General )


.NET Interview Questions

1. Define .NET architecture

2. Where does ADO.NET and XML web services come in the architecture

3. What is MSIL code

4. Types of JIT and what is econoJIT

5. What is CTS, CLS and CLR

6. Uses of CLR

7. Difference between ASP and ASP.NET

8. What are webservices, its attributes. Where they are available

9. What is UDDI and how to register a web service

10. Without UDDI, is it possible to access a remote web service

11. How a web service is exposed to outside world

12. What is boxing and unboxing

13. What is WSDL and disco file

14. What is web.config and machine.config

15. What is difference between ASP and ASP.NET

16. What is dataset and uses of dataset

17. What does ADO.NET consists of?

18. What are various authentication mechanisms in ASP.NET

19. What do you mean by passport authentication and windows authentication

20. What is an assembly and what does manifest consists

21. What is strong name and what is the purpose of strong name

22. What are various types of assemblies

23. Difference between VB.NET and C#. Which is faster

24. Types of caching

25. How WSDL is stored

26. What is the key feature of ADO.NET compared to ADO

27. How does dataset acts in a disconnected fashion

28. Does the following statement executes successfully:

29.Response.Write(“value of i = ” + i);

30. What is ODP.NET

31. What are the providers available with VS.NET

32. What is a process

33. What is binding in web service

34. How a proxy is generated for a web service

35. About delegates

36. What are static assemblies and dynamic assemlies. Differences between them


Database Interview Questions

37. What are the types of triggers

38. Types of locks in database

39. Types of indexes. What is the default key created when a primary key is created in a table

40. What is clustered, nonclustured and unique index. How many indexes can be created on a table

41. Can we create nonclustured index on a clustered index

42. Types of backups

43. What is INSTEAD OF trigger

44. What is difference between triggers and stored procedures. And advantages of SP over triggers

45. What is DTS and purpose of DTS

46. Write a query to get 2nd maximum salary in an employee table

47. Types of joins.

48. What is currency type in database

49. What are nested triggers

50. What is a heap related to database


General Interview Questions

• HR Interview Questions

About yourdelf

About procsses followed

Notice period

Appraisal process

What is SOAP and why it is required

About effort estimation

Whether salary negotiable

Why are looking for a change

How fo you appraise a person

Do you think CMM process takes time

About peer reviews

How do you communicate with TL / PM / Onsite team



Infosys .Net Interview Questions

Infosys .Net Interview Questions ( .NET , Database , General )
.NET

1. How do you rate yourself in .NET
2. What is caching and types of caching
3. What does VS.NET contains
4. What is JIT, what are types of JITS and their pupose
5. What is SOAP, UDDI and WSDL


Database
6. What is dataset
7. How do you optimize SQL queries

General

8. Tell about yourself and job
9. Tell about current project
10. What are sequence diagrams, collaboration diagrams and difference between them
11. What is your role in the current project and what kinds of responsibilites you are handling
12. What is the team size and how do you ensure quality of code
13. What is the S/W model used in the project. What are the optimization techniques used. Give examples.
14. What are the SDLC phases you have invloved


Keane .Net Interview Questions

Keane .Net Interview Questions ( .NET , Database )
.NET
1. Write steps of retrieving data using ado.net
2. Call a stored procedure from ado.net and pass parameter to it
3. Different type of validation controls in asp.net
4. Difference between server.Execute and response.redirect
5. What is Response.Flush method
6. How Response.flush works in server.Execute
7. What is the need of client side and server side validation
8. Tell About Global.asax
9. What is application variable and when it is initialized
10. Tell About Web.config
11. Can we write one page in c# and other in vb in one application
12. When web.config is called
13. How many web.config a application can have
14. How do you set language in web.cofig

Database interview questions
15. How do you rate yourself in oracle and sql server
16. What is E-R diagram
17. Draw E-R diagram for many to many relationship
18. Design database raw er diagram for a certain scenario(many author many books)
19. Diff between primary key and unique key
20. What is Normalization
21. Difference between sub query and nested query
22. Indexes in oracle
23. Query to retrieve record for a many to many relationship
24. Query to get max and second max in oracle in one query
25. Write a simple Store procedure and pass parameter to it


DELL .Net Interview Questions

DELL .Net Interview Questions ( .NET , Database , General )

.NET


1. Any disadvantages in Dataset and in reflection

2. Difference between Active Exe and Activex dll

3. Can we make activex dll also ti execute in some process as that of client ? How can we do?

4. Types of compatabilities and explain them

5. Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default

6. What is assembly?

7. Difference between COM and .NET component

8. What is early binding and Late binding. Difference which is better

9. What happens when we instantiate a COM component

10. What happens when we instantiate a .NET component

11. Are you aware of containment and Aggregation

12. What is UUID and GUID what is the size of this ID?

13. About Iunknown interface Queue ,its methods Querry Interface Addref,Release and Explane each

14. What ‘ll u do in early and late binding

15. In early binding will the method invoked on com component will verify it’s existance in the system or not?

16. Difference between dynamic query and static query

17. About performance issues on retrieving records

18. About ADO and its objects

19. What is unmannaged code and will CLR handle this kind of code or not .

20. Garbage collector’s functionality on unmanaged code

21. If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?

22. Threading Types.

23. How about the security in Activex DLL and Activex EXE

Database Interview Questions :

24. Types of cursors and explanation each of them

25. Types of cursor locations and explanation on each of them

26. Types of cursor locks and explanation each of them

27. How do you retrieve set of records from database server.{Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }


Tell Me about Yourself

“Tell Me about Yourself” Interview Questions and Answers

In brief: “During a job interview, the interviewer can ask many questions. Some of the common questions are the ‘Tell Us about Yourself’ interview questions. Your answers to these questions are important. Make sure that you are prepared for these types of interview questions.”

A job interview is one of the most important personal interactions that an individual does. It is therefore utmost important that a person is well prepared for every aspect of a job interview. In fact, most of the interview time schedule is spent on many aspects of the tough interview questions - “Tell Me about Yourself” and your interview answers.

4 common “Tell Me about Yourself” interview questions and answers

1. A brief summary of your personal details: Your have to give your name, where you are from, your family members and a brief review of your resume. You may also provide any other personal detail that you would feel like providing.

2. Education: You should tell the interviewee about your educational qualifications and any relevant miscellaneous educational qualifications that you might have accumulated.

3. Professional experience: Regular questions during a job interview are “tell me about your professional experience”. Depending on whether you are a fresher or an experienced professional, you should share your previous job experiences. If you are a fresher, then, you could tell anything that you think would be relevant for the job. You may provide a scope of your educational capabilities and strengths or any of your hobbies, etc.

4. Your weaknesses and strengths: One of the tricky interview questions that you might be asked is “tell me about your weaknesses and/or strengths”. Therefore, you should make a preparation to such questions. A common mistake is to take strength and present it as a weakness. You should be honest. You may share one-two of your weaknesses and the way you have correct or handled (successfully) these weaknesses. On the other hand, do not boast your strengths. Tell about some of your strengths as positive impacts to your professional capabilities.

6 Tips for “Tell Me about Yourself” interview answers

Try to be as much clear, precise and frank. When interviewing and answering “tell me about yourself” questions, you should avoid common mistakes and stick to the facts as follows:

1. Keep the information crisp and relevant: One of the first things to remember is to keep the information crisp and relevant. Try to speak in short sentences and further, try to give them as much of information in as less a timeframe. Here is a brief idea of what you would be saying:

2. Do not repeat information from the CV: You should ensure that none of the information that you provide about yourself is repeated or duplicate as compared to your curriculum vitae. Therefore, even your curriculum vitae should have only the necessary and relevant information, while all other miscellaneous information should be disclosed during the ‘tell me about yourself’ answers.

3. Fabricated or fake information: Another important thing that you should remember is that you should not give any fabricated or fake information while answering the Tell Me about Yourself Interview question. Background checks today have become very important and strict. Companies are known to sack people even after years of working, simply on the basis of some false information provided to them during the initial interview.

4. Irrelevant and unnecessary information: It is very important that no irrelevant and unnecessary information is given out during the question. The question seems to be quite simple, but it is actually one of those make or break questions, from which an interviewee can never recover and therefore loses the job opportunity.

5. Facts and figures: While telling about yourself, be prepared to be asked further questions about any facts and figures that you have provided. For example, if you have said that you have a Bachelor’s degree, make sure that you carry a copy of the same. Any information given without the relevant proof for it is deemed as suspicious and ambiguous.

6. Do Not Tell them about: You should not disclose too much information for the interviewer. You might tell that your hobby is fishing, but telling about your last fishing trip in which you missed a big fish would be too much information, unless the interviewer is a big fishing fan and actually goads you into telling the details. Also, you should not give them too much information about your family members. Of course, you would have to inform them about the number of family members that you have, and whether they work or not, and if yes, where, those kinds of details, but telling them anything apart from that is not suggested.

ALL IS WELL ... ALL THE BEST



Wipro Infotech .NET interview Questions

Wipro Infotech .NET interview Questions (05Feb2010)

1. when you will use HttpHandlers

2. what you will impiment in HttpModule

3. In the Page , suppose in preRender value=x and in the pageload value=y after page loads which value will be displayed.

4. how you will improve the webapplication performance.

5. What is Agile methodology ? which methodolgy followed in your project ?

6. How many members can be work by implimenting Scrum/Iteration methods ?

7. What is Ajax ?

8. Difference between Asynchronous and Synchronous ?

9. which is the best gridview or repeater

10. exception handling in stored proc.. how you will catch an error message

11. exception handling in asp.net application..(expecting log files to be create in production live )

12. how many members involve in scrum methodology

13. how u implimented design patterns in ur projects

14. how you will reduce the page size

15. what will happen if we use response.buffer and response.flush

16. how u will refresh the page using .net code

17. what is webservice

18. what is soap

19. how u will consume the webservice in asp.net application

20. how u will set proxy to access webservice

21. what is wsdl

22. Windows and Forms Authentication

24. In Forma Authentication how you will validate the users if it is in database

25. When you will use State Server and SqlServer

26. State Management

27. Valid XML format

28. programming : Write a code in Ajax ,select one dropdownlist based on that it should reflect in another dropdownlist

29. programming : In table , having States as a coulmn. based on coumn it should be displayed a record using DataTable

30. programming : select dropdownlist based on that it should be displayed on Gridview

31. programming : In gridview, first column value should be displayed tooltip

32. programming : need to popup dialog box every 20 min ok and cancel button should be displayed

in the ok button and the cancel button code what code you will write.


Wipro Sharepoint Interview Questions

Wipro Infotech Sharepoint Interview Questions (MOSS)


1) Can you introduce your self ? What is your Responsibilities in This Project..?

2) Have you ever worked on Master page..? What is the use of master page..? Can you tell me , I want to put the

Dropdown control in master page, and this dropdown control should populate the data from database..?

3) How can you create and deploy the workflows by using Visualstudio 2005, tell me the stepwise

4) Can you tell me how to create the HRLeaveapproval workflow by using SPDesinger..?

5) What is the use of infopathforms.?
I have the List called ”Employees”,in that there is a Field called ” Department”,
I want to Fill the Department names in the infopathform control
( eg: Take the Dropdown control , i want to fill this Department names in Dropdowncontrol)

6) 10 users entering the data in infopath forms and submit the data,
now i want to generate the reports for those 10 users, how can you do this ..?

7) What is the use of BDC…?

8) How can you Configure the Enterprise Search ..?

9) What are the Base class methods you used in developing custom webparts..?

10)How many ways you can deploy the custom webparts ? with out install in GAC,
is there any other way to deploy ..?

11) About Execl Services,

12) Feature event receivers Classes…?

13) What is the use of “Run with elevated Previliages”…?

BlueStar Infotech .Net Interview Questions

BlueStar Infotech .Net Interview Questions

1)Interfaces and Abstract classes
( Definitions , Advantages , differences , on which scenarious you will iplimemnt both )

2) OutputCache (How you will impliment Cache in your application )

3) Tell me about OOPS concept

4) What is Polymorphism, explain the scenario

5) What are the Securites in WCF

6) what is CLS (Common Language Specification ) ?

7)Assembly
(Definition , types (private and shared assembly) brief explanation

8) Clustered and Non-clustered index

9) what is WCF, WPF , WWF, WCS

10) Userlevel securites

11) what is Encapuslation

12) what is Endpoint?

13) How u will host in WCF

14 Sessions , Cookies , Caching


Sql Server Interview Ouestion :

15) table structure

16) Sql server 2005 features

17) eXCEPTIONAL HANDLING IN sQLSERVER 2005

18) Did you ever tried with LINQ give me the example

19) StateManagement

20) Differences between functions and StoredProcedures

21) what is Instead of Trigger

22) Stored Procedures

13) What is Lock ?

14) What is Optimistic and Pessimitic in (locking , Cursors)

17) views

22) table structure

23) Sql server 2005 features

24) eXCEPTIONAL HANDLING IN sQLSERVER 2005

KARVY .Net Interview Questions

KARVY .Net Interview Questions
-----

1. What is ViewState (brief description)
2. what will happen if put runat="server"
3. page load events
4. Caching in asp.net
5. IsPostBack
6. difference between HTML controls and web controls
7. Regular Expressions
8. abstract class and interfaces


SQL Server Interview Questions
-----------
9. select * from employee where 10000=20000

10. select * from employee e1 where e1.col1=1

11. select * from employee e1 where ename not in
(select * from employee e2 where e2.creativedat<='01/11/91')

Microsoft SqlServer Interview Questions

1) what are the new features in SqlServer 2008 ?

2) what is the purpose of MERGE in SqlServer 2008?
why do we need ?

3) How many tables can we create in single database ?
Can we create 1 lakh tables in a single database ?

4) How many columns can we create in a single table ?
Can we insert data which having datatype varchar(8000) for each column ?

5) Where can we get total rowcount ?

6) Insert a query by using single quote .
Suppose Employee is a table, Ename is column.
How you will insert Jagan's Interview in Ename column

7) Brief description of Delete & Truncate

8) What is the use of identity ?
for suppose total 10 rows are in a table
Identity is (1,1) and i deleted all rows by using Delete statement
if i inserted 11th row in a table. What will be the identity value
if i truncated all rows and if i inserted 11th row in a table.
What will be the identity value (give me brief explanation)

9) Can we drop Clustered index without dropping a primary key.
Can we created Clustered index in another column. what Clustered index will do

10) I want to delete a record and i want to insert that record in another table.
Write a query in a single statement.
Ans) need answer

11) what is Unit testing and integrated testing ?
if i'm modifying a column datatype varchar(100) to varchar(50) in database.
Now the application is in production ? Are you will do Unit testing or Integrating testing.
Is it will effect to application ? did we need to check the validation ?

12) Have you worked on DTS package ?

13) Have you worked on SSIS ?

NessTechnologies .Net Interview Questions

1. Differences .NET Framework versions ( 2.0 , 3.0 , 3.5 )

2. LINQ ( samples ) , Advantages / Disadvantages

3. WCF Services

4. Web services - Java cosumptions

5. Web services -exposing

6. ASP.net - any deploying problems

7. Hosting Environment

8. ASP.net page life cycle

9. Authentication and Authorization

10. Assemblies ( GAC , Load , diff versions - > bending redirect )

11. Generics - Advantages

12. static constructors and static methods

13. Callbacks ( Scripts callbacks )

14. Asynchronous callbacks using Delegates

15. DOM parsers

16. Ctype and Ptype

17. Design patterns

18. String and String.Builder

19. state management

20. Array Reverse

21. interface and abstract

22. polymorphism

23. Enterprice library differences (hpw u will replace 4.0 on 3.0)

SQL Server Interview Questions:

24. How u will pass parameters in procedure through programming ( count of paramters )

25. sp_help_text

26. how to find duplicate records and to delete

27. cursors

28. indexing

29. excepting handling in stored proc


ValueLabs .Net Ineterview Questions

1.Give some Scenario for Non Clustered index?

2.Can we write system defined functions in side The Function?

3.What is the Unique Data type?

4.I have a table in which phno is one of the columns.i do have some values in tht phno column.
i need to update phno column values with 0(zero) as prefix.give me a correct solution plz.

5.what is IDE,DMV in sql server?

6.Where is global assembly cache located on the system?

7.What is the difference between functional test type and navigation test type?

8.What is an assembly?

9.Give difference between Intranet application, client server application, and web based application
Are applications developed in Java, html, servletts client server or web based..

10.Is web based application a 2 tier or 3 tier application.

11.what is 2 tier and 3 tier application.

12.How can we Achieve Late binding in C#.Can any give one example.

13.Difference between regression testing and re-testing

14.how u get the build ?what is the size of the build?

15.Can we share session between ASP.Net & ASP

16.Which Security Algorithm used to encrypt the data? a) DES b)RC2 c)Triple DES d)All the above

17.Can we Classic ASP,.Net 1.0, .Net 1.x and .Net 2.0 installed on the same system?

18.what is the difference between HashMap and Hashtable

19.Difference between DataGrid and Girdview?

20.Difference b/w .Net 2.0, 3.0 and 3.5 ?

21.Diff b/w dispose & Finalize Methods?


SQL Server Interview Questions :
1.What is the difference Between Sql-server 2000 & 2005

2.What is the use of placing primary key and foreign key constrains on columns.

3.What is the difference between distinct clause and group by clause?

4.Can I remove the default constraint columns in SQL SERVER?


Saturday, February 06, 2010

ValueLabs NET Technical Paper

Value Labs .NET Technical Paper (60MINUTES)

1. WRITE A PROGRAM THAT ASKS A USER A FOR 5 NUMBERS AND PRINTS THE AVERAGE OF THESE NUMBERS.

2. WRITE A PROGRAM THAT PROCESSES THE FOLLOWING STRING :

STRING SENTENCE =”LEARNING”C# IS EXTREMELY EASY &FUN,ESPECIALLY AT
PROGRAMMERS HEAVEN ! C#HAS A DATA TYPE BYTE WHICH OCCUPIES 8 BITS AND
CAN STORE INTEGERS FROM -128 TO 127 .”;

Iterate through the string and find the number of letters , digits and
punctuation characters in it and print these to the console.

3.Can we override the properties and apply polymorphism on these?

4.When I compile and run the following program what’s the output?

using System;
namespace CSharp
{
Class Test
{
static void Main()
{
Parent theparent=new Child();
Console.Writeline (“i={0}”, theParent.i);
theParent.MyMethod( );
}
}

class Parent
{
public int i = 5;
public virtual void MyMethod( )
{
Console.Writeline(“I am parent’s mymethod( )”);
}
}
}

class Child : Parent
{
public int i =7;
public override void MyMethod( )
{
Console.Writeline(“I am Child’s mymethod( )”;
}
}
}

5. what is the difference between the destructor and the Finalize( ) method?
When does the Finalize( ) method get called?
6. Abstract classes may contain constructors. When we can’t instantiate the
Abstract classes, what is the use of these constructors?

7.
We all know that sub-classes can call the methods defined in the base-class .
Write a program where a base-class calls the method defined in the subclass ?

8.
What is the basic difference between the String and the StringBuilder class ?
What is the difference between the Intern() and Copy() methods of the string class ?

9. what are delegates ? what are the steps involved in creating an event ? Please explain this by writing a code .

10.
How can we know a state of a thread ?

11. what is .NET Remoting ? which class does the remote object has to inherit ?

12. How can we call methods in remoting asynchronously ? What is Asynchronous One-Way Calls ?

13. What is marshalling and what are different kinds of marshalling ?

14. what are custom controls ? Write a code which defines how to create and use a custom control in ASP.NET ?

15. What are different ways by which a control can be binded with client side scripts in ASP.Net ?

16. Write a code to load and use a dll dynamically in ASP.NET .

17. Write a validation expression for a textbox whose valid format should be in form of hh:mm ( where “hh” signifies as hour between 0-23 and “mm” signifies minutes between 0-59).

18. Write a code to build a datagrid in ASP.NET which displays EmployeeId , name and hiredate. Write the query also to get the same.

19. Related to question 18 above write a code to display the employee Address details in a poop up window which will be displayed on clicking on Employee details in a popup window which will be displayed on clicking on Employee ID. Make sure that there is no DB hit for the second time.

20.
What are the disadvantages of viewstate in ASP.NET.