Placement Papers - Keane

KEANE PAPER & INTERVIEW - 03 JAN 2004 - HYDERABAD

KEAN INDIA LTD., Hyd, would be calling freshers for every 4 months or so. Hence the model of the paper I am sending would be useful to those who want to appear for it in future.
           
            KEAN INDIA LTD., WRITTEN TEST PAPER HELD ON 3-01-2004 AT KEAN SCHOOL OF EXCELLENCE, GACHIBOWLI, HYDERABAD.
           
            Qualifying mark: 50% marks in each section. (sometimes it is 60%)
           
            Paper consists of 3 sections. No separate timing for each section. You can divide it as and how u wish.
            section 1: Mathematical Ability & Aptitude---------30 marks
            section 2: Verbal and Comprehension-----------------25 marks
            section 3: Computer Basics & Logical reasoning---20 marks
           
            SECTION 1: Mathematical Ability & Aptitude-----30 marks
           
            Questions
           
            * Number systems like--
            How many numbers between 100 and 200 are odd, divisible by 3, but not by 7?
            Also on lcm, hcf, etc.
           
            *Time &work
            *Time&Distance
            *Races
            *Probablity
            *Areas and volumes, length of chord etc.
           
           
            SECTION 2: Verbal and Comprehension-----------------25 marks
           
            Analogies---5---5 marks
            Antonyms---5---5 marks
            Reading Comprehension----2 passages (big but easily understandable)--- 2*5=10 marks
            Arrange the sentences--------5 questions, 5 marks, each question is as follows.
            eg:
            P: Alas! she had only 30 rupees with her.
            Q: Bindu got late for the exam and she started in a hurry.
            R: She called an auto and he demanded 50 rupees..
            S: She blamed her hurry, as in hurry, she forgot to bring more money.
            T: She went to the busstop and there were no buses.
           
            The following is the exact order of sentences:
            a) PRSTQ b) QTRPS c) RSQPT d)QPRTS e)none of these
            Answer :b
           
            SECTION 3: Computer Basics & Logical reasoning---20 marks
           
            Computer Basics----very very easy------10 marks
            Logical Reasoning------ 10 arks, 10 questions, each question is like this.
            eg:
            P: All girls are Bindus.
            Q: Some Bindus are boys.
            R: All Bindus are boys.
            S: Some boys are not girls.
            T:All girls are boys.
            U:All boys are girls.
           
            The following sentences are logically related:
            a) UTQ b) PQS c) TSP d) RPS e) QSP
            Answer : b
           
There will be 4, 5 sets of question papers. So, each one will get a different question paper. The model of the paper itself seems tough(for me, atleast) and one would end up with no time. Hence, to get through this paper, TIME MANAGEMENT is the crucial factor. One needs to keep
            oneself cool too, while answering the paper.
           
