Download tspl Placement Papers in MS Word and PDF Format for Job Interview

TSPL PAPER ON 12th June 2007 AT MUMBAI

Hello friends TSPL,s paper are very easy, so dont take tension.

It had 2 rounds of the Test
1] Aptitude 30 questions in 30 mins.
2] Technical questions 45 mins.

Aptitude is very easy just refer RS AGARWAL and other placement companies papers. Major focus on LOGIC & MATHEMATICS so do well. Very tricky questions and may be funny too.

In logical reasoning determine the pattern, and other small questions
in maths series, questions on speed distance and time, loss profit, ratio proportion, and many other.

In technical papers
1/4 page
1- Advantages and Disadvantages of Normalization
2- Pros & Cons of Indexing in Tables
3- Explain Outter Join Concept.
4- Explain Locking Mechanism should be provided on multiuser using same database.

2/4 page
1- write query about no of cars sold from the database table containing no of fields like cars_name, car_model, car_make, price, customer_name, manufacturer,s name etc.
2- write query again here they provided with some data how it should display the output acc we have to write the query
and also given 2 tables on which query has to be written . Little bit tough. but ok. with some one good in SQL QUERY WRITTING

3/4page
1- provided with the case study and along with it we have to design the tables and show ER diagram and no. of screens for entry. It was regarding company want to store employees current and previous salary along with the different job locations in their different branches. It was easy.

4/4 page
1- Write 5 steps required for Application Design Stage.(theoretical) decide front end & back end, explain about prototype, and write what you know about design phase in software engineering

THIRDWARE PAPER ON 17th AUGUST

hai frnds,
Here are some questons of tspl on august 17

q.1.> If "24 H in a D" means "24 hours in a Day", then what does the following mean
a] "1000 Y in a M".
Ans: 1000 years in a Millenium.
b] "6 B to/on a O in C".
q.2.> No. series:: 144, 121, 100, 81, 64,..
Ans: 49.
q.3.> A man & his son met with a car accident, the father dies but the child is rushed to the hospital.
When he arrives, the surgeon says, "I cant operate on him, he is my son!"
How can that be?
q.4.> An electric train is moving southwards, but the smoke is moving westwards,...blah..blah...
Ans: An electric train doesnot emits smoke!!!
q.5.> A girl has some pets. There are all but 2 dogs, there are all but 2 cats & there are all but 2 goats.
Whats the total no. of pets?

Ans: I got 6 pets but the interviewer says its 3, "check it out!!!!"
q.6.> A man gets a raise of 5% for a year, then the next year his pay is cut by 2.5% and the net amount with him is Rs.22709.68.
What was the actual amount?
q.7.> In a party of a family there are 2 fathers, two sons, one father-in-law, one mother-in-law, one daughter-in-law & 1 grandson.
Whats the minimum no. of people in the party?
Ans: 5 M W
|\ |
M W
\ /
S
q.8.> A man sends his son to the market to buy mangoes. He gives the son 100 pence to buy 100 mangoes.
In the market there are 3 kinds of mangoes: good mangoes each for 10 pence, average mangoes each for 5 pence, & not so god mangoes for .5 pence each.
what type of mangoes & how much should the son buy ?
Ans: 90 mangoes for .5 pence each. 9 mangoes for 5 pence each, 1 mangoe for 10 pence.
q.9.> Three childs are born each second. Whats the no. of children born in the year 2001?
q.10.> In a year some fractions of girls & some fraction of boys graduate from High School. If of them a/b of girls & x/y of boys go to college. Whats the fraction
of students who go to college? "Cant remember the fractions!!!!"
q.11.> If in a jar there are jelly beans, some blue, some green, some yellow in colour, then what minimum amount of jelly beans should be picked to get two of the same colour?
Ans: 4
q.12.> Three friends divide among themselves equal amount of money. If after spending Rs. 4 each they have left with them the sum of Rs.6,
then what was the original amount with them?
Ans: Rs. 18

q.13.>Bob mother had 3 childrens,out of them 1 was Alex other was John,so who was the 3rd child?
Ans: BOB
q.14.>
q.15.>
q.16.>
q.17.>
q.19.>
q.20.>
Bas yaar itna hi yaad aaya. Pls refer Shakuntala Devi for further assitance.

q.1.> If "24 H in a D" means "24 hours in a Day", then what does the following mean
      a] "1000 Y in a M".
      Ans: 1000 years in a Millenium.
      b] "6 B to/on a O in C".
q.2.> No. series:: 144, 121, 100, 81, 64,..
      Ans: 49.
q.3.> A man & his son met with a car accident, the father dies but the child is rushed to the hospital.
      When he arrives, the surgeon says, "I cant operate on him, he is my son!"
      How can that be?
q.4.> An electric train is moving southwards, but the smoke is moving westwards,...blah..blah...
      Ans: An electric train doesnot emits smoke!!!
q.5.> A girl has some pets. There are all but 2 dogs, there are all but 2 cats & there are all but 2 goats.
      Whats the total no. of pets?
   
      Ans: I got 6 pets but the interviewer says its 3, "check it out!!!!"
q.6.> A man gets a raise of 5% for a year, then the next year his pay is cut by 2.5% and the net amount with him is Rs.22709.68.
      What was the actual amount?
q.7.> In a party of a family there are 2 fathers, two sons, one father-in-law, one mother-in-law, one daughter-in-law & 1 grandson.
      Whats the minimum no. of people in the party?
      Ans: 5  M  W
              |\ |
              M  W
              \  /
                S  
q.8.> A man sends his son to the market to buy mangoes. He gives the son 100 pence to buy 100 mangoes.
      In the market there are 3 kinds of mangoes: good mangoes each for 10 pence, average mangoes each for 5 pence, & not so god mangoes for .5 pence each.
      what type of mangoes & how much should the son buy ?
      Ans: 90 mangoes for .5 pence each. 9 mangoes for 5 pence each, 1 mangoe for 10 pence.
q.9.> Three childs are born each second. Whats the no. of children born in the year 2001?
q.10.> In a year some fractions of girls & some fraction of boys graduate from High School. If of them a/b of girls & x/y of boys go to college. Whats the fraction
       of students who go to college? "Cant remember the fractions!!!!"
q.11.> If in a jar there are jelly beans, some blue, some green, some yellow in colour, then what minimum amount of jelly beans should be picked to get two of the same colour?
          Ans: 4
q.12.> Three friends divide among themselves equal amount of money. If after spending Rs. 4 each they have left with them the sum of Rs.6,
       then what was the original amount with them?
       Ans: Rs. 18 
      
q.13.>Bob mother had 3 childrens,out of them 1 was Alex other was John,so who was the 3rd child?
        Ans: BOB
q.14.>
q.15.>
q.16.>
q.17.>
q.19.>
q.20.>