Wednesday, August 31, 2011
Friday, August 26, 2011
SOME BASIC APTITUDE FORMULAS
Question 1
Can you give a simple formula to find average of sum of squares of first n natural numbers ?
Answer 1
(n+1)(2n+1)/6 can be used to calculate the average of sum of first n natural numbers.
Question 2
Given log x(ab) and log x(a/b) , how you will find log xa
Answer 2
log x(ab) can be written as log x(a) + log x(b) .... equation 1. log x(a/b) can be written as log x(a) - log x(b) ... equation 2.
Solving equation 1 and 2 we will get log x(a) = (log x(ab) + log x(a/b) / 2)
Question 3
Consider a rhombus with diagonals of lengths d1 and d2. What could be its area ?
Answer 3
Area of the rhombus = 1/2(d1 X d2)
Question 4
Quick Answer Required ; Can you quickly tell the ratio of the volume of a cylinder of height h to that of another cylinder of unit height but with same radius.
Answer 4
Height h is the answer. Reason. Volume V1 of cylinder of height h and radius r, V1 = ∏r2h Volume V2 of another cylinder of unit height of same radius r, V2 = ∏r2 (by substituting 1 for h) Now answer is, V1/V2 = h
QUERY BASED QUESTIONS
Interview Question 1
Can you quickly suggest a SQL query that can remove duplicate rows from a table ?
Answer 1
Delete from table a where rowid > ( select min(rowid) from table b where a.key = b.key)
(You can think of more ways to do the same task.)
Interview Question 2
Can a sql query employing group by clause have aggregate functions on the return set ?
Answer 2
Yes, it is definitely possible. Only thing to remember is that the return set may not have columns other than those based on which group by is being performed.
Interview Question 3
In context of SQL results, what is called a phantom read ? How this could happen ?
Answer 3
When two identical select queries are being executed, the first one and second one giving out different sets of results is called phantom read.
This happens when SELECT query does not acquire appropriate locks which literally allows insert queries to modify the rows in between the two identical select queries.
Interview Question 4
Name any four database objects on which GRANT statement can be applied ?
Answer 4
Objects on which GRANT statement can be applied include tables, views, stored procedures & sequences
Thursday, August 18, 2011
Get an idea for project whitepaper titles
IDEA:
1. www.cognizant.com/whitepapers
• www.virtusa.com
www.tcs.com/resources/white_papers/pages
CLASSIFICATION:
www.os.ism.com/certify /cells/tv_index.sgtm
www.lpi.org/eng/clasification/the_lpic_progr
www.asco.com
www.adobe.com
www.microsoft student pariness.com
www.studentreps.mozilla.org/en/
www.dreampark.com
www.imaginecup.com
aws.amazon.com
STUDY:
1) www.opensource.net
2) www.roseIndia.com
a) System projects
b) Web app
c) Window
3) www.sourcecodeworld.com
all coding
4) www.sourceforge.com
5) www.freshmeat.com
6) www.open.org
a) Perl
7) www.berios.se
8) www.msglarge.com
9) www.ow2.org
10) www.jboss.com
11) www.pear.com
a) Php
12) www.codeplex.com
13) www.directory.fsp.org
14) www.codeproject.com
a) Front end
15) Msdn.microsoft.com/en_us/
a) Msdn designer web alone
16) Developer.android.com
Preparing For An Interview With Most Commonly Asked Questions
How to prepare for Interview ?
Question : Tell /Describe about yourself ( you will be asked this 90% )
Answer : Don't recite your resume. Tell about your education, experience, projects worked ,passion etc.,Make sure you complete this within 2-3mins.
Q: Why should we hire you into our organization
A : This would be perfect time to tell about your strengths,achievements & assets. Compare your profile with the job role & justify that you will be a best fit for the job. Answers like ‘This is a best company’ , ‘I want a job in this field’ wont impress the interviewer.posted at www.bankexamsindia.com
Q : What are your strengths & weakness ?
A: Again this is also a commonly asked question to test how much you know of yourself.Make sure the Strengths you say have some relation to the job you applied.’I am very good in english’ can be said as ‘I have good communication skills’ ,
Weakness - ‘I don't have any weakness’ means you are not ready to talk about it.Similarly don't say something like, ‘Im short tempered & get angry very soon’ – It gives an impression that you are not fit to work in group.Say something which does not affect the working & also describe about the steps taken to overcome that.
Q: Where do you see yourself after 5 years ?
A: This question would be asked to check how much you know about the career path.
‘After 5 years,I want to be in your seat’ wont work in any case.Think realistically, understand the growth opportunities of that job & put it across to them.
Q : Why are you shifting from your current employer/company (for experienced people)
A : This would be a tricky question & you have to answer by choosing proper words.Give the real reason, but make sure you don't put the blame on your previous company nor onto yourself.
These are just few questions that can be asked during an Interview ,but the list is exhaustive.So be prepared to answer any question with confidence.But , Never ever get tensed – It pulls your confidence down & will throw you out of the competition.
Question : Tell /Describe about yourself ( you will be asked this 90% )
Answer : Don't recite your resume. Tell about your education, experience, projects worked ,passion etc.,Make sure you complete this within 2-3mins.
Q: Why should we hire you into our organization
A : This would be perfect time to tell about your strengths,achievements & assets. Compare your profile with the job role & justify that you will be a best fit for the job. Answers like ‘This is a best company’ , ‘I want a job in this field’ wont impress the interviewer.posted at www.bankexamsindia.com
Q : What are your strengths & weakness ?
A: Again this is also a commonly asked question to test how much you know of yourself.Make sure the Strengths you say have some relation to the job you applied.’I am very good in english’ can be said as ‘I have good communication skills’ ,
Weakness - ‘I don't have any weakness’ means you are not ready to talk about it.Similarly don't say something like, ‘Im short tempered & get angry very soon’ – It gives an impression that you are not fit to work in group.Say something which does not affect the working & also describe about the steps taken to overcome that.
Q: Where do you see yourself after 5 years ?
A: This question would be asked to check how much you know about the career path.
‘After 5 years,I want to be in your seat’ wont work in any case.Think realistically, understand the growth opportunities of that job & put it across to them.
Q : Why are you shifting from your current employer/company (for experienced people)
A : This would be a tricky question & you have to answer by choosing proper words.Give the real reason, but make sure you don't put the blame on your previous company nor onto yourself.
These are just few questions that can be asked during an Interview ,but the list is exhaustive.So be prepared to answer any question with confidence.But , Never ever get tensed – It pulls your confidence down & will throw you out of the competition.
Subscribe to:
Posts (Atom)