INTERVIEW QUESTIONS
1) first personal
            2) asked about cobol,basic fundamentals
            3) about project (i have done vb,oracle) so that there were
            questions about sql,queries
            4) 2 questions on arithmatic like(2 trains starting in opposite
            direction one bird flying and so on...)
            5) 2 questions on management life if u are head of a school
            and there are no profits for ur school, then what will u do?
            6) last about family background ?
           
            1) c concepts,programs asked to write
            2) c++(virtual functions,static ,polymorphism)
            3) cobol divisions
            4) project questions(asp)
            5) data base questions
            6) some personal details and 3 puzzles like largest number
            with 6 numbers etc.
            7) about my ur self.
           
            1) project
            2) dead lock and prevention,detection methods
            3) page faults with example
            4) OSI reference model
            5) swaping with out using 3rd variable
            6) inorder, preorder, postorder(data structures traversals with example)
            7) some sql queries containing having, orderby, groupby and subqueries
            8) multi level threads, multi tasking difference
            9) query for count the employees departmentwise
            10) database types
            11) diff. b/w dbms and rdbms
            12) tcp/ip networking model
            13) diff. b/w ring topology and bus topology
            14) hr question : if u r officer incharge of hitech city like a plane
            crashes into wto towers a plane crashes into the hitech city
            then what r the measures taken by you to save the people inside
            the building ?
            15) diff b/w physical memory and logical memory ?
            16) query for converting one to many relation in to a one to one relation ?
            for this he was given his own table !
            17) binary search algorithm ?
           
            1) about my self
            2) about project
            3) computer networks- in which layer router is used
            4) stack program
            5) types of a database - explain them
            main stress on relational database.
            6) what is compaction.
            7) operating system.
           
            1) normalization
            2) data abstraction
            3) use of trees
            4) types of data base systems
            5) finding an element in hierarchical database
            6) sql queries
            7) operator overloading, overloading ---> difference
            8) polymorphism implementation
            9) tcp / ip
            10) osi/iso layers
            11) differences in tcp and iso
            12) functions of layers in tcp,iso
            13) relation between primary key,foreign key
           
            1) questions on my project
            2) what is ur favourite subject
            i answered 'neutral networks'
            3) what is ur favourite programming lang.
            my answer is 'c'
            4) they asked me to write a program for bubble sort ?
            5) wap to print pyramid of stars?
            6) program to check whether the given no is armstrong
            number or not?
            7) they asked one question on o.s.concepts ?
            8) a puzzle "there are three bulbs in a room and there
            r three switches outside the room........" ?
            9) another puzzle "there r 2 stations a and b of distance of 200km
            and two trains start from each station oppositely...."
            10) do u have any doubts ?
           
            1) referential integrity constraint
            2) different sql statements(dml,ddl,dcl) ?
            3) diff. b/w commit and rollback(save point) ?
            explain with example?
            4) primary key, foreign key ?
            5) write a query to get maximum salary from
            each dept with all details?
            6) paging ?
            7) segmentation ?
            8) what is OS ?
            9) cpu scheduling algorithms all explain ?
            10) network layers ?
            11) do we require all layers?
            ans : no (don't require presentation and session layer)
            12)a) diff. b/w javascript and vbscript ?
            ans : java script for client side and vbscript for server side
            b) can i use java script for server side scripting ?
            ans : yes
            13) hashing in datastructers
            14) in cobol
            do u know cobol ?(ans is no,not comfortable)
            15) what happens if u have tables with many to many relationships ?
            ans: redundancy ,anamolies etc will occur
           
            1) acadamic and family background ?
            2) favourite subjects in MCA curriculam ?
            i have selected SE,CPP,OS
            3) what is SDLC and explain phases ?
            4) what is requirement analysis and how it is?
            5) what are different types of testing techniques ?
            6) what is OS ?
            7) what are the functions of OS ?
            8) how cpu time is scheduled and what are the algorithm
            9) explain round robin algorithm ?
            10) what is deadlock situation ?
            11) how we can prevent deadlocks
            12) how a program can be run ?
            13) draw computer block diagram ?
            14) write a program to print as follows
            * * * *
            * * *
            * *
            *
            15) program to sort the array (any sorting technique
            ur wish)
            16) what is .obj file and when it will be generated?
            17) how .exe file will come into existance ?
            18) they the subject what i have in curriculum and
            asked randomly ?
            19) what is osi reference model ?
            20) explain layers in osi
            21) where the error will be caught while transmitting ?
            22) diff. b/w queues and stacks ?
            23) how linked list different from stacks and queues?
            24) how many sorting techniques are there
            25) what is a register,how it will be useful ?
           
            1) operating system - system calls,disk scheduling algorithms
            2) RDBMS - embedded sql,4-5 queries
            3) normalization
            4) write 2nd normalization form of a table
            5) s/w engg : reverse engg
            6) how you used s/e engg in ur project
            7) c: dynamic memory alloaction
            8) project details
           
            1) tell me about ur self
            2) what is ur opinion about hyderabad and which places u like ?
            3) normalization ?
            4) diff. b/w primary key and unique key
            ans: unique key accepts null value
            primary key dont accept any null value
            5) whether one null value is equal to another null value ?
            6) types of dbms ?
            7) constraints and their types ?
            8) query to retrive the ename start with A ?
            9) 200km dist,both trains started at speed 100km oppositely and one bird
            is starting with one train at 120 km then what is the distance travelled
            by bird if both the trains collide ? (ans: 120 km)
            10) if u litting a thread it will take one hour for complete buring
            of thread what do u do if i want to burn it in halfen hour ?
            11) three bulbs, three switches how to identify which switch is for which bulb?
            0
            12) how to prove A =1(a power zero is equal to one)
           
            1) tell me about ur self
            2) how will u store the data in oracle from vb form and how will u retrive
            data from oracle to vb ?
            3) what is referential integrity ?
            4) diff between primary key and unique ?
            5) what is foreign key ?
            6) display the employs those who r getting salary greater than
            average of all employees ?
            7) count the no of employees for question 6 ?
            8) display all the details of deptname and deptcode whose no of employees
            in a particular department is < 2 ?
            9) types of databases
            10) display each deptname and no of employees exist in that particular dept
            11) SDLC phases,what is the output of analysis ?
            12) types of testing,regression testing,integration testing ?
            13) what do u do in analysis phase ?
            14) how much % u got in ur mca ?
            15) why do u fail in dcf 1st sem of mca ?
            16) c program for sum of digits of a number ?
            17) c program for swaping numbers without using third variable ?
            18) 200km dist,both trains started at speed 100km oppositely and one bird
            is starting with one train at 120 km then what is the distance travelled
            by bird if both the trains collide ? (ans: 120 km)
            19) if u litting a thread it will take one hour for complete buring
            of thread what do u do if i want to burn it in halfen hour ?
            20) what do u call in oracle %,_ (wild characters)
           
            1) tell me about ur project ?
            2) dbms normalization,queries,referential integrity,constraints ?
            3) what is paging,virtual memory ?
            4) program to insert a node into linked list ?
            5) about trees and their uses ?
            6) microprocessors : 8085 (explain instrctutions)
           
            Data Structures
            1.what is meant by tree
            2.draw a binary tree
            write postorder,preorder,inorder for that tree
            3.complexties of sortings
            4.write aprogram for stack
            5.applications of stacks,tree
            6.something on linked list
           
            Operating System
            1.jobscheduling
            2.paging
            3.os services
            4.system calls
            5.file management

