Search Jobs
Search Jobs

# Paper General - Other - 3 January 2004 by Keane

Details of Paper General - Other - 3 January 2004 by Keane conducted by Keane for job interview.
Share Us With Others

KEAN INDIA LTD., WRITTEN TEST PAPER HELD ON 3-01-2004>

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.

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)ell 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 ?