Filter

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

List of all download jkt placement papers in ms word and pdf format for job interview. Click Here View Job List. This page will help you to get all details about download jkt placement papers in ms word and pdf format for job interview. Download jkt placement papers in PDF and Ms word format. Latest and jkt last 5 years placement papers with solutions pdf download for campus job.

JKT Placement Paper : Whole Testpaper Noida - 19 May 2007

JK TECHNOSOFT PAPER ON 19th MAY AT NOIDA

Hi Everyone, hallo....we are students From Bhai Parmanand Institute of business Studies(BPIBS) a Delhi (gvt. colleg) Affiliated to I.P University, delhi. we attended the offcampus of JK Technosoft on 19th May 2007 at sector 3 Noida at their office.

The Jk people were looking for freshers who could work on Progress (a Relational Database by Progress(www.progress.com)) There were around 150 - 200 people only 18 managed to clear the written.
There were only two rounds first was a two and half hour paper and after that there was an interview that was taken on some other date.

INTERVIEW PROCESS......
The interview included questions mainly from the same question paper.Some were asked questions from topics like:
1.locking.
2.joins(inner ,outer)n difference b/w them.
3.locking in distributed Environment.
4.sql queries.
5.and some basic HR ques..like tell me something about urself...bla bla...just b confident.and ya if u clear the written ur chances of getting in are almost 80%.

THERE WAS NO NEGATIVE MARKING...AND YA PREPARE RDBMS N OOPS CONCEPTS WELL.

WRITTEN EXAM........
The paper consisted of 11 Questions and questions were from DBMS only
The paper was of 100 marks and the time alloted were two and half hours.
ALL QUES WERE MANDATORY...

Q1) There is a company XYZ that deals with the sports goods like bats,balls,hockey,nets etc... .The company has a regular list of 10000 customers and each customer always purchases from his favourite list. he can only have 3 items in his favourite list. The company XYZ has 20 salesman that deals with the goods The company salesman has the target that he has to acheive. Now the company want to computerize this whole process. so it came out with the following essential details.
a) customer details
b) salesman target details
c) items information
d) customers order information

Now on the basis of the following information Answer the following Questions.
1) Give the complete database design process of the above scenario the Database should be resolved upto 3Nf. (20)
2) Draw ERD showing 1:1 ,1:many, many:many relationships(10)
3) show Primary and Foreign key of each of the relations(tables) that you make (5)
4) Take any Relation from your design and make it in such a way that it voilates the 1Nf .(5)
5) Does ur design has an may to many relation? if yes, how would you resolve the many:many Relations.(10)

Q2) Emp(eid,ename) Phone(eid,phonetype,phonenum)
1) select the names to those employee who don,t have phone(5)
2) change the phonetype of all the employee from office to home and from home to office.
3) there was another query which used left outer join..

Q3) what is self join?why do we need to make self joins?
Q4) Explain self join with the help of an example taken from Q1 or Q2
Q5) what is deadlock. Explain with an example how it can be avoided.
Q6) what is difference between RAD and .....
Q7) list all the advantages of using Index.
Q8) what is the difference between Having and where clause give eg.
Q9) what are the various disadvantages associated with using index
Q10) Explain Optimistic and Pessimistic Locking.In which case optimistic is used and when pessimistic is used?(10)
Q11)what is denormalization? when do we need to perform denormalization?

JKT Placement Paper : JKT Paper Candidate Experiences LBSIM - 15 July 2006

JK TECHNOSOFT PAPER AND INTERVIEW ON 15th JULY 2006 AT LBSIM

Selection Procedure..
Techinal + Aptitude writtent test (1 hr)
GD + Interview (GD is not a elimination round)

Process started with company presentation, then written test.

In Technical paper, questions were from RDMS and Java. Total 30 questions were there. Few questions in RDBMS were very general n some questions were quite tough. Questions on java were quite simple. one question was ... In which class setBackground() is defined. There was -ve marking in technical paper.

In Aptitude paper, there were no choices provided.. Thirty questions were there in total. 3 questions were to find the odd one out from the series. 2 questions were from shakuntaladevi, one question from clock. one on relations. there were no -ve marking in this paper.

In GD, My topic was "Are foreign channels destroying indian culture". I was against the topic.. n most of us were against the topic.. All of us were asked to conclude the discussion one by one, in the end. I had gd on 3rd Aug 06 and interview on 22nd Aug 06. Interview was planned on the same day of GD but due to some problem they couldnt do so..
In the interview, questions were like
1. I was asked to introduce myself.
2. What is Object Oriented language and its principles.
3. What is RDBMS.
4. Encapsulation?
5. Difference b/w java n C++.
6. Does inheritance exploits the concept of encapsulation.
7. Why Java is so popular?
8. What is Normalization and why do we use it.
9. what is 3 tier architecture.
10. What is overloading.
11. How do we implement polymorphism in java.
12. Give example, where do we need to normalize the table.
13. Any Questions ?

I was given two puzzles to solve...
1. 9 balls are given to me of 1 kg each except 1, which is of 2kg. I have to find out the 2kg ball in minimum no. of weighing. Solution is given shakunla devi. Ans 2 weighing
2. Man n his dog has to cover distance of 6km. Speed of man is 4km/hr n that of dog is 6km/hr. how much distance dog would have travelled, if the dogs comes back to the man after reaching the end point, keeps on repeating the same until man n dog reach the destination point. Ans man covers 6kms n dog covers 9kms.