DBMS
            1.how mant primary keys can exist for a table
            2.define constraints one by one
            sql(nearly ten+ queries )
            1.subqueries
            2.joins
            3.select 2nd highest salary
            4.groupby,having,orderby rules with examples

CN
            1.osi model
            2.function of each layer
            3.protocol means tell some protocol
            4.ethernet

C Programing
            1.write a program for prime number checking
            2.write a program for quicksort
            3.explain quick sort with a example
            4.break,continue
           
            1)tell about ur self
            2)about project, favorite subs in mca
            3)diff b/w array,stack and queue
            4)normalisation
            5)cobol divisions
            6)what did u learn in mobile computing,sys adm,s/w reuse tech
            7)cobol format
            8)s/w eng phases
            9)write prog on factorial
            10)more questions on cobol
            11)page fault
            12)testing and types of testing
            13)primary key,foreign key
           
            1. what is ur project ?
            2. which algorithms used and why ? why don't choose other algorithms ?
            3. some basic questions on my project

Microprocessors
            4. do you know assembly lang(8085)? [i am btech ece]
            5. tell me basic structure of that lang ?
            6. can you explain JNC,JZ commands ?
            7. what do u know mean cisc and risc and what is the diff b/w them ?
            8. do you know the functions of risc ?
            digital electronics
            9. what do you mean by switching ?
            10. can you write the truth table of NAND and NOR gates ?
            11. can you tell about logic families ?
           
            1. introduction to c
            2. pointers in c
            3. swap two numbers without using temparory variable
            4. what is object based lang ?
            5. what is object oriented lang ?
            6. what is normalization(1nf,2nf,3nf) ?
            7. DataBase models
            8. prove a power zero is equal to one ?
            9. integrity constraints
            10. what is diff. b/w inline functions and macros ?