Fresher Interview Preparation Material

Computer Networks Interview Questions and Answers

2009-06-30T23:35:00.000-07:00

1. What are 10Base2, 10Base5 and 10BaseT Ethernet LANs
10Base2—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling, with a contiguous cable segment length of 100
meters and a maximum of 2 segments.
10Base5—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling, with 5 continuous segments not exceeding 100
meters per segment.
10BaseT—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling and twisted pair cabling.

2. What is the difference between an unspecified passive open and a fully specified passive open
An unspecified passive open has the server waiting for a connection request from a client. A fully specified passive open has the server waiting for a connection from a
specific client.

3. Explain the function of Transmission Control Block
A TCB is a complex data structure that contains a considerable amount of information about each connection.

4. What is a Management Information Base (MIB)
A Management Information Base is part of every SNMP-managed device. Each SNMP agent has the MIB database that contains information about the device's status, its
performance, connections, and configuration. The MIB is queried by SNMP.

5. What is anonymous FTP and why would you use it
Anonymous FTP enables users to connect to a host without using a valid login and password. Usually, anonymous FTP uses a login called anonymous or guest, with the
password usually requesting the user's ID for tracking purposes only. Anonymous FTP is used to enable a large number of users to access files on the host without having
to go to the trouble of setting up logins for them all. Anonymous FTP systems usually have strict controls over the areas an anonymous user can access.

6. What is a pseudo tty A pseudo tty or false terminal enables external machines to connect through Telnet or rlogin. Without a pseudo tty, no connection can take place.

7. What is REX
What advantage does REX offer other similar utilities

8. What does the Mount protocol do
The Mount protocol returns a file handle and the name of the file system in which a requested file resides. The message is sent to the client from the server after reception of a client's request.

9. What is External Data Representation
External Data Representation is a method of encoding data within an RPC message, used to ensure that the data is not system-dependent.

10. What is the Network Time Protocol ?

11. BOOTP helps a diskless workstation boot. How does it get a message to the network looking
for its IP address and the location of its operating system boot files BOOTP sends a UDP message with a subnetwork broadcast address and waits for a reply from a server that gives it the IP address. The same message might contain the name of the machine that has the boot files on it. If the boot image location is not specified, the workstation sends another UDP message to query the server.

12. What is a DNS resource record
A resource record is an entry in a name server's database. There are several types of resource records used, including name-to-address resolution information. Resource
records are maintained as ASCII files.

13. What protocol is used by DNS name servers
DNS uses UDP for communication between servers. It is a better choice than TCP because of the improved speed a connectionless protocol offers. Of course,
transmission reliability suffers with UDP.
14. What is the difference between interior and exterior neighbor gateways
Interior gateways connect LANs of one organization, whereas exterior gateways connect the organization to the outside world.

15. What is the HELLO protocol used for
The HELLO protocol uses time instead of distance to determine optimal routing. It is an alternative to the Routing
Information Protocol.

16. What are the advantages and disadvantages of the three types of routing tables
The three types of routing tables are fixed, dynamic, and fixed central. The fixed table must be manually modified every time there is a change. A dynamic table changes its
information based on network traffic, reducing the amount of manual maintenance. A fixed central table lets a manager modify only one table, which is then read by other
devices. The fixed central table reduces the need to update each machine's table, as with the fixed table. Usually a dynamic table causes the fewest problems for a network
administrator, although the table's contents can change without the administrator being aware of the change.

17. What is a TCP connection table
18. What is source route
It is a sequence of IP addresses identifying the route a datagram must follow. A source route may optionally be included in an IP datagram header.

19. What is RIP (Routing Information Protocol)
It is a simple protocol used to exchange information between the routers.

20. What is SLIP (Serial Line Interface Protocol)
It is a very simple protocol used for transmission of IP datagrams across a serial line.

21. What is Proxy ARP
It is using a router to answer ARP requests. This will be done when the originating host believes that a destination is local, when in fact is lies beyond router.
22. What is OSPF
It is an Internet routing protocol that scales well, can route traffic along multiple paths, and uses knowledge of an Internet's topology to make accurate routing decisions.

23. What is Kerberos
It is an authentication service developed at the Massachusetts Institute of Technology. Kerberos uses encryption to prevent intruders from discovering passwords and gaining unauthorized access to files.
24. What is a Multi-homed Host
It is a host that has a multiple network interfaces and that requires m ultiple IP addresses is called as a Multi-homed Host.

25. What is NVT (Network Virtual Terminal)
It is a set of rules defining a very simple virtual terminal interaction. The NVT is used in the start of a Telnet session.
26. What is Gateway-to-Gateway protocol
It is a protocol formerly used to exchange routing information between Internet core routers.

27. What is BGP (Border Gateway Protocol)
It is a protocol used to advertise the set of networks that can be reached with in an autonomous system. BGP enables this information to be shared with the autonomous
system. This is newer than EGP (Exterior Gateway Protocol).

28. What is autonomous system
It is a collection of routers under the control of a single administrative authority and that uses a common Interior Gateway Protocol.

29. What is EGP (Exterior Gateway Protocol)
It is the protocol the routers in neighboring autonomous systems use to identify the set of networks that can be reached
within or via each autonomous system.
Computer Networks Interview Questions
30. What is IGP (Interior Gateway Protocol)
It is any routing protocol used within an autonomous system.
31. What is Mail Gateway
It is a system that performs a protocol translation between different electronic mail delivery protocols.
32. What is wide-mouth frog
Wide-mouth frog is the simplest known key distribution center (KDC) authentication protocol.
33. What are Digrams and Trigrams
The most common two letter combinations are called as digrams. e.g. th, in, er, re and an. The most common three letter combinations are called as trigrams. e.g. the, ing,
and, and ion.
34. What is silly window syndrome
It is a problem that can ruin TCP performance. This problem occurs when data are passed to the sending TCP entity in large blocks, but an interactive application on the
receiving side reads 1 byte at a time.
35. What is region
When hierarchical routing is used, the routers are divided into what we call regions, with each router knowing all the details about how to route packets to destinations
within its own region, but knowing nothing about the internal structure of other regions.
36. What is multicast routing
Sending a message to a group is called multicasting, and its routing algorithm is called multicast routing.
37. What is traffic shaping
One of the main causes of congestion is that traffic is often busy. If hosts could be made to transmit at a uniform rate,
congestion would be less common. Another open loop
method to help manage congestion is forcing the packet to be transmitted at a more predictable rate. This is called
traffic shaping.
38. What is packet filter
Packet filter is a standard router equipped with some extra functionality. The extra functionality allows every incoming or
outgoing packet to be inspected. Packets meeting
some criterion are forwarded normally. Those that fail the test are dropped.
39. What is virtual path
Along any transmission path from a given source to a given destination, a group of virtual circuits can be grouped
together into what is called path.
Computer Networks Interview Questions
40. What is virtual channel
Virtual channel is normally a connection from one source to one destination, although multicast connections are also
permitted. The other name for virtual channel is virtual
circuit.
41. What is logical link control
One of two sublayers of the data link layer of OSI reference model, as defined by the IEEE 802 standard. This sublayer
is responsible for maintaining the link between
computers when they are sending data across the physical network connection.
42. Why should you care about the OSI Reference Model
It provides a framework for discussing network operations and design.
43. What is the difference between routable and non- routable protocols
Routable protocols can work with a router and can be used to build large networks. Non-Routable protocols are
designed to work on small, local networks and cannot be
used with a router
44. What is MAU
In token Ring , hub is called Multistation Access Unit(MAU).
45. Explain 5-4-3 rule
In a Ethernet network, between any two points on the network, there can be no more than five network segments or four
repeaters, and of those five segments only three of
segments can be populated.
46. What is the difference between TFTP and FTP application layer protocols
The Trivial File Transfer Protocol (TFTP) allows a local host to obtain files from a remote host but does not provide
reliability or security. It uses the fundamental packet
delivery services offered by UDP.
The File Transfer Protocol (FTP) is the standard mechanism provided by TCP / IP for copying a file from one host to
another. It uses the services offered by TCP and so is
reliable and secure. It establishes two connections (virtual circuits) between the hosts, one for data transfer and another
for control information.
47. What is the range of addresses in the classes of internet addresses
Class A 0.0.0.0 - 127.255.255.255
Class B 128.0.0.0 - 191.255.255.255
Class C 192.0.0.0 - 223.255.255.255
Class D 224.0.0.0 - 239.255.255.255
Class E 240.0.0.0 - 247.255.255.255
48. What is the minimum and maximum length of the header in the TCP segment and IP datagram
The header should have a minimum length of 20 bytes and can have a maximum length of 60 bytes.
Computer Networks Interview Questions
49. What is difference between ARP and RARP
The address resolution protocol (ARP) is used to associate the 32 bit IP address with the 48 bit physical address, used
by a host or a router to find the physical address of
another host on its network by sending a ARP query packet that includes the IP address of the receiver.
The reverse address resolution protocol (RARP) allows a host to discover its Internet address when it knows only its
physical address.
50. What is ICMP
ICMP is Internet Control Message Protocol, a network layer protocol of the TCP/IP suite used by hosts and gateways to
send notification of datagram problems back to the
sender. It uses the echo test / reply to test whether a destination is reachable and responding. It also handles both
control and error messages.
51. What are the data units at different layers of the TCP / IP protocol suite
The data unit created at the application layer is called a message, at the transport layer the data unit created is called
either a segment or an user datagram, at the network
layer the data unit created is called the datagram, at the data link layer the datagram is encapsulated in to a frame and
finally transmitted as signals along the transmission
media.
52. What is Project 802
It is a project started by IEEE to set standards that enable intercommunication between equipment from a variety of
manufacturers. It is a way for specifying functions of the
physical layer, the data link layer and to some extent the network layer to allow for interconnectivity of major LAN
protocols.
It consists of the following:
802.1 is an internetworking standard for compatibility of different LANs and MANs across protocols.
802.2 Logical link control (LLC) is the upper sublayer of the data link layer which is non-architecture-specific, that is
remains the same for all IEEE-defined LANs.
Media access control (MAC) is the lower sublayer of the data link layer that contains some distinct modules each
carrying proprietary information specific to the LAN product
being used. The modules are Ethernet LAN (802.3), Token ring LAN (802.4), Token bus LAN (802.5).
802.6 is distributed queue dual bus (DQDB) designed to be used in MANs.
53. What is Bandwidth
Every line has an upper limit and a lower limit on the frequency of signals it can carry. This limited range is called the
bandwidth.
54. Difference between bit rate and baud rate.
Bit rate is the number of bits transmitted during one second whereas baud rate refers to the number of signal units per
second that are required to represent
those bits.
baud rate = bit rate / N
where N is no-of-bits represented by each signal shift.
55. What is MAC address
Computer Networks Interview Questions
The address for a device as it is identified at the Media Access Control (MAC) layer in the network architecture. MAC
address is usually stored in ROM on the network
adapter card and is unique.
56. What is attenuation
The degeneration of a signal over distance on a network cable is called attenuation.
57. What is cladding
A layer of a glass surrounding the center fiber of glass inside a fiber-optic cable.
58. What is RAID
A method for providing fault tolerance by using multiple hard disk drives.
59. What is NETBIOS and NETBEUI
NETBIOS is a programming interface that allows I/O requests to be sent to and received from a remote computer and it
hides the networking hardware from applications.
NETBEUI is NetBIOS extended user interface. A transport protocol designed by microsoft and IBM for the use on small
subnets.
60. What is redirector
Redirector is software that intercepts file or prints I/O requests and translates them into network requests. This comes
under presentation layer.
61. What is Beaconing
The process that allows a network to self-repair networks problems. The stations on the network notify the other
stations on the ring when they are not receiving the
transmissions. Beaconing is used in Token ring and FDDI networks.
62. What is terminal emulation, in which layer it comes
Telnet is also called as terminal emulation. It belongs to application layer.
63. What is frame relay, in which layer it comes
Frame relay is a packet switching technology. It will operate in the data link layer.
64. What do you meant by "triple X" in Networks
The function of PAD (Packet Assembler Disassembler) is described in a document known as X.3. The standard protocol
has been defined between the terminal and the
PAD, called X.28; another standard protocol exists between hte PAD and the network, called X.29. Together, these
three recommendations are often called "triple X"
65. What is SAP
Series of interface points that allow other computers to communicate with the other layers of network protocol stack.
Computer Networks Interview Questions
66. What is subnet
A generic term for section of a large networks usually separated by a bridge or router.
67. What is Brouter
Hybrid devices that combine the features of both bridges and routers.
68. How Gateway is different from Routers
A gateway operates at the upper levels of the OSI model and translates information between two completely different
network architectures or data formats.
69. What are the different type of networking / internetworking devices
Repeater:
Also called a regenerator, it is an electronic device that operates only at physical layer. It receives the signal in the
network before it becomes weak, regenerates the original
bit pattern and puts the refreshed copy back in to the link.
Bridges:
These operate both in the physical and data link layers of LANs of same type. They divide a larger network in to smaller
segments. They contain logic that allow them to
keep the traffic for each segment separate and thus are repeaters that relay a frame only the side of the segment
containing the intended recipent and control congestion.
Routers:
They relay packets among multiple interconnected networks (i.e. LANs of different type). They operate in the physical,
data link and network layers. They contain software
that enable them to determine which of the several possible paths is the best for a particular transmission.
Gateways:
They relay packets among networks that have different protocols (e.g. between a LAN and a WAN). They accept a
packet formatted for one protocol and convert it to a
packet formatted for another protocol before forwarding it. They operate in all seven layers of the OSI model.
70. What is mesh network
A network in which there are multiple network links between computers to provide multiple paths for data to travel.
71. What is passive topology
When the computers on the network simply listen and receive the signal, they are referred to as passive because they
don’t amplify the signal in any way. Example for
passive topology - linear bus.
72. What are the important topologies for networks
BUS topology:
In this each computer is directly connected to primary network cable in a single line.
Advantages:
Inexpensive, easy to install, simple to understand, easy to extend.
STAR topology:
In this all computers are connected using a central hub.
Advantages:
Computer Networks Interview Questions
Can be inexpensive, easy to install and reconfigure and easy to trouble shoot physical problems.
RING topology:
In this all computers are connected in loop.
Advantages:
All computers have equal access to network media, installation can be simple, and signal does not degrade as much as
in other topologies because each computer
regenerates it.
73. What are major types of networks and explain
Server-based network
Peer-to-peer network
Peer-to-peer network, computers can act as both servers sharing resources and as clients using the resources.
Server-based networks provide centralized control of network resources and rely on server computers to provide
security and network administration
74. What is Protocol Data Unit
The data unit in the LLC level is called the protocol data unit (PDU). The PDU contains of four fields a destination
service access point (DSAP), a source service access
point (SSAP), a control field and an information field. DSAP, SSAP are addresses used by the LLC to identify the
protocol stacks on the receiving and sending machines
that are generating and using the data. The control field specifies whether the PDU frame is a information frame (I -
frame) or a supervisory frame (S - frame) or a
unnumbered frame (U - frame).
75. What is difference between baseband and broadband transmission
In a baseband transmission, the entire bandwidth of the cable is consumed by a single signal. In broadband
transmission, signals are sent on multiple frequencies, allowing
multiple signals to be sent simultaneously.
76. What are the possible ways of data exchange
(i) Simplex (ii) Half-duplex (iii) Full-duplex.
77. What are the types of Transmission media
Signals are usually transmitted over some transmission media that are broadly classified in to two categories.
Guided Media:
These are those that provide a conduit from one device to another that include twisted-pair, coaxial cable and fiber-optic
cable. A signal traveling along any of these media
is directed and is contained by the physical limits of the medium. Twisted-pair and coaxial cable use metallic that accept
and transport signals in the form of electrical
current. Optical fiber is a glass or plastic cable that accepts and transports signals in the form of light.
Unguided Media:
This is the wireless media that transport electromagnetic waves without using a physical conductor. Signals are
broadcast either through air. This is done through radio
communication, satellite communication and cellular telephony.
78. What is point-to-point protocol
Computer Networks Interview Questions
A communications protocol used to connect computers to remote networking services including Internet service
providers.
79. What are the two types of transmission technology available
(i) Broadcast and (ii) point-to-point
80. Difference between the communication and transmission.
Transmission is a physical movement of information and concern issues like bit polarity, synchronization, clock etc.
Communication means the meaning full exchange of information between two communication media.

Most common Interview Questions on all topics

2009-06-29T23:30:00.000-07:00

HR Questions (Most commonly asked Interview Questions)
1. Tell me about you!
Keep your answer to one or two minutes; don't ramble. Stick to what you've
written in your resume summary. To answer this question well, you'll need
to start with a solid and concise resume summary.
2. What do you know about our company?
Do your homework before the interview! Spend some time online or at the
library researching the company. Find out as much as you can, including
products, size, income, reputation, image, management talent, people,
skills, history and philosophy. Project an informed interest; let the
interviewer tell you about the company.
3. Why do you want to work for us?
Don't talk about what you want; first, talk about their needs: You would like
to be part of a specific company project; you would like to solve a company
problem; you can make a definite contribution to specific company goals.
4. What would you do for us?
What they really want to know is... What can you do for us that someone
else can't? Relate past experiences that show you've had success in
solving previous employer problem(s) that may be similar to those of the
prospective employer. Make sure you have a strongly worded Employment
History section in your resume, that you can refer to.
5. What about the job offered do you find the most attractive? Least
attractive?
List three or more attractive factors and only one minor unattractive factor.
6. Why should we hire you?
Because of your knowledge, experience, abilities and skills.
7. What do you look for in a job?
An opportunity to use your skills, to perform and be recognized.
8. Please give me your definition of a.... (the position for which you are
being interviewed).
Keep it brief -- give an action- and results-oriented definition.
9. How long would it take you to make a meaningful contribution to our
firm?
Not long at all -- you expect only a brief period of adjustment to the
learning curve.
10. How long would you stay with us?
As long as we both feel I'm contributing, achieving, growing, etc.
Warm-Up Questions
1. What made you apply for this position?
2. How did you hear about this job opening?
3. Briefly, would you summarize your work history & education for me?
Work History
1. What special aspects of your work experience have prepared you for
this job?
2. Can you describe for me one or two of your most important
accomplishments?
3. How much supervision have you typically received in your previous
job?
4. Describe for me one or two of the biggest disappointments in your
work history?
5. Why are you leaving your present job? (or, Why did you leave your
last job?)
6. What is important to you in a company? What things do you look for
in an organization?
Job Peformance
1. Everyone has strengths & weaknesses as workers. What are your
strong points for this job?
2. What would you say are areas needing improvement?
3. How did your supervisor on your most recent job evaluate your job
performance? What were some of the good points & bad points of
that rating?
4. When you have been told , or discovered for yourself , a problem in
your job performance, what have you typically done? Can you give
me an example?
5. Do you prefer working alone or in groups?
6. What kind of people do you find it most difficult to work with? Why?
7. Starting with your last job, tell me about any of your achievements
that were recognized by your superiors.
8. Can you give me an example of your ability to manage or supervise
others?
9. What are some things you would like to avoid in a job? Why?
10. In your previous job what kind of pressures did you encounter?
11. What would you say is the most important thing you are looking for
in a job?
12. What are some of the things on your job you feel you have done
particularly well or in which you have achieved the greatest
success? Why do you feel this way?
13. What were some of the things about your last job that you found
most difficult to do?
14. What are some of the problems you encounter in doing your job?
Which one frustrates you the most? What do you usually do about
it?
15. What are some things you particularly liked about your last job?
16. Do you consider your progress on the job representative of your
ability? Why?
17. How do you feel about the way you & others in the department were
managed by your supervisor?
18. If I were to ask your present (most recent) employer about your
ability as a____________________, what would he/she say?
EDUCATION
1. What special aspects of your education or training have prepared
you for this job?
2. What courses in school have been of most help in doing your job?
CAREER- GOALS
1. What is your long-term employment or career objective?
2. What kind of job do you see yourself holding five years from now?
3. What do you feel you need to develop in terms of skill & knowledge
in order to be ready for that opportunity?
4. Why might you be successful in such a job?
5. How does this job fit in with your overall career goals?
6. Who or what in your life would you say influenced you most with
your career objectives?
7. Can you pinpoint any specific things in your past experience that
affected your present career objectives?
8. What would you most like to accomplish if you had this job?
9. What might make you leave this job?
SELF-ASSESSMENT
1. What kind of things do you feel most confident in doing?
2. Can you describe for me a difficult obstacle you have had to
overcome? How did you handle it? How do you feel this experience
affected your personality or ability?
3. How would you describe yourself as a person?
4. What do you think are the most important characteristics & abilities a
person must possess to become a successful ( )? How do you rate
yourself in these areas?
5. Do you consider yourself a self-starter? If so, explain why ( and give
examples)
6. What do you consider to be your greatest achievements to date?
Why?
7. What things give you the greatest satisfaction at work?
8. What things frustrate you the most? How do you usually cope with
them?
CREATIVITY
1. In your work experience, what have you done that you consider truly
creative?
2. Can you think of a problem you have encountered when the old
solutions didn't work & when you came up with new solutions?
3. Of your creative accomplishments big or small , at work or home,
what gave you the most satisfaction?
4. What kind of problems have people recently called on you to solve?
Tell me what you have devised.
DECISIVENESS
1. Do you consider yourself to be thoughtful, analytical or do you
usually make up your mind fast? Give an example. (Watch time taken
to respond)
2. What was your most difficult decision in the last six months? What
made it difficult?
3. The last time you did not know what decision to make, what did you
do?
4. How do you go about making an important decision affecting your
career?
5. What was the last major problem that you were confronted with?
What action did you take on it?
RANGE OF INTERESTS
1. What organizations do you belong to?
2. Tell me specifically what you do in the civic activities in which you
participate. (Leading questions in selected areas. i.e. sports,
economics, current events, finance.)
3. How do you keep up with what's going on in your company / your
industry/ your profession?
MOTIVATION
1. What is your professional goal?
2. Can you give me examples of experience on the job that you felt
were satisfying?
3. Do you have a long & short-term plan for your department? Is it
realistic?
4. Did you achieve it last year?
5. Describe how you determine what constitutes top priorities in the
performance of your job.
WORK STANDARDS
1. What are your standards of success in your job?
2. In your position, how would you define doing a good job? On what
basis was your definition determined?
3. When judging the performance of your subordinate, what factors or
characteristics are most important to you?
LEADERSHIP
1. In your present job what approach do you take to get your people
together to establish a common approach to a problem?
2. What approach do you take in getting your people to accept your
ideas or department goals?
3. What specifically do you do to set an example for your employees?
4. How frequently do you meet with your immediate subordinates as a
group?
5. What sort of leader do your people feel you are? Are you satisfied?
6. How do you get people who do not want to work together to
establish a common approach to a problem?
7. If you do not have much time & they hold seriously differing views,
what would be your approach?
8. How would you describe your basic leadership style? Give specific
examples of how you practice this?
9. Do you feel you work more effectively on a one to one basis or in a
group situation?
10. Have you ever led a task force or committee or any group who
doesn't report to you, but from whom you have to get work? How did
you do it? What were the satisfactions & disappointments? How
would you handle the job differently?
ORAL PRESENTATION SKILLS
1. Have you ever done any public or group speaking? Recently? Why?
How did it go?
2. Have you made any individual presentations recently? How did you
prepare?
WRITTEN COMMUNICATION SKILLS
1. Would you rather write a report or give a verbal report? Why?
2. What kind of writing have you done? For a group? For an individual?
3. What is the extent of your participation in major reports that have to
be written?
FLEXIBILITY
1. What was the most important idea or suggestion you received
recently from your employees? What happened as a result?
2. What do you think about the continuous changes in company
operating policies & procedures?
3. How effective has your company been in adapting its policies to fit a
changing environment?
4. What was the most significant change made in your company in the
last six months which directly affected you, & how successfully do
you think you implemented this change?
STRESS TOLERANCE
1. Do you feel pressure in your job? Tell me about it.
2. What has been the highest pressure situation you have been under
in recent years? How did you cope with it?
STABILITY & MATURITY
1. Describe your most significant success & failure in the last two
years.
2. What do you like to do best?
3. What do you like to do least?
4. What in your last review did your supervisor suggest needed
improvement?
5. What have you done about it?
INTEREST IN SELF DEVELOPMENT
1. What has been the most important person or event in your own self
development?
2. How much of your education did you earn?
3. What kind of books & other publications do you read?
4. Have you taken a management development course?
5. How are you helping your subordinates develop themselves?
TESTING GENERAL
1. What is workadround ?
2. What is a show stopper?
3. What is Traceability Matrix? Who prepares this document?
4. What is testlog document in testing process?
5. What is the Entry And Exit Criteria of a test plan? 2.How to Automate
your test plan?
6. What is the role of QA in a company that produces software?
7. What is terminologe? Why testing necessary? Fundamental test process
psychology of testing
8. What are the common bugs encountered while testing an application
manually or using test?
9. What are the bug and testing metrics?
10. For a bug with high severity can we give the priority also to be high...If
so why we need both?
11. How would you differentiaite between Bug, Defect, Failure, Error.
12. What is the difference between Client Server Testing and Web Testing?
13. What is backward compatibility testing ?
14. What certifications are available in testing?
15. What is release candidate?
16. What do you think the role of test-group manager should be?
17. What is a test data? Give examples
18. What is the difference between QA, QC and testing?
19. What is seviarity & priority? What is test format? Test procedure?
20. What are the different is manual database checking types?
WEB TESTING
1. What is the difference between testing in client-server applications and
web based applications?
2. Without using GUI map editor, Can we recognise the application in
Winrunner?
3. What command is used to launch a application in Winrunner?
4. What is the difference in testing a CLIENT-SERVER application and a
WEB application ?
6. What bugs are mainly come in Web Testing? What severity and priority
we are giving?
WHITE BOX TESTING
1. What are the table contents in test plans and test cases?
2. What are the tables in test plans and test cases?
WIRELESS TESTING
1. What is Wireless Testing? How do we do it? What are the concepts a test
engineer should have knowledge of? How do you classify testing of
wireless products?
TEST CASES
1. How will you prepare test cases?
2. Write the testcases on ATM Transactions?
3. What is meant by Hot Keys?
4. How is test case written?
5. How can we write a good test case?
6. How will you check that your test cases covered all the requirements
7. For a triangle (sum of two sides is greater than or equal to the third side),
what is the minimal number of test cases required.
TEST DIRECTOR
1. Difference between WEBINSPECT-QAINSPECT and WINRUNNER/TEST
DIRECTOR?
2. How will you generate the defect ID in test director? Is it generated
automatically or not?
3. Difference between TD 8.0 (Test director) and QC 8.0 (Quality Center).
4. How do you ensure that there are no duplication of bugs in Test
Director?
5. Difference between WinRunner and Test Director?
6. How will you integrated your automated scripts from TestDirector?
7. What is the use of Test Director software?
TESTING-SCENARIOS
1. How to find out the length of the edit box through WinRunner?
2. Is it compulsary that a tester should study a Design Document for writing
integration and system test casses
3. What is Testing Scenario? What is scenario based testing? Can you
explain with an example?
4. Lets say we have an GUI map and scripts, and we got some 5 new pages
included in an application, How do we do that?
5. How do you complete the testing when you have a time constraint?
6. Given an yahoo application how many test cases u can write?
7. GUI contains 2 fields. Field 1 to accept the value of x and Field 2 displays
the result of the formula a+b/c-d where a=0.4*x, b=1.5*a, c=x, d=2.5*b; How
many system test cases would you write
8. How do you know that all the scenarios for testing are covered?
TEST AUTOMATION
1. Give me an example where you have customized an automated test
script.
2. What steps have you followed while automating?
.......a) Running the test manually and ensuring a "pass".
.......b) Recording
.......c) Checkpoints/Verification
3. Can you automate Context-sensitive help? If so, how do you that?
4. What are the major differences between Stress testing, Load testing,
Volume testing?
5. What is the difference between quality assurance and testing?
6. What are the main attributes of test automation?
7. What is data - driven automation?
8. What is 'configuration management'?
9. What is memory leaks and buffer overflows?
10. Why does software have bugs?
11. How do you do usability testing, security testing, installation testing,
ADHOC, safety and smoke testing?
12. Describe some problem that you had with automating testing tool.
13. How do we test for severe memory leakages?
14. What are the problems encountered during the testing the application
compatibility on different browsers and on different operating systems
15. How will you evaluate the fields in the application under test using
automation tool?
16. How did you use automating testing tools in your job?
17. What skills needed to be a good test automator?
18. Can the activities of test case design be automated?
19. What types of scripting techniques for test automation do you know?
.What are scripting techniques? Could you describe the 5 techniques
mentioned?
20. What tools are available for support of testing during software
development life cycle?
SOFTWARE TESTING
1. What is the diffrence between Regression testing and Retesting?
2. What are the errors encountered while testing an application manually or
using automated tool like Testdirector, Winrunner?
3. What is Inspection, Review?
4. What is the actual different between re-testing and regressiontesting.
brefily explain
5. Explain Test Strategy
6. What is Tracebility Matrix ?
7. What are the major diff. between the Winrunner 6.0 and 7.0 (with internal
procedure)?
8. What test you perform mostly? Regression or retesting in your testing
process?
9. What did you do as a team leader?
10. How do we know about the build we are going to test? where do you
see this?
11. What is system testing and what are the different types of tests you
perform in system testing?
12. What is the difference between Return and treturn?
13. How do you test a weblink which is changing dynamically?
14. What are the flaws in water fall model and how to overcome it?
15. What is defect leakage?
16. Did you ever have to deal with someone who doesn't believe in testing?
What did u do?
17. How will you write test cases for a code currently under development?
18. Describe the last project scenario and generate test cases for it?
19. If there are a lot of bugs to be fixed, which one would you resolve first
20. How will you test a stapler?
QA TESTING
1. If the actual result doesn't match with expected result in this situation
what should we do?
2. What is the importance of requirements traceability in a product testing?
3. When is the best time for system testing?
4. What is use case? What is the diffrence between test cases and use
cases?
5. What is the difference between the test case and a test script
6. Describe to the basic elements you put in a defect report?
7. How do you test if you have minimal or no documentation about the
product?
8. How do you decide when you have tested enough?
9. How do you determine what to test?
10. In general, how do you see automation fitting into the overall process of
testing?
11. How do you deal with environments that are hostile to quality change
efforts?
12. Describe to me the Software Development Life Cycle as you would
define it?
13. Describe to me when you would consider employing a failure mode and
defect analysis?
14. What is the role of QA in a company that produces software?
15. How do you scope, organize, and execute a test project?
16. How can you test the white page
17. What is the role of QA in a project developement?
18. How you used whitebox and block box technologies in your
application?
19. 1) What are the demerits of winrunner?2) We write the test data after
what are the principles to do testing an application?
20. What is the job of Quality Assurance Engineer? Difference between the
Testing & Quality Assurance job.
WINRUNNER INTERVIEW QUESTIONS
1.. How to recognise the objects during runtime in new build version (test
suite) comparing with old guimap?
2. wait(20) - What is the minimum and maximum time the above mentioned
synchronization statements will wait given that the global default timeout is
set to 15 seconds.
3. Where in the user-defined function library should a new error code be
defined?
4. In a modular test tree, each test will receive the values for the parameters
passed from the main test. These parameters are defined in the Test
properties dialog box of each test.Refering to the above, in which one of
the following files are changes made in the test properties dialog saved?
5. What is the scripting process in Winrunner?
6. How many scripts can we generate for one project?
7. What is the command in Winrunner to invoke IE Browser? And once I
open the IE browser is there a unique way to identify that browser?
8. How do you load default comments into your new script like IDE's?
9. What is the new feature add in QTP 8.0 compare in QTP 6.0
10. When will you go to automation?
11. How to test the stored procedure?
12. How to recognise the objects during runtime in new build version (test
suite) comparing with old guimap
13. what is use of GUI files in winrunner.
14. Without using the datadriven test, how can we test the application with
different set of inputs?
15. How do you load compiled module inside a comiled module?
16. Can you tell me the bug life cycle
17. How to find the length of the edit box through WinRunner?
18. What is file type of WinRunner test files, its extension?
19. What is candidate release?
20. What type of variables can be used with in the TSL function?
RATIONAL ROBOT
1. In which directory are the .sbl files stored?
2. What SQABasic commands have you used?
3. Difference between SQAgetpropertyArray and SQAGetPropertyAsString?
4. What do .sbl and .sbh represent?
5. Is there any Load testing tool called Rational Site Load tool?
6. What is the difference between rational robot and QTP or Winrunner?
Which is more ueful of the three?
7. What is the difference between Rational Robot (Rational Functional
Tester) and IBM functional tester? which is better?
QTP
1. How can I add an action (external action) programmatically?
2. How can I call an external action, which is not added external action of
an action.
3. What is meant by Source Control?
4. How and what kind of VB functions do u use in QTP?
5. How can u describe the basic flow of automation with conditional and
programmatic logic?
6. How can I implement error handling in QTP,
7. How to recall a function in QTP
8. Give one example where you have used Regular Expression?
9. How can I implement error handling in QTP?
10. How to select particular value from the combo box in the current page
which is entered in the previous page edit box after parameterization?
11. If you have the same application screen with 7 drop down boxes and
approximately 70 values how do you test with QTP?
12. When there is a task that gets repeated in multiple scripts, what do you
do in QTP?
13. What is the descriptive programming?
14. What is the use of descriptive programming?
15. How to instruct QTP to display errors and other description in the test
results instead of halting execution by throwing error in the mid of
execution due to an error (for example Object not found)?
16. How you write scripts in QTP? What's the main process in QTP? How
do you run scripts in QTP? Please anyone can answer my questions.......
17. What is descriptive programming?
18. How to add run-time parameter to a datasheet?
19. How to load the *.vbs or test generating script in a new machine?
20. How can you write a script without using a GUI in QTP?
LOADRUNNER
1. What is load testing? Can we test J2ME application with load runner ?
What is Performance testing?
2. Which protocol has to be selected for record/playback Oracle 9i
application?
3. What are the enhancements which have been included in loadrunner 8.0
when compared to loadrunner 6.2?
4. Can we use Load Runner for testing desktop applications or non web
based applications and how do we use it.?
5. How to call winrunner script in Loadrunner?
6. What arr the types of parameterisation in load runner? List the step to do
strees testing?
7. What are the steps for doing load and performance testing using Load
Runner?
8. What is concurrent load and corollation? What is the process of load
runner?
9. What is planning for the test?
10. What enables the controller and the host to communicate with each
other in Load Runner?
11. Where is Load testing usually done?
12. What are the only means of measuring performance?
13. Testing requirement and design are not part of what?
14. According to Market analysis 70% of performance problem lies with
what?
15. What is the level of system loading expected to occur during specific
business scenario?
16. What is run-time-setting.
17. When load runner is used .
18. What protocols does LoadRunner support?
19. What do you mean by creating vuser script.?
20. What is rendezvous point?
LOAD TESTING
1. What are the uses of load testing ? What is defered graphs? What are the
different components in loadrunner?
2. How you analyze graphics in loadrunner? How do you work bug log?
3. How can data caching have a negative effect on load testing results?
4. What criteria would you use to select Web transactions for load testing?
5. For what purpose are virtual users created?
6. What is the difference between Load testing and Performace Testing?
7. Why do you need to parameterize fields in your virtual user script?
8. What are the reasons why parameterization is necessary when load
testing the Web server and the database server?
9. Why it is recommended to add verification checks to your all your
scenarios?
10. Load Testing - What should be analyzed.
11. In what situation would you want to parameterize a text verification
check?
12. What usually indicates that your virtual user script has dynamic data
that is dependent on you parameterized fields?
13. What are the benefits of creating multiple actions within any virtual user
script?
DATABASE TESTING
1. What SQL statements have you used in Database Testing?
2. How to test data loading in Database testing
3. What is way of writing testcases for database testing?
4. What is Database testing?
5. What we normally check for in the Database Testing?
6. How to Test database Manually? Explain with an example
COMMON INTERVIEW QUESTIONS
1. What Technical Environments have you worked with?
2. Have you ever converted Test Scenarios into Test Cases?
3. What is the ONE key element of 'test case'?
4. What is the ONE key element of a Test Plan?
5. What is SQA testing? tell us steps of SQA testing
6. How do you promote the concept of phase containment and defect
prevention?
7. Which Methodology you follow in your Testcase?
8. Specify the tools used by MNC companies
9. What are the test cases prepared by the testing team
10. During the start of the project how will the company come to an
conclusion that tool is required for testing or not?
11. Define Bug Life Cycle? What is Metrics
12. What is a Test procedure?
13. What is the difference between SYSTEM TESTING and END-TO-END
TESTING?
14. What is Traceability Matrix? Is there any interchangeable term for
Traceability Matrix ?Are Traceability Matrix and Test Matrix same or
Different ?
15. What is the differance between an exception and an error?
16. Correct bug tracking process - Reporting, Re-testing, Debigging, .....?
17. What is the difference between bug and defect?
18. How much time is/should be alloated for Testing out of total
Development time based on industry standards?
19. What are test bugs?
20. Define Quality - bug free, Functionality working or both?
COMMON QUESTIONS
1. If you have an application, but you do not have any requiremnts
available, then how would you perform the testing?
2. How can you know if a test case is necessary?
3. What is peer review in practical terms?
4. How do you know when you have enough test cases to adequately test a
software system or module?
5. Who approved your test cases?
6. What will you when you find a bug?
7. What test plans have you written?
8. What is QA? What is Testing? Are they both same or different?
9. How to write Negative Testcase? Give ex.
10. In an application currently in production, one module of code is being
modified. Is it necessary to re-test the whole application or is it enough to
just test functionality associated with that module?
11. What is included in test strategy? What is overall process of testing
step by step and what are various documnets used testing during process?
12. What is the most challenging situation you had during testing
13. What are you going to do if there is no Functional Spec or any
documents related to the system and developer who wrote the code does
not work in the company anymore, but you have system and need to test?
14. What is the major problem did you resolve during testing process
15. What are the types of functional testing?
16. 1. How will you write integration test cases 2. How will you track bugs
from winrunner. 3.How will you customise the bugs as pass/fail. 4. You find
a bug How will you repair 5. In testcases you have bug or not. 6. What is
use case ? what does it contains.
17. What is the difference between smoke testing and sanity testing
18. What is Random Testing?
19. What is smoke testing?
20. What is stage containment in testing?
BUG TRACKING
1. What is the difference between a Bug and a Defect?
2. How to post a BUG
3. How do we track a bug?plz send format of excel sheet in which we write
the bug details? How do we give the severithy and priority to the bugs?
4. What are the different types of Bugs we normally see in any of the
Project? Include the severity as well.
5. Top Ten Tips for Bug Tracking
DB2 INTERVIEW QUESTIONS
1. Can you display the index?
2. At what stage db2 must be up?
3. When do you use subroutines?
4. Initial position of cursor of the exucuton of open statements?
5. What is the index ,types of index ?
6. How many clustering indexes are pasing for a table?
7. When u will use curser with hold option?
8. File opening modes in cobol and corresponding dispositions?
9. What will happened .if the file is open in extend mode and
corresponding is equal to old in jcl?
10. How to know other person job status?
11. What will happened ,if the subprogram is called second time?
12. Can u see s9(4)comp3 data?
13. Commenly facing errors?
14. What is low values and high values?
15. How to enter in xpediter?
16. A dataset contains 1000 records ,I want to brouse particular record in
file-id?
17. There are two programs say A&B,A is only cobol program,B iscoboldb2
program, how to compile both programs?
18. How to pass return codes from Cobol to jcl?
19. In my jcl ,the 1st step is delete step, if the data set is existing, I want to
delete, that one ,if dataset is no existing, I do not want abend the job, how
can I code in disp?
20. What is diff b/w check pending and copy pending?
21. How to Repair the table?
22. How to see the status of the table?
23. How to load data to a table?
24. What is diff b/w QMF & Spoofi?
25. I have update Row in table using spoofi.how Revert that update Row it
means original position?
26. Quick Respendse and REspondce time in file-aid?
27. File contains 5 records say D,E,F,C,A-I want to copy D and A records
only by using file-aid?
28. What is severity one error in production support?
29. How to increase table space in db2?
30. What is the indexset and sequence set in vsam ksds?
31. How to read last record in vsam file.,I don't know how many records
are there?
32. I have 1000 records in vsam,I want to read records 500 to 900
33. Explain Reuse and upgrade
34. How do you read vsam file?
35. How can we over come the same situation when using flat file.
36. what r the compiler options we use?where the compiler option will
be?What is the need of compiler options?
37. Suppose there is cobol-db2 program.I made changes only in the cobol
program.Is there need recomile the DBRM again?why?
38. After bind i how can we run a cobol-db2 program?
39. By using any condition is there any way to abend a program.?If so
how?
40. What is the diff bet plan,package,dbrm?
41. After retrieving the elements from production,how can do the testing
before moving the changes to production. Whether we have to create the
JCL for testing or it will automatically tested and compiled?
42. What is a packed decimal..?
DATASTAGE INTERVIEW QUESTIONS
1. How do you rename all of the jobs to support your new File-naming
conventions?
2. Does the selection of 'Clear the table and Insert rows' in the ODBC stage
send a Truncate statement to the DB or does it do some kind of Delete
logic.
3. Tell me one situation from your last project, where you had faced
problem and How did u solve it?
4. The above might rise another question: Why do we have to load the
dimensional tables first, then fact tables:
5. How will you determine the sequence of jobs to load into data
warehouse?
6. What are the command line functions that import and export the DS
jobs?
7. What is the utility you use to schedule the jobs on a UNIX server other
than using Ascential Director?
8. How would call an external Java function which are not supported by
DataStage?
9. What will you in a situation where somebody wants to send you a file
and use that file as an input or reference and then run job.
10. Read the String functions in DS
11. How did u connect with DB2 in your last project?
12. What are Sequencers?
13. How did you handle an 'Aborted' sequencer?
14. What are other Performance tunings you have done in your last project
to increase the performance of slowly running jobs?
15. How did you handle reject data?
16. If worked with DS6.0 and latest versions what are Link-Partitioner and
Link-Collector used for?
17. What are Routines and where/how are they written and have you
written any routines before?
18. What are OConv () and Iconv () functions and where are they used?
19. How did u connect to DB2 in your last project?
20. Do u know about METASTAGE?
21. Do you know about INTEGRITY/QUALITY stage?
22. Explain the differences between Oracle8i/9i?
23. How good are you with your PL/SQL?
24. Did you work in UNIX environment?
25. What other ETL's you have worked with?
26. What versions of DS you worked with?
27. What is DS Designer used for - did u use it?
28. What is DS Administrator used for - did u use it?
29. What is DS Director used for - did u use it?
30. What is DS Manager used for - did u use it?
31. What are Static Hash files and Dynamic Hash files?
32. What is Hash file stage and what is it used for?
33. Have you ever involved in updating the DS versions like DS 5.X, if so
tell us some the steps you have taken in doing so?
34. Did you Parameterize the job or hard-coded the values in the jobs?
35. How do you merge two files in DS?
.NET INTERVIEW QUESTIONS
1. Explain the differences between Server-side and Client-side code?
2. What type of code (server or client) is found in a Code-Behind class?
3. Should validation (did the user enter a real date) occur server-side or
client-side? Why?
4. What does the "EnableViewState" property do? Why would I want it on or
off?
5. What is the difference between Servers? Transfer and Response.
Redirect? Why would I choose one over the other?
6.Can you give an example of when it would be appropriate to use a web
service as opposed to a non-serviced .NET component
7.Let's say I have an existing application written using Visual Studio 6 (VB
6, InterDev 6) and this application utilizes Windows 2000 COM+ transaction
services. How would you approach migrating this application to .NET
8.Can you explain the difference between an ADO.NET Dataset and an ADO
Recordset?
9. Can you give an example of what might be best suited to place in the
Application Start and Session Start subroutines?
10. If I'm developing an application that must accommodate multiple
security levels though secure login and my ASP.NET web application is
spanned across three web-servers (using round-robin load balancing) what
would be the best approach to maintain login-in state for the users?
JAVA INTERVIEW QUESTIONS
JAVA:-
1) What is static variable.
2) What is transient variable?
3) What is final variable.
4) What is final method.
5) What is native method.
6) What is abstract method
7) what is innerclass.
8) What is static class?
9) What is final class.
10) What is anonymous class?
JDBC:
1) What is a transaction. (*)
2) What is the purpose of setAutoCommit(). (*)
3) What are the three statements in JDBC & differences between them. (*)
4) What is stored procedure. How do you create stored procedure? (*)
5) What are batch updates.
JSP:
1)What is JSP. (*)
2)What are advantages of JSP.
3)What is the difference between include directive & jsp:include action. (*)
4)What are Custom tags. Why do you need Custom tags. How do you
create Custom tag. (*)
5)What are the implicit objects in JSP & differences between them. (*)
Servlets:
1)What are Servlets.
2)What are the advantages of Servlet.
3)What is the Life cycle of Servlet. (*)
4)What is the difference between Servlet and JSP. (*)
EJB:- (All questions are important)
1)What is the difference between normal Java object and EJB.
2)What is the difference between JavaBean and EJB.
3)What is EJB.
4)What is Session Bean. What are the various types of Session Bean.
XML:-
1)What is the difference between SAX parser and DOM parser. (*)
2)What is the difference between Schema and DTD. (*)
3)How do you parse/validate the XML document. (*)
4)What is XML Namespace.
5)What is Xpath.
PEOPLESOFT INTERVIEW QUESTIONS
1)What is the APP engine event in peoplecode.
2)what are the different actions in APP ENGINE.
3)How many temp records are there in app engine.
4)How do you debug your AE.
5)Why temp records are needed?
6)Why state records are needed?
7)Differences between State and temp records.
8)Different ways to run AE, SQR.(Command, process scheduler)
7)Different sql statements and metasql statements.
8)How do you retrieve a value from scroll..scroll select?
9)What is scroll select, etc
10)what is record, row peoplecode.
DATABASE QUESTIONS
1)What are copybooks(DB2)?
2)What is plan?
3)Tell me the sections in COBOL?
4)Connectivity to DB2 from COBOL.
5)What are the customizations in COBOL?
6)Diff between union and union all?
7)Give me example for group by.
8)What is SPUFI?
9)Replacement of query analyzer--- SPUFI(DB2)
ABAP QUESTIONS:
1.Elementary search helps, Collective search help.
2.Difference between Search Helps and Match Codes
3.Have you created database tables?
4.Difference between client dependent and client independent tables?
5.How to create client independent tables
6.Have you created Maintenance dialog or Table Maintenance?
7.On ABAP: Did you set up a workflow? Are you familiar with all steps for
setting up a workflow?
8.Have you used performance tuning? What major steps will you use for
these?
9.In the ‘select’ statement what is “group by”?
10.Have you worked with field groups? Have you used Import/Export
statements?
ABAP EDITOR:
1.Fixed point arithmetic – what is the use? How to set this?
2.Have you used client dependent ABAP programs?
DATABASE COMMANDS:
1.Select statement to read data into internal tables. Types of Select
statements
2.What happens “Update” command is used without where clause ?
3.Difference between “Insert”, “Update” and “Modify”
4.Explain “Commit” and “Roll back”
5.“Catch” Command
6.What is “Group by” in Select statement?
TEST AUTOMATION:
1.What automating testing tools are you familiar with?
2.How did you use automating testing tools in your job?
3.Describe some problem that you had with automating testing tool.
4.How do you plan test automation?
5.Can test automation improve test effectiveness?
6.What is data - driven automation?
7.What are the main attributes of test automation?
8.Does automation replace manual testing?
9.How will you choose a tool for test automation?
10.How you will evaluate the tool for test automation?
LOAD TESTING:
1.What criteria would you use to select Web transactions for load testing?
2.For what purpose are virtual users created?
3.Why it is recommended to add verification checks to your all your
scenarios?
4.In what situation would you want to parameterize a text verification
check?
5.Why do you need to parameterize fields in your virtual user script?
GENERAL QUESTIONS:
1.What types of documents would you need for QA, QC, and Testing?
2.What did you include in a test plan?
3.Describe any bug you remember.
4.What is the purpose of the testing?
5.What do you like (not like) in this job?
6.What is quality assurance?
7.What is the difference between QA and testing?
8.How do you scope, organize, and execute a test project?
9.What is the role of QA in a development project?
10.What is the role of QA in a company that produces software?
C C PLUS PLUS INTERVIEW QUESTIONS
1. What is the output of printf("%d")
2. Difference between "C structure" and "C++ structure".
3. Difference between a "assignment operator" and a "copy
constructor"
4. What is the difference between "overloading" and "overriding"?
5. Explain the need for "Virtual Destructor".
6. Can we have "Virtual Constructors"?
7. What are the different types of polymorphism?
8. What are Virtual Functions? How to implement virtual functions in
"C"
9. What are the different types of Storage classes?
10. What is Namespace?
VISUAL BASIC INTERVIEW QUESTIONS
1. 3 main differences between flexgrid control and dbgrid control
2. ActiveX and Types of ActiveX Components in VB
3. Advantage of ActiveX Dll over Active Exe
4. Advantages of disconnected recordsets
5. Benefit of wrapping database calls into MTS transactions
6. Benefits of using MTS
7. Can database schema be changed with DAO, RDO or ADO?
8. Can you create a tabletype of recordset in Jet - connected ODBC
database engine?
9. Constructors and distructors
10. Controls which do not have events
SQL Server
1.What are primary keys and foreign keys?
2.What is the difference between clustered and non-clustered indices?
...and why do you use a clustered index?
3.What is an outer join?
4.What are Cartesian joins?
5.How is referential integrity enforced in a SQL Server database?
6.What are the inserted and deleted tables and what are they used for?
7.What is the name of the SQL language used in SQL Server stored
procedures?
8.What is the purpose of having stored procedures in a database?
9.Why might you create a stored procedure with the 'with recompile'
option?
10.What is a cursor? Within a cursor, how would you update fields on the
row just fetched?
SQL, ORACLE, PRO*C/C++
1.What are the different types of joins?
2.Explain normalization with examples.
3.What cursor type do you use to retrieve multiple recordsets?
4.Difference between a "where" clause and a "having" clause
5.What is the difference between "procedure" and "function"?
6.How will you copy the structure of a table without copying the data?
7.How to find out the database name from SQL*PLUS command prompt?
8.Talk about "Exception Handling" in PL/SQL?
9.What is the difference between "NULL in C" and "NULL in Oracle?"
10.What is Pro*C? What is OCI?
ORACLE CONCEPTS AND ARCHITECTURE DATABASE STRUCTURES
1.What are the components of physical database structure of Oracle
database?
2.What are the components of logical database structure of Oracle
database?
3.What is a tablespace?
4.What is SYSTEM tablespace and when is it created?
5.Explain the relationship among database, tablespace and data file.
6.What is schema?
7.What are Schema Objects?
8.Can objects of the same schema reside in different tablespaces?
9.Can a tablespace hold objects from different schemes?
10.What is Oracle table?
SIEBEL INTERVIEW QUESTIONS
1.How do you control visibility in Siebel?
2.What is the difference between an organization and division in Siebel?
3.What does position represents in Siebel?
4.How do you assign responsibilities to employees in Siebel?
5.How do you set up employees in Siebel?
6.What happens if you create an employee in Siebel application and forget
to create the employee in the database?
7.Why do you need to create employees at the database in Siebel?
8.What is position type field in position applet?
9.What does an opportunity, account contact do in Siebel?
10.How is the opportunity related to an account?
DATAWARE HOUSING INTERVIEW QUESTIONS(ETL, BUSINESS
INTELLIGENCE,ABINITIO)
GENERAL :
1. What is a data-warehouse?
2. What are Data Marts?
4. What is ER Diagram?
5. What is a Star Schema?
6. What is Dimensional Modelling?
7. What is Snow Flake Schema?
ETL QUESTIONS:
1. What is a staging area? Do we need it? What is the purpose of a staging
area?
2. What is a three tier data warehouse?
3. What are the various methods of getting incremental records or delta
records from the source systems?
BUSINESS INTELLIGENCE:
1. What is Business Intelligence?
2. What is OLAP?
3. What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?
ABINITIO:
1.What is the function you would use to transfer a string into a decimal?
2.How many parallelisms are in Abinitio? Please give a definition of each.
3.What is the difference between a DB config and a CFG file?

UNIX Commands Interview Questions And Answers

2009-06-28T23:22:00.000-07:00

1. Construct pipes to execute the following jobs.
1. Output of who should be displayed on the screen with value of total number of users who have logged in displayed at the bottom of the list.

2. Output of ls should be displayed on the screen and from this output the lines containing the word ‘poem’ should be counted and the count should be stored in a file.

3. Contents of file1 and file2 should be displayed on the screen and this output should be appended in a file. From output of ls the lines containing ‘poem’ should be displayed on the screen along with the count.

4. Name of cities should be accepted from the keyboard . This list should be combined with the list present in a file. This combined list should be sorted and the sorted list
should be stored in a file ‘newcity’.

5. All files present in a directory dir1 should be deleted any error while deleting should be stored in a file ‘errorlog’.

2. Explain the following commands.
$ ls > file1
$ banner hi-fi > message
$ cat par.3 par.4 par.5 >> report
$ cat file1>file1
$ date ; who
$ date ; who > logfile
$ (date ; who) > logfile

3. What is the significance of the “tee” command?
It reads the standard input and sends it to the standard output while redirecting a copy of what it has read to the file specified by the user.

4. What does the command “ $who | sort –logfile > newfile” do?
The input from a pipe can be combined with the input from a file . The trick is to use the special symbol “-“ (a hyphen) for those commands that recognize the hyphen as std input.
In the above command the output from who becomes the std input to sort , meanwhile sort opens the file logfile, the contents of this file is sorted together with the output of who (rep by the hyphen) and the sorted output is redirected to the file newfile.

5. What does the command “$ls | wc –l > file1” do?
ls becomes the input to wc which counts the number of lines it receives as input and instead of displaying this count , the value is stored in file1.

6. Which of the following commands is not a filter man , (b) cat , (c) pg , (d) head
Ans: man
A filter is a program which can receive a flow of data from std input, process (or filter) it and send the result to the std output.

7. How is the command “$cat file2 “ different from “$cat >file2 and >> redirection operators ?
is the output redirection operator when used it overwrites while >> operator appends into the file.

9. Explain the steps that a shell follows while processing a command.
After the command line is terminated by the key, the shel goes ahead with processing the command line in one or more passes. The sequence is well defined and assumes the following order.
Parsing: The shell first breaks up the command line into words, using spaces and the delimiters, unless quoted. All consecutive occurrences of a space or tab are replaced here with a single space.
Variable evaluation: All words preceded by a $ are avaluated as variables, unless quoted or escaped.
Command substitution: Any command surrounded by backquotes is executed by the shell which t hen replaces the standard output of the command into the command line.
Wild-card interpretation: The shell finally scans the command line for wild-cards (the characters *, ?, [, ]).
Any word containing a wild-card is replaced by a sorted list of filenames that match the pattern. The list of these filenames then forms the arguments to the command.
PATH evaluation: It finally looks for the PATH variable to determine the sequence of directories it has to search in order to hunt for the command.

10. What difference between cmp and diff commands?
cmp - Compares two files byte by byte and displays the first mismatch
diff - tells the changes to be made to make the files identical

11. What is the use of ‘grep’ command?
‘grep’ is a pattern search command. It searches for the pattern, specified in the command line with appropriate option, in a file(s).
Syntax : grep
Example : grep 99mx mcafile

12. What is the difference between cat and more command?
Cat displays file contents. If the file is large the contents scroll off the screen before we view it. So
command 'more' is like a pager which displays the contents page by page.

13. Write a command to kill the last background job?
Kill $!

14. Which command is used to delete all files in the current directory and all its sub-directories?
rm -r *

15. Write a command to display a file’s contents in various formats?
$od -cbd file_name
c - character, b - binary (octal), d-decimal, od=Octal Dump.

16. What will the following command do?
$ echo *
It is similar to 'ls' command and displays all the files in the current directory.

17. Is it possible to create new a file system in UNIX?
Yes, ‘mkfs’ is used to create a new file system.
18. Is it possible to restrict incoming message?
Yes, using the ‘mesg’ command.

19. What is the use of the command "ls -x chapter[1-5]"
ls stands for list; so it displays the list of the files that starts with 'chapter' with suffix '1' to '5', chapter1,
chapter2, and so on.

20. Is ‘du’ a command? If so, what is its use?
Yes, it stands for ‘disk usage’. With the help of this command you can find the disk capacity and free space of the disk.

21. Is it possible to count number char, line in a file; if so, How?
Yes, wc-stands for word count.
wc -c for counting number of characters in a file.
wc -l for counting lines in a file.

22. Name the data structure used to maintain file identification?
‘inode’, each file has a separate inode and a unique inode number.

23. How many prompts are available in a UNIX system?
Two prompts, PS1 (Primary Prompt), PS2 (Secondary Prompt).

24. How does the kernel differentiate device files and ordinary files?

Kernel checks 'type' field in the file's inode structure.

25. How to switch to a super user status to gain privileges?
Use ‘su’ command. The system asks for password and when valid entry is made the user gains super user (admin) privileges.

26. What are shell variables?
Shell variables are special variables, a name-value pair created and maintained by the shell.
Example: PATH, HOME, MAIL and TERM

27. What is redirection?
Directing the flow of data to the file or from the file for input or output.
Example : ls > wc

28. How to terminate a process which is running and the specialty on command kill 0?
With the help of kill command we can terminate the process.
Syntax: kill pid
Kill 0 - kills all processes in your system except the login shell.

29. What is a pipe and give an example?
A pipe is two or more commands separated by pipe char '|'. That tells the shell to arrange for the output of the preceding command to be passed as input to the following command.
Example : ls -l | pr
The output for a command ls is the standard input of pr. When a sequence of commands are combined using pipe, then it is called pipeline.

30. Explain kill() and its possible return values.
There are four possible results from this call:
‘kill()’ returns 0. This implies that a process exists with the given PID, and the system would allow you to send signals to it. It is system-dependent whether the process could be a zombie.
‘kill()’ returns -1, ‘errno == ESRCH’ either no process exists with the given PID, or security enhancements are causing the system to deny its existence. (On some systems, the process could be a zombie.) ‘kill()’ returns -1, ‘errno == EPERM’ the system would not allow you to kill the specified process. This means that either the process exists (again, it could be a zombie) or draconian security enhancements are present (e.g. your process is not allowed to send signals to *anybody*). ‘kill()’ returns -1, with some other value of ‘errno’ you are in trouble! The most-used technique is to assume that success or failure with ‘EPERM’ implies that the process exists, and any other error implies that it doesn't.
An alternative exists, if you are writing specifically for a system (or all those systems) that provide a ‘/proc’ filesystem: checking for the existence of ‘/proc/PID’ may work.

HR Interview Questions and Answers

2009-06-27T22:16:00.000-07:00

What Are Your Strenght and Weaknesses?
"My strength is my flexibility to handle change. As far as weaknesses, I feel that my management skills could be stronger, and I am constantly working to improve them."

Why Should We Hire You?
"I have a unique combination of strong technical skills, and the ability to build strong customer relationships. This allows me to use my knowledge and break down information to be more user-friendly." "With five years' experience working in the financial industry and my proven record of saving the company money, I could make a big difference in your company. I'm confident I would be a great addition to your team."
Why Do You Want to Work Here?
This is the company I've been looking for, a place where my background, experience and skills can be put to use and make things happen."
or
"I've selected key companies whose mission statements are in line with my values, and this company is very high on my list of desirable choices."
WHAT is ur goal
"My immediate goal is to get a job in a growth-oriented company. My long-term goal will depend on where the company goes. I hope to eventually grow into a position of responsibility."

If you are employed, focus on what you want in your next job: "After two years, I made the decision to look for a company that is team-focused, where I can add my experience."
When Were You Most Satisfied in Your Job?
"I was very satisfied in my last job, because I worked directly with the customers and their problems; that is an important part of the job for me."
What Are Three Positive Things Your Last Boss Would Say About You?
It's time to pull out your old performance appraisals and boss's quotes. This is a great way to brag about yourself through someone else's words: "My boss has told me that I am the best designer he has ever had. He knows he can rely on me, and he likes my sense of humor

I have been in the customer service industry for the past five years. My most recent experience has been handling incoming calls in the high tech industry. One reason I particularly enjoy this business, and the challenges that go along with it, is the opportunity to connect with people. In my last job,."
Next, mention your strengths and abilities:
"My real strength is my attention to detail. I pride myself on my reputation for following through and meeting deadlines. When I commit to doing something, I make sure it gets done, and on time."
Continued...
Conclude with a statement about your current situation:
"What I am looking for now is a company that values customer relations, where I can join a strong team and have a positive impact on customer retention and sales."

Database Interview Questions and answers for Oracle database administrator

2009-06-26T22:14:00.000-07:00

Differentiate between TRUNCATE and DELETE
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
Can you use a commit statement within a database trigger?
What is an UTL_FILE.What are different procedures and functions associated with it?
Difference between database triggers and form triggers?
What is OCI. What are its uses?
What are ORACLE PRECOMPILERS?
What is syntax for dropping a procedure and a function? Are these operations possible?
Can a function take OUT parameters. If not why?
Can the default values be assigned to actual parameters?
What is difference between a formal and an actual parameter?
What are different modes of parameters used in functions and procedures?
Difference between procedure and function.
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How do you pass cursor variables in PL/SQL?
How do you open and close a cursor variable.Why it is required?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What is use of a cursor variable? How it is defined?
What WHERE CURRENT OF clause does in a cursor?
Difference between NO DATA FOUND and %NOTFOUND
What is a cursor for loop?
What are cursor attributes?
Difference between an implicit & an explicit cursor.
What is a cursor?
What is the purpose of a cluster?
How do you find the numbert of rows in a Table ?
Display the number value in Words?
What is a pseudo column. Give some examples?
How you will avoid your query from using indexes?
What is a OUTER JOIN?
Which is more faster - IN or EXISTS?
When do you use WHERE clause and when do you use HAVING clause?
There is a % sign in one field of a column. What will be the query to find it?
What is difference between SUBSTR and INSTR?
Which datatype is used for storing graphics and images?
What is difference between SQL and SQL*PLUS?
What is difference between UNIQUE and PRIMARY KEY constraints?
What is difference between Rename and Alias?
What are various joins used while writing SUBQUERIES?

^Back to Top

MS SQL Server interview questions
This one always gets asked. For a while the database interview questions were limited to Oracle and generic database design questions. This is a set of more than a hundred Microsoft SQL Server interview questions. Some questions are open-ended, and some do not have answers.

What is normalization? - Well a relational database is basically composed of tables that contain related data. So the Process of organizing this data into tables is actually referred to as normalization.
What is a Stored Procedure? - Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.
Can you give an example of Stored Procedure? - sp_helpdb , sp_who2, sp_renamedb are a set of system defined stored procedures. We can also have user defined stored procedures which can be called in similar way.
What is a trigger? - Triggers are basically used to implement business rules. Triggers is also similar to stored procedures. The difference is that it can be activated when data is added or edited or deleted from a table in a database.
What is a view? - If we have several tables in a db and we want to view only specific columns from specific tables we can go for views. It would also suffice the needs of security some times allowing specfic users to see only specific columns based on the permission that we can configure on the view. Views also reduce the effort that is required for writing queries to access specific columns every time.
What is an Index? - When queries are run against a db, an index on that db basically helps in the way the data is sorted to process the query for faster and data retrievals are much faster when we have an index.
What are the types of indexes available with SQL Server? - There are basically two types of indexes that we use with the SQL Server. Clustered and the Non-Clustered.
What is the basic difference between clustered and a non-clustered index? - The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index. Whereas in case of non-clustered index the leaf level is actually a pointer to the data in rows so we can have as many non-clustered indexes as we can on the db.
What are cursors? - Well cursors help us to do an operation on a set of data that we retreive by commands such as Select columns from table. For example : If we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retreival one by one and remove rows which have duplicate values.
When do we use the UPDATE_STATISTICS command? - This command is basically used when we do a large processing of data. If we do a large amount of deletions any modification or Bulk Copy into the tables, we need to basically update the indexes to take these changes into account. UPDATE_STATISTICS updates the indexes on these tables accordingly.
Which TCP/IP port does SQL Server run on? - SQL Server runs on port 1433 but we can also change it for better security.
From where can you change the default port? - From the Network Utility TCP/IP properties –> Port number.both on client and the server.
Can you tell me the difference between DELETE & TRUNCATE commands? - Delete command removes the rows from a table based on the condition that we provide with a WHERE clause. Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.
Can we use Truncate command on a table which is referenced by FOREIGN KEY? - No. We cannot use Truncate command on a table with Foreign Key because of referential integrity.
What is the use of DBCC commands? - DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What command do we use to rename a db? - sp_renamedb ‘oldname’ , ‘newname’
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases? - In such cases we can first bring to db to single user using sp_dboptions and then we can rename that db and then we can rerun the sp_dboptions command to remove the single user mode.
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? - Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.
What do you mean by COLLATION? - Collation is basically the sort order. There are three types of sort order Dictionary case sensitive, Dictonary - case insensitive and Binary.
What is a Join in SQL Server? - Join actually puts data from two or more tables into a single result set.
Can you explain the types of Joins that we can have with Sql Server? - There are three types of joins: Inner Join, Outer Join, Cross Join
When do you use SQL Profiler? - SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities such as which SQL Scripts are running, failed jobs etc..
What is a Linked Server? - Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements.
Can you link only other SQL Servers or any database servers such as Oracle? - We can link any server provided we have the OLE-DB provider from Microsoft to allow a link. For Oracle we have a OLE-DB provider for oracle that microsoft provides to add it as a linked server to the sql server group.
Which stored procedure will you be running to add a linked server? - sp_addlinkedserver, sp_addlinkedsrvlogin
What are the OS services that the SQL Server installation adds? - MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator)
Can you explain the role of each service? - SQL SERVER - is for running the databases SQL AGENT - is for automation such as Jobs, DB Maintanance, Backups DTC - Is for linking and connecting to other SQL Servers
How do you troubleshoot SQL Server if its running very slow? - First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot? - First I will look to ensure that port settings are proper on server and client Network utility for connections. ODBC is properly configured at client end for connection ——Makepipe & readpipe are utilities to check for connection. Makepipe is run on Server and readpipe on client to check for any connection issues.
What are the authentication modes in SQL Server? - Windows mode and mixed mode (SQL & Windows).
Where do you think the users names and passwords will be stored in sql server? - They get stored in master db in the sysxlogins table.
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow? - For restoring the master db we have to stop the SQL Server first and then from command line we can type SQLSERVER .m which will basically bring it into the maintenance mode after which we can restore the master db.
Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take? - (I am not sure- but I think we have a command to do it).
What is BCP? When do we use it? - BulkCopy is a tool used to copy huge amount of data from tables and views. But it won’t copy the structures of the same.
What should we do to copy the tables, schema and views from one SQL Server to another? - We have to write some DTS packages for it.
What are the different types of joins and what dies each do?
What are the four main query statements?
What is a sub-query? When would you use one?
What is a NOLOCK?
What are three SQL keywords used to change or set someone’s permissions?
What is the difference between HAVING clause and the WHERE clause?
What is referential integrity? What are the advantages of it?
What is database normalization?
Which command using Query Analyzer will give you the version of SQL server and operating system?
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
What is the purpose of using COLLATE in a query?
What is a trigger?
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”
What is an execution plan? When would you use it? How would you view the execution plan?
What is the STUFF function and how does it differ from the REPLACE function?
What does it mean to have quoted_identifier on? What are the implications of having it off?
What are the different types of replication? How are they used?
What is the difference between a local and a global variable?
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What are cursors? Name four types of cursors and when each one would be applied?
What is the purpose of UPDATE STATISTICS?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
How do you load large data to the SQL server database?
How do you check the performance of a query and how do you optimize it?
How do SQL server 2000 and XML linked? Can XML be used to access data?
What is SQL server agent?
What is referential integrity and how is it achieved?
What is indexing?
What is normalization and what are the different forms of normalizations?
Difference between server.transfer and server.execute method?
What id de-normalization and when do you do it?
What is better - 2nd Normal form or 3rd normal form? Why?
Can we rewrite subqueries into simple select statements or with joins? Example?
What is a function? Give some example?
What is a stored procedure?
Difference between Function and Procedure-in general?
Difference between Function and Stored Procedure?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?
How do you find the number of rows in a table?
Difference between Cluster and Non-cluster index?
What is a table called, if it does not have neither Cluster nor Non-cluster Index?
Explain DBMS, RDBMS?
Explain basic SQL queries with SELECT from where Order By, Group By-Having?
Explain the basic concepts of SQL server architecture?
Explain couple pf features of SQL server
Scalability, Availability, Integration with internet, etc.)?
Explain fundamentals of Data ware housing & OLAP?
Explain the new features of SQL server 2000?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is data integrity? Explain constraints?
Explain some DBCC commands?
Explain sp_configure commands, set commands?
Explain what are db_options used for?
What is the basic functions for master, msdb, tempdb databases?
What is a job?
What are tasks?
What are primary keys and foreign keys?
How would you Update the rows which are divisible by 10, given a set of numbers in column?
If a stored procedure is taking a table data type, how it looks?
How m-m relationships are implemented?
How do you know which index a table is using?
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?
How do you find the error, how can you know the number of rows effected by last SQL statement?
How can you get @@error and @@rowcount at the same time?
What are sub-queries? Give example? In which case sub-queries are not feasible?
What are the type of joins? When do we use Outer and Self joins?
Which virtual table does a trigger use?
How do you measure the performance of a stored procedure?
Questions regarding Raiseerror?
Questions on identity?
If there is failure during updation of certain rows, what will be the state?

^Back to Top

JDBC and JSP interview questions
What is the query used to display all tables names in SQL Server (Query analyzer)?

select * from information_schema.tables

How many types of JDBC Drivers are present and what are they?- There are 4 types of JDBC Drivers
JDBC-ODBC Bridge Driver

Native API Partly Java Driver
Network protocol Driver
JDBC Net pure Java Driver
Can we implement an interface in a JSP?- No
What is the difference between ServletContext and PageContext?- ServletContext: Gives the information about the container. PageContext: Gives the information about the Request
What is the difference in using request.getRequestDispatcher() and context.getRequestDispatcher()?- request.getRequestDispatcher(path): In order to create it we need to give the relative path of the resource, context.getRequestDispatcher(path): In order to create it we need to give the absolute path of the resource.
How to pass information from JSP to included JSP?- Using <%jsp:param> tag.
What is the difference between directive include and jsp include?- <%@ include>: Used to include static resources during translation time. JSP include: Used to include dynamic content or static content during runtime.
What is the difference between RequestDispatcher and sendRedirect?- RequestDispatcher: server-side redirect with request and response objects. sendRedirect : Client-side redirect with new request and response objects.
How does JSP handle runtime exceptions?- Using errorPage attribute of page directive and also we need to specify isErrorPage=true if the current page is intended to URL redirecting of a JSP.
How do you delete a Cookie within a JSP?
Cookie mycook = new Cookie(\"name\",\"value\");
response.addCookie(mycook);
Cookie killmycook = new Cookie(\"mycook\",\"value\");
killmycook.setMaxAge(0);
killmycook.setPath(\"/\");
killmycook.addCookie(killmycook);

How do I mix JSP and SSI #include?- If you’re just including raw HTML, use the #include directive as usual inside your .jsp file.

But it’s a little trickier if you want the server to evaluate any JSP code that’s inside the included file. If your data.inc file contains jsp code you will have to use

<%@ vinclude="data.inc" %>

The is used for including non-JSP files.

I made my class Cloneable but I still get Can’t access protected method clone. Why?- Some of the Java books imply that all you have to do in order to have your class support clone() is implement the Cloneable interface. Not so. Perhaps that was the intent at some point, but that’s not the way it works currently. As it stands, you have to implement your own public clone() method, even if it doesn’t do anything special and just calls super.clone().
Why is XML such an important development?- It removes two constraints which were holding back Web developments: dependence on a single, inflexible document type (HTML) which was being much abused for tasks it was never designed for; the complexity of full SGML, whose syntax allows many powerful but hard-to-program options. XML allows the flexible development of user-defined document types. It provides a robust, non-proprietary, persistent, and verifiable file format for the storage and transmission of text and data both on and off the Web; and it removes the more complex options of SGML, making it easier to program for.
What is the fastest type of JDBC driver?- JDBC driver performance will depend on a number of issues:
the quality of the driver code,

the size of the driver code,
the database server and its load,
network topology,
the number of times your request is translated to a different API.
In general, all things being equal, you can assume that the more your request and response change hands, the slower it will be. This means that Type 1 and Type 3 drivers will be slower than Type 2 drivers (the database calls are make at least three translations versus two), and Type 4 drivers are the fastest (only one translation).

How do I find whether a parameter exists in the request object?
boolean hasFoo = !(request.getParameter(\"foo\") == null
|| request.getParameter(\"foo\").equals(\"\"));

or

boolean hasParameter =
request.getParameterMap().contains(theParameter); //(which works in Servlet 2.3+)

How can I send user authentication information while makingURLConnection?- You’ll want to use HttpURLConnection.setRequestProperty and set all the appropriate headers to HTTP authorization.

^Back to Top

SQL Server interview questions
How do you read transaction logs?
How do you reset or reseed the IDENTITY column?
How do you persist objects, permissions in tempdb?
How do you simulate a deadlock for testing purposes?
How do you rename an SQL Server computer?
How do you run jobs from T-SQL?
How do you restore single tables from backup in SQL Server 7.0/2000? In SQL Server 6.5?
Where to get the latest MDAC from?
I forgot/lost the sa password. What do I do?
I have only the .mdf file backup and no SQL Server database backups. Can I get my database back into SQL Server?
How do you add a new column at a specific position (say at the beginning of the table or after the second column) using ALTER TABLE command?
How do you change or alter a user defined data type?
How do you rename an SQL Server 2000 instance?
How do you capture/redirect detailed deadlock information into the error logs?
How do you remotely administer SQL Server?
What are the effects of switching SQL Server from ‘Mixed mode’ to ‘Windows only’ authentication mode? What are the steps required, to not break existing applications?
Is there a command to list all the tables and their associated filegroups?
How do you ship the stored procedures, user defined functions (UDFs), triggers, views of my application, in an encrypted form to my clients/customers? How do you protect intellectual property?
How do you archive data from my tables? Is there a built-in command or tool for this?
How do you troubleshoot ODBC timeout expired errors experienced by applications accessing SQL Server databases?
How do you restart SQL Server service automatically at regular intervals?
What is the T-SQL equivalent of IIF (immediate if/ternary operator) function of other programming languages?
How do you programmatically find out when the SQL Server service started?
How do you get rid of the time part from the date returned by GETDATE function?
How do you upload images or binary files into SQL Server tables?
How do you run an SQL script file that is located on the disk, using T-SQL?
How do you get the complete error message from T-SQL while error handling?
How do you get the first day of the week, last day of the week and last day of the month using T-SQL date functions?
How do you pass a table name, column name etc. to the stored procedure so that I can dynamically select from a table?
Error inside a stored procedure is not being raised to my front-end applications using ADO. But I get the error when I run the procedure from Query Analyzer.
How do you suppress error messages in stored procedures/triggers etc. using T-SQL?
How do you save the output of a query/stored procedure to a text file?
How do you join tables from different databases?
How do you join tables from different servers?
How do you convert timestamp data to date data (datetime datatype)?
Can I invoke/instantiate COM objects from within stored procedures or triggers using T-SQL?
Oracle has a rownum to access rows of a table using row number or row id. Is there any equivalent for that in SQL Server? Or How do you generate output with row number in SQL Server?
How do you specify a network library like TCP/IP using ADO connect string?
How do you generate scripts for repetitive tasks like truncating all the tables in a database, changing owner of all the database objects, disabling constraints on all tables etc?
Is there a way to find out when a stored procedure was last updated?
How do you find out all the IDENTITY columns of all the tables in a given database?
How do you search the code of stored procedures?
How do you retrieve the generated GUID value of a newly inserted row? Is there an @@GUID, just like @@IDENTITY?

NETWORKING INTERVIEW QUESTIONS

2009-06-25T22:09:00.000-07:00

1. What are 10Base2, 10Base5 and 10BaseT Ethernet LANs
10Base2—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling, with a contiguous cable segment length of 100 meters and a maximum of 2 segments.
10Base5—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling, with 5 continuous segments not exceeding 100 meters per segment.
10BaseT—An Ethernet term meaning a maximum transfer rate of 10 Megabits per second that uses baseband signaling and twisted pair cabling.

2. Explain the difference between an unspecified passive open and a fully specified passive open
An unspecified passive open has the server waiting for a connection request from a client. A fully specified passive open has the server waiting for a connection from a specific client.

3. Explain the function of Transmission Control Block
A TCB is a complex data structure that contains a considerable amount of information about each connection.

4. Explain a Management Information Base (MIB)
A Management Information Base is part of every SNMP-managed device. Each SNMP agent has the MIB database that contains information about the device's status, its performance, connections, and configuration. The MIB is queried by SNMP.

5. Explain anonymous FTP and why would you use it
Anonymous FTP enables users to connect to a host without using a valid login and password. Usually, anonymous FTP uses a login called anonymous or guest, with the password usually requesting the user's ID for tracking purposes only. Anonymous FTP is used to enable a large number of users to access files on the host without having to go to the trouble of setting up logins for them all. Anonymous FTP systems usually have strict controls over the areas an anonymous user can access.

6. Explain a pseudo tty
A pseudo tty or false terminal enables external machines to connect through Telnet or rlogin. Without a pseudo tty, no connection can take place.

7. Explain REX
What advantage does REX offer other similar utilities?

8. What does the Mount protocol do?
The Mount protocol returns a file handle and the name of the file system in which a requested file resides. The message is sent to the client from the server after reception of a client's request.

9. Explain External Data Representation
External Data Representation is a method of encoding data within an RPC message, used to ensure that the data is not system-dependent.

10. Explain the Network Time Protocol?

11. BOOTP helps a diskless workstation boot. How does it get a message to the network looking for its IP address and the location of its operating system boot files?
BOOTP sends a UDP message with a subnetwork broadcast address and waits for a reply from a server that gives it the IP address. The same message might contain the name of the machine that has the boot files on it. If the boot image location is not specified, the workstation sends another UDP message to query the server.

12. Explain a DNS resource record
A resource record is an entry in a name server's database. There are several types of resource records used, including name-to-address resolution information. Resource records are maintained as ASCII files.

13. What protocol is used by DNS name servers?
DNS uses UDP for communication between servers. It is a better choice than TCP because of the improved speed a connectionless protocol offers. Of course, transmission reliability suffers with UDP.

14. Explain the difference between interior and exterior neighbor gateways
Interior gateways connect LANs of one organization, whereas exterior gateways connect the organization to the outside world.

15. Explain the HELLO protocol used for
The HELLO protocol uses time instead of distance to determine optimal routing. It is an alternative to the Routing Information Protocol.

16. What are the advantages and disadvantages of the three types of routing tables?
The three types of routing tables are fixed, dynamic, and fixed central. The fixed table must be manually modified every time there is a change. A dynamic table changes its information based on network traffic, reducing the amount of manual maintenance. A fixed central table lets a manager modify only one table, which is then read by other devices. The fixed central table reduces the need to update each
machine's table, as with the fixed table. Usually a dynamic table causes the fewest problems for a network administrator, although the table's contents can change without the administrator being aware of the change.

17. Explain a TCP connection table

18. Explain source route
It is a sequence of IP addresses identifying the route a datagram must follow. A source route may optionally be included in an IP datagram header.

19. Explain RIP (Routing Information Protocol)
It is a simple protocol used to exchange information between the routers.
20. Explain SLIP (Serial Line Interface Protocol)
It is a very simple protocol used for transmission of IP datagrams across a serial line.
21. Explain Proxy ARP
It is using a router to answer ARP requests. This will be done when the originating host believes that a destination is local, when in fact is lies beyond router.
22. Explain OSPF
It is an Internet routing protocol that scales well, can route traffic along multiple paths, and uses knowledge of an Internet's topology to make accurate routing decisions.
23. Explain Kerberos
It is an authentication service developed at the Massachusetts Institute of Technology. Kerberos uses encryption to prevent intruders from discovering passwords and gaining unauthorized access to files.
24. Explain a Multi-homed Host
It is a host that has a multiple network interfaces and that requires multiple IP addresses is called as a Multi-homed Host.
25. Explain NVT (Network Virtual Terminal)
It is a set of rules defining a very simple virtual terminal interaction. The NVT is used in the start of a Telnet session.
26. Explain Gateway-to-Gateway protocol
It is a protocol formerly used to exchange routing information between Internet core routers.
27. Explain BGP (Border Gateway Protocol)
It is a protocol used to advertise the set of networks that can be reached with in an autonomous system. BGP enables this information to be shared with the autonomous system. This is newer than EGP (Exterior Gateway Protocol).
28. Explain autonomous system
It is a collection of routers under the control of a single administrative authority and that uses a common Interior Gateway Protocol.
29. Explain EGP (Exterior Gateway Protocol)
It is the protocol the routers in neighboring autonomous systems use to identify the set of networks that can be reached within or via each autonomous system.
30. Explain IGP (Interior Gateway Protocol)
It is any routing protocol used within an autonomous system.
31. Explain Mail Gateway
It is a system that performs a protocol translation between different electronic mail delivery protocols.
32. Explain wide-mouth frog
Wide-mouth frog is the simplest known key distribution center (KDC) authentication protocol.
33. What are Digrams and Trigrams
The most common two letter combinations are called as digrams. e.g. th, in, er, re and an. The most common three letter combinations are called as trigrams. e.g. the, ing, and, and ion.
34. Explain silly window syndrome
It is a problem that can ruin TCP performance. This problem occurs when data are passed to the sending TCP entity in large blocks, but an interactive application on the receiving side reads 1 byte at a time.
35. Explain region
When hierarchical routing is used, the routers are divided into what we call regions, with each router knowing all the details about how to route packets to destinations within its own region, but knowing nothing about the internal structure of other regions.
36. Explain multicast routing
Sending a message to a group is called multicasting, and its routing algorithm is called multicast routing.
37. Explain traffic shaping
One of the main causes of congestion is that traffic is often busy. If hosts could be made to transmit at a uniform rate, congestion would be less common. Another open loop method to help manage congestion is forcing the packet to be transmitted at a more predictable rate. This is called traffic shaping.
38. Explain packet filter
Packet filter is a standard router equipped with some extra functionality. The extra functionality allows every incoming or outgoing packet to be inspected. Packets meeting some criterion are forwarded normally. Those that fail the test are dropped.
39. Explain virtual path
Along any transmission path from a given source to a given destination, a group of virtual circuits can be grouped together into what is called path.
40. Explain virtual channel
Virtual channel is normally a connection from one source to one destination, although multicast connections are also permitted. The other name for virtual channel is virtual circuit.
41. Explain logical link control
One of two sublayers of the data link layer of OSI reference model, as defined by the IEEE 802 standard. This sublayer is responsible for maintaining the link between computers when they are sending data across the physical network connection.
42. Why should you care about the OSI Reference Model
It provides a framework for discussing network operations and design.
43. Explain the difference between routable and non- routable protocols
Routable protocols can work with a router and can be used to build large networks. Non-Routable protocols are designed to work on small, local networks and cannot be used with a router
44. Explain MAU
In token Ring , hub is called Multistation Access Unit(MAU).
45. Explain 5-4-3 rule
In a Ethernet network, between any two points on the network, there can be no more than five network segments or four repeaters, and of those five segments only three of segments can be populated.
46. Explain the difference between TFTP and FTP application layer protocols
The Trivial File Transfer Protocol (TFTP) allows a local host to obtain files from a remote host but does not provide reliability or security. It uses the fundamental packet delivery services offered by UDP.
The File Transfer Protocol (FTP) is the standard mechanism provided by TCP / IP for copying a file from one host to another. It uses the services offered by TCP and so is reliable and secure. It establishes two connections (virtual circuits) between the hosts, one for data transfer and another for control information.
47. Explain the range of addresses in the classes of internet addresses
Class A 0.0.0.0 - 127.255.255.255
Class B 128.0.0.0 - 191.255.255.255
Class C 192.0.0.0 - 223.255.255.255
Class D 224.0.0.0 - 239.255.255.255
Class E 240.0.0.0 - 247.255.255.255
48. Explain the minimum and maximum length of the header in the TCP segment and IP datagram
The header should have a minimum length of 20 bytes and can have a maximum length of 60 bytes.
49. Explain difference between ARP and RARP
The address resolution protocol (ARP) is used to associate the 32 bit IP address with the 48 bit physical address, used by a host or a router to find the physical address of another host on its network by sending a ARP query packet that includes the IP address of the receiver. The reverse address resolution protocol (RARP) allows a host to discover its Internet address when it knows only its physical address.
50. Explain ICMP
ICMP is Internet Control Message Protocol, a network layer protocol of the TCP/IP suite used by hosts and gateways to send notification of datagram problems back to the sender. It uses the echo test / reply to test whether a destination is reachable and responding. It also handles both control and error messages.
51. What are the data units at different layers of the TCP / IP protocol suite
The data unit created at the application layer is called a message, at the transport layer the data unit created is called either a segment or an user datagram, at the network layer the data unit created is called the datagram, at the data link layer the datagram is encapsulated in to a frame and
finally transmitted as signals along the transmission media.
52. Explain Project 802
It is a project started by IEEE to set standards that enable intercommunication between equipment from a variety of manufacturers. It is a way for specifying functions of the physical layer, the data link layer and to some extent the network layer to allow for interconnectivity of major LAN protocols.
It consists of the following:
802.1 is an internetworking standard for compatibility of different LANs and MANs across protocols.
802.2 Logical link control (LLC) is the upper sublayer of the data link layer which is non-architecture-specific, that is remains the same for all IEEE-defined LANs.
Media access control (MAC) is the lower sublayer of the data link layer that contains some distinct modules each carrying proprietary information specific to the LAN product being used. The modules are Ethernet LAN (802.3), Token ring LAN (802.4), Token bus LAN (802.5).
802.6 is distributed queue dual bus (DQDB) designed to be used in MANs.
53. Explain Bandwidth
Every line has an upper limit and a lower limit on the frequency of signals it can carry. This limited range is called the bandwidth.
54. Difference between bit rate and baud rate.
Bit rate is the number of bits transmitted during one second whereas baud rate refers to the number of signal units per second that are required to represent those bits. baud rate = bit rate / N where N is no-of-bits represented by each signal shift.
55. Explain MAC address
The address for a device as it is identified at the Media Access Control (MAC) layer in the network architecture. MAC address is usually stored in ROM on the network adapter card and is unique.
56. Explain attenuation
The degeneration of a signal over distance on a network cable is called attenuation.
57. Explain cladding
A layer of a glass surrounding the center fiber of glass inside a fiber-optic cable.
58. Explain RAID
A method for providing fault tolerance by using multiple hard disk drives.
59. Explain NETBIOS and NETBEUI
NETBIOS is a programming interface that allows I/O requests to be sent to and received from a remote computer and it hides the networking hardware from applications. NETBEUI is NetBIOS extended user interface. A transport protocol designed by microsoft and IBM for the use on small subnets.
60. Explain redirector
Redirector is software that intercepts file or prints I/O requests and translates them into network requests. This comes under presentation layer.
61. Explain Beaconing
The process that allows a network to self-repair networks problems. The stations on the network notify the other stations on the ring when they are not receiving the transmissions. Beaconing is used in Token ring and FDDI networks.
62. Explain terminal emulation, in which layer it comes
Telnet is also called as terminal emulation. It belongs to application layer.
63. Explain frame relay, in which layer it comes
Frame relay is a packet switching technology. It will operate in the data link layer.
64. What do you meant by "triple X" in Networks
The function of PAD (Packet Assembler Disassembler) is described in a document known as X.3. The standard protocol has been defined between the terminal and the PAD, called X.28; another standard protocol exists between hte PAD and the network, called X.29. Together, these three recommendations are often called "triple X"
65. Explain SAP
Series of interface points that allow other computers to communicate with the other layers of network protocol stack.
66. Explain subnet
A generic term for section of a large networks usually separated by a bridge or router.
67. Explain Brouter
Hybrid devices that combine the features of both bridges and routers.
68. How Gateway is different from Routers
A gateway operates at the upper levels of the OSI model and translates information between two completely different network architectures or data formats.
69. What are the different type of networking / internetworking devices
Repeater: Also called a regenerator, it is an electronic device that operates only at physical layer. It receives the signal in the network before it becomes weak, regenerates the original bit pattern and puts the refreshed copy back in to the link.
Bridges: These operate both in the physical and data link layers of LANs of same type. They divide a larger network in to smaller segments. They contain logic that allow them to keep the traffic for each segment separate and thus are repeaters that relay a frame only the side of the segment containing the intended recipent and control congestion.
Routers: They relay packets among multiple interconnected networks (i.e. LANs of different type). They operate in the physical, data link and network layers. They contain software that enable them to determine which of the several possible paths is the best for a particular transmission.
Gateways:
They relay packets among networks that have different protocols (e.g. between a LAN and a WAN). They accept a packet formatted for one protocol and convert it to a packet formatted for another protocol before forwarding it. They operate in all seven layers of the OSI model.
70. Explain mesh network
A network in which there are multiple network links between computers to provide multiple paths for data to travel.
71. Explain passive topology
When the computers on the network simply listen and receive the signal, they are referred to as passive because they don’t amplify the signal in any way. Example for passive topology - linear bus.
72. What are the important topologies for networks
BUS topology:
In this each computer is directly connected to primary network cable in a single line.
Advantages:
Inexpensive, easy to install, simple to understand, easy to extend.
STAR topology:
In this all computers are connected using a central hub.
Advantages:
Can be inexpensive, easy to install and reconfigure and easy to trouble shoot physical problems.
RING topology:
In this all computers are connected in loop.
Advantages:
All computers have equal access to network media, installation can be simple, and signal does not degrade as much as
in other topologies because each computer
regenerates it.
73. What are major types of networks and explain
Server-based network
Peer-to-peer network
Peer-to-peer network, computers can act as both servers sharing resources and as clients using the resources.
Server-based networks provide centralized control of network resources and rely on server computers to provide security and network administration
74. Explain Protocol Data Unit
The data unit in the LLC level is called the protocol data unit (PDU). The PDU contains of four fields a destination service access point (DSAP), a source service access point (SSAP), a control field and an information field. DSAP, SSAP are addresses used by the LLC to identify the protocol stacks on the receiving and sending machines that are generating and using the data. The control field specifies whether the PDU frame is a information frame (I - frame) or a supervisory frame (S - frame) or a
unnumbered frame (U - frame).
75. Explain difference between baseband and broadband transmission
In a baseband transmission, the entire bandwidth of the cable is consumed by a single signal. In broadband transmission, signals are sent on multiple frequencies, allowing multiple signals to be sent simultaneously.
76. What are the possible ways of data exchange
(i) Simplex (ii) Half-duplex (iii) Full-duplex.
77. What are the types of Transmission media
Signals are usually transmitted over some transmission media that are broadly classified in to two categories.
Guided Media:
These are those that provide a conduit from one device to another that include twisted-pair, coaxial cable and fiber-optic cable. A signal traveling along any of these media is directed and is contained by the physical limits of the medium. Twisted-pair and coaxial cable use metallic that accept
and transport signals in the form of electrical current. Optical fiber is a glass or plastic cable that accepts and transports signals in the form of light.
Unguided Media:
This is the wireless media that transport electromagnetic waves without using a physical conductor. Signals are broadcast either through air. This is done through radio communication, satellite communication and cellular telephony.
78. Explain point-to-point protocol
A communications protocol used to connect computers to remote networking services including Internet service providers.
79. What are the two types of transmission technology available
(i) Broadcast and (ii) point-to-point
80. Difference between the communication and transmission.
Transmission is a physical movement of information and concern issues like bit polarity, synchronization, clock etc. Communication means the meaning full exchange of information between two communication media.
Source: http://www.tutorialdownloads.com/FAQ/networking-interview-questions.html

General & HR Interview Question and Answer

2009-06-24T22:08:00.000-07:00

Mental fear of the unknown is often what produces the physical symptoms of nervousness. In addition to preparing yourself physically, you also need to prepare yourself mentally. The best way to prepare mentally is to know what may be coming. Fear of the unknown can only exist when there is an unknown. Take the time to understand some of the "standards" when it comes to interviewing questions.
The following are some of the most difficult questions you will face in the course of your job interviews. Some questions may seem rather simple on the surface--such as "Tell me about yourself"--but these questions can have a variety of answers. The more open-ended the question, the wider the variation in the answers. Once you have become practiced in your interviewing skills, you will find that you can use almost any question as a launching pad for a particular topic or compelling story.
Others are "classic" interview questions, such as, "What is your greatest weakness?" Questions which most people answer inappropriately. In this case, the standard textbook answer for the "greatest weakness" question is to give a veiled positive--"I work too much. I just work and work and work"--which ends up sending the wrong message. Either you are lying or, worse yet, you are telling the truth, in which case you define working too much as a weakness and really don't want to work much at all. Think about it.
The following answers are provided to give you a new perspective on how to answer tough interview questions. They are not there for you to lift from the page and insert into your next interview. They are there for you to use as the basic structure for formulating your own answers. While the specifics of each reply may not apply to you, try to follow the basic structure of the answer from the perspective of the interviewer. Answer the questions behaviorally, with specific examples that show clear evidence backs up what you are saying about yourself. Always provide information that shows you want to become the very best _____ for the company and that you have specifically prepared yourself to become exactly that. They want to be sold. They are waiting to be sold. Don't disappoint them!
1. Tell me about yourself.
My background to date has been centered around preparing myself to become the very best _____ I can become. Let me tell you specifically how I've prepared myself . . .
2. Why should I hire you?
Because I sincerely believe that I'm the best person for the job. I realize that there are many other college students who have the ability to do this job. I also have that ability. But I also bring an additional quality that makes me the very best person for the job--my attitude for excellence. Not just giving lip service to excellence, but putting every part of myself into achieving it. In _____ and _____ I have consistently reached for becoming the very best I can become by doing the following . . .
3. What is your long-range objective? Where do you want to be 10 or 15 years from now?
Although it's certainly difficult to predict things far into the future, I know what direction I want to develop toward. Within five years, I would like to become the very best _____ your company has. In fact, my personal career mission statement is to become a world-class _____ in the _____ industry. I will work toward becoming the expert that others rely upon. And in doing so, I feel I will be fully prepared to take on any greater responsibilities that might be presented in the long term.
4. How has your education prepared you for your career?
As you will note on my resume, I've taken not only the required core classes in the _____ field, I've also gone above and beyond. I've taken every class the college has to offer in the field and also completed an independent study project specifically in this area. But it's not just taking the classes to gain academic knowledge--I've taken each class, both inside and outside of my major, with this profession in mind. So when we're studying _____ in _____, I've viewed it from the perspective of _____. In addition, I've always tried to keep a practical view of how the information would apply to my job. Not just theory, but how it would actually apply. My capstone course project in my final semester involved developing a real-world model of _____, which is very similar to what might be used within your company. Let me tell you more about it . . .
5. Are you a team player?
Very much so. In fact, I've had opportunities in both athletics and academics to develop my skills as a team player. I was involved in _____ at the intramural level, including leading my team in assists during the past year--I always try to help others achieve their best. In academics, I've worked on several team projects, serving as both a member and team leader. I've seen the value of working together as a team to achieve a greater goal than any one of us could have achieved individually. As an example . . .
6. Have you ever had a conflict with a boss or professor? How was it resolved?
Yes, I have had conflicts in the past. Never major ones, but certainly there have been situations where there was a disagreement that needed to be resolved. I've found that when conflict occurs, it's because of a failure to see both sides of the situation. Therefore, I ask the other person to give me their perspective and at the same time ask that they allow me to fully explain my perspective. At that point, I would work with the person to find out if a compromise could be reached. If not, I would submit to their decision because they are my superior. In the end, you have to be willing to submit yourself to the directives of your superior, whether you're in full agreement or not. An example of this was when . . .
7. What is your greatest weakness?
I would say my greatest weakness has been my lack of proper planning in the past. I would overcommit myself with too many variant tasks, then not be able to fully accomplish each as I would like. However, since I've come to recognize that weakness, I've taken steps to correct it. For example, I now carry a planning calendar in my pocket so that I can plan all of my appointments and "to do" items. Here, let me show you how I have this week planned out . . .
8. If I were to ask your professors to describe you, what would they say?
I believe they would say I'm a very energetic person, that I put my mind to the task at hand and see to it that it's accomplished. They would say that if they ever had something that needed to be done, I was the person who they could always depend on to see that it was accomplished. They would say that I always took a keen interest in the subjects I was studying and always sought ways to apply the knowledge in real world settings. Am I just guessing that they would say these things? No, in fact, I'm quite certain they would say those things because I have with me several letters of recommendation from my professors, and those are their very words. Let me show you . . .
9. What qualities do you feel a successful manager should have?
The key quality should be leadership--the ability to be the visionary for the people who are working under them. The person who can set the course and direction for subordinates. A manager should also be a positive role model for others to follow. The highest calling of a true leader is inspiring others to reach the highest of their abilities. I'd like to tell you about a person who I consider to be a true leader . . .
10. If you had to live your life over again, what would you change?
That's a good question. I realize that it can be very easy to continually look back and wish that things had been different in the past. But I also realize that things in the past cannot be changed, that only things in the future can be changed. That's why I continually strive to improve myself each and every day and that's why I'm working hard to continually increase my knowledge in the _____ field. That's also the reason why I want to become the very best _____ your company has ever had. To make positive change. And all of that is still in the future. So in answer to your question, there isn't anything in my past that I would change. I look only to the future to make changes in my life.
In reviewing the above responses, please remember that these are sample answers. Please do not rehearse them verbatim or adopt them as your own. They are meant to stir your creative juices and get you thinking about how to properly answer the broader range of questions that you will face.
Fifty Standard Interview Questions

It is not enough to have solid answers only for the above questions. You need to be prepared for the full spectrum of questions that may be presented. For further practice, make sure you go through the required mock interview (see the "Competitive Interview Prep" Section) and for further review, look at some of the following questions:
1. Tell me about yourself.
2. What do you want to do with your life?
3. Do you have any actual work experience?
4. How would you describe your ideal job?
5. Why did you choose this career?
6. When did you decide on this career?
7. What goals do you have in your career?
8. How do you plan to achieve these goals?
9. How do you evaluate success?
10. Describe a situation in which you were successful.
11. What do you think it takes to be successful in this career?
12. What accomplishments have given you the most satisfaction in your life?
13. If you had to live your life over again, what would you change?
14. Would your rather work with information or with people?
15. Are you a team player?
16. What motivates you?
17. Why should I hire you?
18. Are you a goal-oriented person?
19. Tell me about some of your recent goals and what you did to achieve them.
20. What are your short-term goals?
21. What is your long-range objective?
22. What do you see yourself doing five years from now?
23. Where do you want to be ten years from now?
24. Do you handle conflict well?
25. Have you ever had a conflict with a boss or professor? How did you resolve it?
26. What major problem have you had to deal with recently?
27. Do you handle pressure well?
28. What is your greatest strength?
29. What is your greatest weakness?
30. If I were to ask one of your professors to describe you, what would he or she say?
31. Why did you choose to attend your college?
32. What changes would you make at your college?
33. How has your education prepared you for your career?
34. What were your favorite classes? Why?
35. Do you enjoy doing independent research?
36. Who were your favorite professors? Why?
37. Why is your GPA not higher?
38. Do you have any plans for further education?
39. How much training do you think you'll need to become a productive employee?
40. What qualities do you feel a successful manager should have?
41. Why do you want to work in the _____ industry?
42. What do you know about our company?
43. Why are you interested in our company?
44. Do you have any location preferences?
45. How familiar are you with the community that we're located in?
46. Will you relocate? In the future?
47. Are you willing to travel? How much?
48. Is money important to you?
49. How much money do you need to make to be happy?
50. What kind of salary are you looking for?
Don't just read these questions--practice and rehearse the answers. Don't let the company interview be the first time you have actually formulated an answer in spoken words. It is not enough to think about them in your head--practice! Sit down with a friend, a significant other, or your roommate (an especially effective critic, given the amount of preparation to date) and go through all of the questions. Make the most of every single interview opportunity by being fully prepared!
Top Ten Critical Success Factors

With all the different questions being referenced, you may wonder what exactly the employer is looking for. And I will tell you. Following is the list of the top ten critical success factors that nearly every employer is seeking:
1. Positive attitude toward work
2. Proficiency in field of study
3. Communication skills (oral and written)
4. Interpersonal skills
5. Confidence
6. Critical thinking and problem solving skills
7. Flexibility
8. Self-motivation
9. Leadership
10. Teamwork
Show your competence in as many of the above critical success factors as possible and you will rise above the competition.

One Interview Question That Nearly Every College Student Fails

Here it is. The one question that nearly every college student fails to answer properly (and will continue to send students to their interview ruin) is:
"Why did you choose to attend this college?"
You have spent the last several years knocking the college--the professors, the administration, the dorms, the food in the dining halls, whatever--and now you suddenly need to come to its defense. And if you have not thought of an answer before the interview, you definitely will not come up with a valid one on the spot.
So think about it in advance. What is the real reason you are attending your college? Is it because of the academic program? Is it because of extracurricular programs? Athletics? Close to home? Party school? Great dating opportunities? Everyone else turned you down?
Once you acknowledge your true reason for attending, you will need to temper your response with some directed reasoning--tie in what it is about your college that makes it worthwhile from the perspective of the employer. Your response should emphasize what it is about the school that makes it an attractive training ground for this employer. You need to talk about your college as the ideal training facility for becoming a _____ with that company.
You might find it best to give a "process answer" such as:
"I originally decided to attend State U. because of its strong general academic reputation and its close proximity to my home, which gave me the opportunity to continue working at my part-time job. During the years I have spent here, I have come to truly appreciate the depth and breadth of the _____ curriculum. It has given me an excellent foundation for becoming an immediate contributor in the _____ field."
Lay on the superlatives, but don't get mushy. You will come to appreciate your time at college later in life, but for now, a few well-chosen words about why it is #1 for you in your career will suffice.
Job Search Information

What To Do If You Are Asked An Illegal Question
The interview is going along smoothly. You are psyched that "this may be the one." And then it happens. Out of nowhere. "Are you considering having children?" Or, "How long has your family been in this country?" Or, "Your people place a high value on that, don't they?" Or, "You've done amazingly well for someone in a wheelchair. How long have you had to use one?"
On the surface the question may seem innocent enough. And most of the time, they are truly asked in innocence. Yet the structure and format of the question is entirely illegal. So what do you do? How do you respond?
First of all, it is important to understand the difference between an illegal question and a criminally liable question. Even though a question or comment may have been stated in an illegal form, it does not necessarily mean that a crime has been committed. There is a difference between criminal liability and civil liability. For there to be criminal liability, it requires establishing a motive or intent. Most illegal questions are asked in ignorance, not with malicious intent. Yet there can still be civil recourse, even when there was no criminal motive or intent.
In our politically correct society, we often cry "foul" at the slightest deviation from the accepted standard. But the reality is that most illegal interview questions are asked in true innocence. Or, better stated, in true ignorance. Ignorance of the law, ignorance of what questions are proper, ignorance of how the information could be used by others in a discriminatory way.
Ironically, most illegal questions are asked when the untrained interviewer is trying to be more friendly and asks a seemingly innocent question about your personal life or family background. Therefore, any attempt by the candidate to assert their constitutional rights will merely throw up the defense shields and will put an end to mutual consideration. Warning lights go on, sirens sound, and the interviewer begins backing down from what may have been an otherwise very encouraging position.
So what is the proper response? The answer is up to you, but my recommendation is to follow one of two courses of action: answer in brief and move on to a new topic area, or ignore the question altogether and redirect the discussion to a new topic area. The interviewer may even recognize the personal misstep and appreciate your willingness to put it aside and go on.
Unless the question is blatantly discriminatory--and yes, blatant discrimination does still take place--your best option is to move on to other things. But if it is blatant and offensive, you have every right to terminate the interview and walk out.
While laws vary from state to state, there are some definite taboo areas with regard to interview questions which employers should avoid. Following is a brief list of some of the questions that employers should not be asking:
 Questions related to birthplace, nationality, ancestry, or descent of applicant, applicant's spouse, or parents
(Example: "Pasquale--is that a Spanish name?")
 Questions related to applicant's sex or marital status
(Example: "Is that your maiden name?")
 Questions related to race or color
(Example: "Are you considered to be part of a minority group?")
 Questions related to religion or religious days observed
(Example: "Does your religion prevent you from working weekends or holidays?")
 Questions related to physical disabilities or handicaps
(Example: "Do you have any use of your legs at all?")
 Questions related to health or medical history
(Example: "Do you have any pre-existing health conditions?")
 Questions related to pregnancy, birth control, and child care
(Example: "Are you planning on having children?")
It should be noted that just because an illegal question has been asked does not necessarily mean a crime has been committed. It is up to a court of law to determine whether the information was used in a discriminatory manner.

Interview question what are your strong points

It is important to prepare in advance for the interview question what are your strong points. If you've already listed your strengths when preparing your CV / resume, coming up with three answers shouldn't be too difficult.
But be careful. The interviewer is asking you to sell yourself, but at the same time, they do not want to hear you being arrogant. And while they may want to know about your personality (if you are over confident they will certainly learn something about you), do remember that this is still an interview situation, so your answers must be relevant to the job in question. In other words, don't get too personal.
So how do you go about answering the interview question what are your strong points? The general recommendation is to prepare at least three answers and to relate them to the organisation and the vacancy. This means you need to tailor your answers. Ensure there is truth in what you say, but do not be too honest, especially it makes you sound like a less than ideal candidate.
Here are some suggested responses and the reasons why they might work in interviews for certain kinds of jobs.
"I am confident and outgoing"
This is a response that says something about your personality, but if you are applying for a role where you need to relate to a lot of people - particularly the public - it will serve your purposes. However, if the vacancy involves consultation, it might be better to say "I have good interpersonal skills", as this implies that you are able to listen to people as well.
"I enjoy a challenge"
Be careful with this. It is an excellent response if the vacancy requires problem solving, or servicing of some kind, working to tight deadlines or project completion. It will obviously not be helpful if the job is less dynamic and involves a larger amount of regular, less exciting duties - the employer might be concerned that you will become bored. You could always qualify it to offer a more balanced response: "I enjoy a challenge, but I'm also happy completing regular tasks." Then it illustrates that you're flexible and responsive to different work situations.
"I'm a strong team leader"
Clearly, this is appropriate if the job involves managing people. It's a good idea to show that you know what leading a team involves (although this will no doubt come up in other questions too). So, "I'm a strong team leader with the ability to motivate others" and "I'm a strong team leader who leads by example" represent stronger answers. Draw on your own understanding of your management skills plus the job description to decide what you'll say here.
"I am ambitious"
This is a very strong answer and you should use it with care. In the wrong situation, it can sound hard-headed and the employer may wonder whether you'll compete too fiercely with your colleagues, or even your superiors. However, in a sales role it might be perfect, especially if you focus your response a little more: "I am ambitious and aim to exceed targets".
"I am dedicated and hard working"
You're on safe ground here, as this can be true whatever your individual working style. It's not the most exciting answer, but when presented alongside two others that are more individual, it should offer reassurance to the interviewer.
"I am a good communicator"
Again, this is a win-win answer. Be prepared to expand, though: specify whether you have strong writing skills, are good at explaining difficult ideas in a simple way, or perform well at important meetings.
"I work well without supervision"
A majority of employers would be pleased to hear this, providing the vacancy is at a level where they'd normally expect you to need a degree of supervision. But be careful not to sound as if you prefer to work without supervision, as this may sound as if you risk coming into conflict with your supervisor or manager. A safer option might be to state "I work well with or without supervision".
"I enjoy learning through my work"
Again, this is a safe answer. The interviewer might then ask how you have done this in the past, so be ready to give details of some hands-on learning or special training you've experienced, and to say why you enjoyed it.
And finally
These examples show that when preparing an answer to the interview question what are your strong points, it is important to consider whether your responses could be taken the wrong way. Put yourself in the interviewer's shoes - you can then ensure that the potential for a negative interpretation is removed.

Networking Interview Questions

2009-06-23T22:04:00.000-07:00

Network engineer interview questions
OSPF
Describe OSPF in your own words.
OSPF areas, the purpose of having each of them
Types of OSPF LSA, the purpose of each LSA type
What exact LSA type you can see in different areas
How OSPF establishes neighboor relation, what the stages are
If OSPF router is stucked in each stage what the problem is and how to troubleshoot it
OSPF hierarchy in the single or multi areas. Cool OSPF behavior in broadcast and nonbroadcast
Draw the diagram of typical OSPF network and explain generally how it works, DR, BDR, election, ASBR, ABR, route redistribution and summarization
STP
How it works and the purpose
Diff types (SSTP, MSTP, RSTP) Cisco - PVST/PVST+
root election
Diff. port stages and timing for convergence
Draw the typical diagram and explain how diff types of STP work
What ports are blocking or forwarding
How it works if there are topology changes
ACLs
What are they
Diff types
Write an example if you want to allow and to deny…
Well-known port numbers (DNS - 53 and etc…)
QOS
What is that
What is the diff b/w L2 and L3 QoS
How it works
Network:
Draw the typical network diagram you have to deal with
explain how it works
What part of it you are responsible
firewall, what is that, how it works, how it is diff from ACLs
What problems with the network you had had and how you solved it.
What are the ways to troubleshoot the network, techniques, commands
network security, ways to achieve it
Switching:
VLANs
STP
How a L2 switch works with broadcast, unicast, multicast, known/unknown traffic
VRRP, GLBP
port monitoring and mirroring
L3 switch, how it works
PIM sparse and dense modes

^Back to Top

Windows admin interview questions
Describe how the DHCP lease is obtained. It’s a four-step process consisting of (a) IP request, (b) IP offer, © IP selection and (d) acknowledgement.
I can’t seem to access the Internet, don’t have any access to the corporate network and on ipconfig my address is 169.254.*.*. What happened? The 169.254.*.* netmask is assigned to Windows machines running 98/2000/XP if the DHCP server is not available. The name for the technology is APIPA (Automatic Private Internet Protocol Addressing).
We’ve installed a new Windows-based DHCP server, however, the users do not seem to be getting DHCP leases off of it. The server must be authorized first with the Active Directory.
How can you force the client to give up the dhcp lease if you have access to the client PC? ipconfig /release
What authentication options do Windows 2000 Servers have for remote clients? PAP, SPAP, CHAP, MS-CHAP and EAP.
What are the networking protocol options for the Windows clients if for some reason you do not want to use TCP/IP? NWLink (Novell), NetBEUI, AppleTalk (Apple).
What is data link layer in the OSI reference model responsible for? Data link layer is located above the physical layer, but below the network layer. Taking raw data bits and packaging them into frames. The network layer will be responsible for addressing the frames, while the physical layer is reponsible for retrieving and sending raw data bits.
What is binding order? The order by which the network protocols are used for client-server communications. The most frequently used protocols should be at the top.
How do cryptography-based keys ensure the validity of data transferred across the network? Each IP packet is assigned a checksum, so if the checksums do not match on both receiving and transmitting ends, the data was modified or corrupted.
Should we deploy IPSEC-based security or certificate-based security? They are really two different technologies. IPSec secures the TCP/IP communication and protects the integrity of the packets. Certificate-based security ensures the validity of authenticated clients and servers.
What is LMHOSTS file? It’s a file stored on a host machine that is used to resolve NetBIOS to specific IP addresses.
What’s the difference between forward lookup and reverse lookup in DNS? Forward lookup is name-to-address, the reverse lookup is address-to-name.
How can you recover a file encrypted using EFS? Use the domain recovery agent.

^Back to Top

Network engineer/architect interview questions
Explain how traceroute, ping, and tcpdump work and what they are used for?
Describe a case where you have used these tools to troubleshoot.
What is the last major networking problem you troubleshot and solved on your own in the last year?
What LAN analyzer tools are you familiar with and describe how you use them to troubleshoot and on what media and network types.
Explain the contents of a routing table (default route, next hop, etc.)
What routing protocols have you configured?
Describe the commands to set up a route.
What routing problems have you troubleshot?
How do you display a routing table on a Cisco? On a host?
How do you use a routing table and for what?
What is a route flap?
What is a metric?
When do you use BGP, IGRP, OSPF, Static Routes?
What do you see as current networking security issues (e.g. NFS mounting, spoofing, one time passwords, etc.)?
Describe a routing filter and what it does.
Describe an access list and what it does.
What is a network management system?
Describe how SNMP works.
Describe the working environment you are currently in, e.g. frequent interruptions, frequent priority shifting, team or individual.
What do you use to write documentation? Editor? Mail reader?
What platform (s) do you currently work on at your desk?
How do you manage multiple concurrent high level projects?
Describe a recent short term stressful situation and how you managed it.
How do you manage a long term demanding stressful work environment?
Have you worked in an assignment based environment, e.g. work request/trouble ticket system, and if so, describe that environment.
Describe what network statistics or measurement tools you are familiar with and how you have used them.
Describe what a VPN is and how it works.
Describe how VoIP works.
Describe methods of QoS.
How does ToS bit work?

^Back to Top

CCNA/Cisco admin interview questions
You need to retrieve a file from the file server for your word processing application, which layer of the OSI model is responsible for this function?
Presentation layer
Application layer
Session layer
Transport layer
Datalink layer
You are working in a word processing program, which is run from the file server. Your data comes back to you in an unintelligible manner. Which layer of the OSI model would you investigate?
Application layer
Presentation layer
Session layer
Network layer
Datalink layer
The IEEE subdivided the datalink layer to provide for environments that need connectionless or connection-oriented services. What are the two layers called?
Physical
MAC
LLC
Session
IP
You are working with graphic translations. Which layer of the OSI model is responsible for code formatting and conversion and graphic standards.
Network layer
Session layer
Transport layer
Presentation layer
Which is the best definition of encapsulation?
Each layer of the OSI model uses encryption to put the PDU from the upper layer into its data field. It adds header and trailer information that is available to its counterpart on the system that will receive it.
Data always needs to be tunneled to its destination so encapsulation must be used.
Each layer of the OSI model uses compression to put the PDU from the upper layer into its data field. It adds header and trailer information that is available to its counterpart on the system that will receive it.
Each layer of the OSI model uses encapsulation to put the PDU from the upper layer into its data field. It adds header and trailer information that is available to its counterpart on the system that will receive it.
Routers can be configured using several sources. Select which of the following sources can be used.
Console Port
Virtual Terminals
TFTP Server
Floppy disk
Removable media
Which memory component on a Cisco router contains the dynamic system configuration?
ROM
NVRAM
Flash
RAM/DRAM
Which combination of keys will allow you to view the previous commands that you typed at the router?
ESC-P
Ctrl-P
Shift-P
Alt-P
Which commands will display the active configuration parameters?
show running-config
write term
show version
display term
You are configuring a router, which prompt tells you that you are in the privileged EXEC mode?
@
>
!
:
#
What does the command “IP name-server 255.255.255.255? accomplish?
It disables domain name lookup.
It sets the domain name lookup to be a local broadcast.
This is an illegal command.
The command is now defunct and has been replaced by “IP server-name ip any”
The following selections show the command prompt and the configuration of the IP network mask. Which two are correct?
Router(config-if)#netmask-format { bitcount | decimal | hexadecimal }
Router#term IP netmask-format { bitcount | decimal | hexadecimal }
Router(config-if)#IP netmask-format { bitcount | decimal | hexadecimal }
Router#ip netmask-format { bitcount | decimal | hexadecimal }
Which layer is responsible for flow control with sliding windows and reliability with sequence numbers and acknowledgments?
Transport
Application
Internet
Network Interface
Which processes does TCP, but not UDP, use?
Windowing
Acknowledgements
Source Port
Destination Port
Select which protocols use distance vector routing?
OSPF
RIP
IGRP
PPP

^Back to Top

Networking and Unix interview questions
What is UTP?

UTP — Unshielded twisted pair 10BASE-T is the preferred Ethernet medium of the 90s. It is based on a star topology and provides a number of advantages over coaxial media:

It uses inexpensive, readily available copper phone wire. UTP wire is much easier to install and debug than coax. UTP uses RG-45 connectors, which are cheap and reliable.

What is a router? What is a gateway?

Routers are machines that direct a packet through the maze of networks that stand between its source and destination. Normally a router is used for internal networks while a gateway acts a door for the packet to reach the ‘outside’ of the internal network

What is Semaphore? What is deadlock?

Semaphore is a synchronization tool to solve critical-section problem, can be used to control access to the critical section for a process or thread. The main disadvantage (same of mutual-exclusion) is require busy waiting. It will create problems in a multiprogramming system, where a single CPU is shared among many processes.

Busy waiting wastes CPU cycles.

Deadlock is a situation when two or more processes are waiting indefinitely for an event that can be caused by only one of the waiting processes. The implementation of a semaphore with a waiting queue may result in this situation.

What is Virtual Memory?

Virtual memory is a technique that allows the execution of processes that may not be completely in memory. A separation of user logical memory from physical memory allows an extremely large virtual memory to be provided for programmers when only a smaller physical memory is available. It is commonly implemented by demand paging. A demand paging system is similar to a paging system with swapping. Processes reside on secondary memory (which is usually a disk). When we want to execute a process, we swap it into memory.

Explain the layered aspect of a UNIX system. What are the layers? What does it mean to say they are layers?

A UNIX system has essentially three main layers:

. The hardware

. The operating system kernel

. The user-level programs

The kernel hides the system’s hardware underneath an abstract, high-level programming interface. It is responsible for implementing many of the facilities that users and user-level programs take for granted.

The kernel assembles all of the following UNIX concepts from lower-level hardware features:

. Processes (time-sharing, protected address space)

. Signals and semaphores

. Virtual Memory (swapping, paging, and mapping)

. The filesystem (files, directories, namespace)

. Pipes and network connections (inter-process communication)

Microprocessor Interview Questions And Answers

2009-06-22T21:59:00.000-07:00

8085 Microprocessor Questions:

1. What are the various registers in 8085? - Accumulator register, Temporary register, Instruction register, Stack Pointer, Program Counter are the various registers in 8085 .
2. In 8085 name the 16 bit registers? - Stack pointer and Program counter all have 16 bits.
3. What are the various flags used in 8085? - Sign flag, Zero flag, Auxillary flag, Parity flag, Carry flag.
4. What is Stack Pointer? - Stack pointer is a special purpose 16-bit register in the Microprocessor, which holds the address of the top of the stack.
5. What is Program counter? - Program counter holds the address of either the first byte of the next instruction to be fetched for execution or the address of the next byte of a multi byte instruction, which has not been completely fetched. In both the cases it gets incremented automatically one by one as the instruction bytes get fetched. Also Program register keeps the address of the next instruction.
6. Which Stack is used in 8085? - LIFO (Last In First Out) stack is used in 8085.In this type of Stack the last stored information can be retrieved first.
7. What happens when HLT instruction is executed in processor? - The Micro Processor enters into Halt-State and the buses are tri-stated.
8. What is meant by a bus? - A bus is a group of conducting lines that carriers data, address, & control signals.
9. What is Tri-state logic? - Three Logic Levels are used and they are High, Low, High impedance state. The high and low are normal logic levels & high impedance state is electrical open circuit conditions. Tri-state logic has a third line called enable line.
10. Give an example of one address microprocessor? - 8085 is a one address microprocessor.
11. In what way interrupts are classified in 8085? - In 8085 the interrupts are classified as Hardware and Software interrupts.
12. What are Hardware interrupts? - TRAP, RST7.5, RST6.5, RST5.5, INTR.
13. What are Software interrupts? - RST0, RST1, RST2, RST3, RST4, RST5, RST6, RST7.
14. Which interrupt has the highest priority? - TRAP has the highest priority.
15. Name 5 different addressing modes? - Immediate, Direct, Register, Register indirect, Implied addressing modes.
16. How many interrupts are there in 8085? - There are 12 interrupts in 8085.
17. What is clock frequency for 8085? - 3 MHz is the maximum clock frequency for 8085.
18. What is the RST for the TRAP? - RST 4.5 is called as TRAP.
19. In 8085 which is called as High order / Low order Register? - Flag is called as Low order register & Accumulator is called as High order Register.
20. What are input & output devices? - Keyboards, Floppy disk are the examples of input devices. Printer, LED / LCD display, CRT Monitor are the examples of output devices.
21. Can an RC circuit be used as clock source for 8085? - Yes, it can be used, if an accurate clock frequency is not required. Also, the component cost is low compared to LC or Crystal.
22. Why crystal is a preferred clock source? - Because of high stability, large Q (Quality Factor) & the frequency that doesn’t drift with aging. Crystal is used as a clock source most of the times.
23. Which interrupt is not level-sensitive in 8085? - RST 7.5 is a raising edge-triggering interrupt.
24. What does Quality factor mean? - The Quality factor is also defined, as Q. So it is a number, which reflects the lossness of a circuit. Higher the Q, the lower are the losses.
25. What are level-triggering interrupt? - RST 6.5 & RST 5.5 are level-triggering interrupts

8086 Interview Questions:
1. What are the flags in 8086? - In 8086 Carry flag, Parity flag, Auxiliary carry flag, Zero flag, Overflow flag, Trace flag, Interrupt flag, Direction flag, and Sign flag.
2. What are the various interrupts in 8086? - Maskable interrupts, Non-Maskable interrupts.
3. What is meant by Maskable interrupts? - An interrupt that can be turned off by the programmer is known as Maskable interrupt.
4. What is Non-Maskable interrupts? - An interrupt which can be never be turned off (ie.disabled) is known as Non-Maskable interrupt.
5. Which interrupts are generally used for critical events? - Non-Maskable interrupts are used in critical events. Such as Power failure, Emergency, Shut off etc.,
6. Give examples for Maskable interrupts? - RST 7.5, RST6.5, RST5.5 are Maskable interrupts
7. Give example for Non-Maskable interrupts? - Trap is known as Non-Maskable interrupts, which is used in emergency condition.
8. What is the Maximum clock frequency in 8086? - 5 Mhz is the Maximum clock frequency in 8086.
9. What are the various segment registers in 8086? - Code, Data, Stack, Extra Segment registers in 8086.
10. Which Stack is used in 8086? - FIFO (First In First Out) stack is used in 8086.In this type of Stack the first stored information is retrieved first.
11. What are the address lines for the software interrupts? -
RST 0 0000 H

RST1 0008 H

RST2 0010 H

RST3 0018 H

RST4 0020 H

RST5 0028 H

RST6 0030 H

RST7 0038 H

12. What is SIM and RIM instructions? - SIM is Set Interrupt Mask. Used to mask the hardware interrupts. RIM is Read Interrupt Mask. Used to check whether the interrupt is Masked or not.
13. Which is the tool used to connect the user and the computer? - Interpreter is the tool used to connect the user and the tool.
14. What is the position of the Stack Pointer after the PUSH instruction? - The address line is 02 less than the earlier value.
15. What is the position of the Stack Pointer after the POP instruction? - The address line is 02 greater than the earlier value.
16. Logic calculations are done in which type of registers? - Accumulator is the register in which Arithmetic and Logic calculations are done.
17. What are the different functional units in 8086? - Bus Interface Unit and Execution unit, are the two different functional units in 8086.
18. Give examples for Micro controller? - Z80, Intel MSC51 &96, Motorola are the best examples of Microcontroller.
19. What is meant by cross-compiler? - A program runs on one machine and executes on another is called as cross-compiler.
20. What are the address lines for the hardware interrupts? -

RST 7.5 003C H

RST 6.5 0034 H

RST 5.5 002C H
TRAP 0024 H

21. Which Segment is used to store interrupt and subroutine return address registers? - Stack Segment in segment register is used to store interrupt and subroutine return address registers.
22. Which Flags can be set or reset by the programmer and also used to control the operation of the processor? - Trace Flag, Interrupt Flag, Direction Flag.
23. What does EU do? - Execution Unit receives program instruction codes and data from BIU, executes these instructions and store the result in general registers.
24. Which microprocessor accepts the program written for 8086 without any changes? - 8088 is that processor.
25. What is the difference between 8086 and 8088? - The BIU in 8088 is 8-bit data bus & 16- bit in 8086.Instruction queue is 4 byte long in 8088and 6 byte in 8086.

________________________________________________________________________

*** People who feel good about themselves - Produce good results ***

Regards,

Sachchidanand Singh

Behavioral Interview Questions

2009-06-20T23:45:00.000-07:00

Behavioral questions can be difficult if you are not prepared. Always try to
be conscious about what the recruiter is trying to find out about you by asking you a particular question. Setting up a mock interview with the MIT Careers Office is an excellent way to practice. Here are some examples:

Adaptability:
Tell me about a time when you had to adjust to a classmate’s or colleague’s working style in order to complete a project or achieve your objectives.

Analytical Skills/Problem Solving
Tell me about a situation where you had to solve a difficult problem. What did you do? What was your thought process? What was the outcome? What do you wish you had done differently?

Communication:
What is your typical way of dealing with conflict? Give me an example.
Give me an example of a time when you were able to successfully communicate with another person even when that individual may not have personally liked you (or vice versa). How did you handle the situation? What obstacles or difficulties did you face? How did you deal with them?

Creativity:
Tell me about a time when you had to use your presentation skills to influence someone's opinion. Tell me about a problem that you’ve solved in a unique or unusual way. What was the outcome? Were you happy or satisfied with it?

Decision Making:
Tell me about a difficult decision you've made in the last year.
Describe a situation where you have had to overcome a problem or obstacle in order to move forward with something. What did you do?
Tell me about a time when you had to make a decision without all the information you needed. How did you handle it? Why? Were you happy with the outcome?

Flexibility:
Give me a specific example of a time when you had to conform to a policy with which you did not agree. Describe a time when you put your needs aside to help a co-worker understand a task. How did you assist them? What was the result?

Goal Setting:
Give me an example of a time when you set a goal and were able to meet or achieve it.
What do you consider to be your greatest achievement so far and why?
Tell me about a goal that you set that you did not reach. What steps did you take? What obstacles did you encounter? How did it make you feel?

Iniative:
Describe a time when you anticipated potential problems and developed preventive measures.
What tricks or techniques have you learned to make school or a job easier, or to make yourself more effective? How did you learn that?
Describe a situation where you have had to use your initiative to solve a problem. What did you do?
What was the best idea you came up with during your professional or college career? How did you apply it?
Give me an example of a time when something you tried to accomplish and failed.
Give me an example of when you showed initiative and took the lead.

Integrity/Honesty:
Tell me about a time when you missed an obvious solution to a problem.
Tell me about a time when you were forced to make an unpopular decision.
Tell me about a time you had to fire a friend.
Describe a time when you set your sights too high (or too low).
Tell of the most difficult customer service experience that you have ever had to handleperhaps an angry or irate customer. Be specific and tell what you did and what was the
outcome.
Tell me about a time when you had to go above and beyond the call of duty in order to get a job done. Give a specific example of a policy you conformed to with which you did not agree. Why?

Leadership:
Give me an example of a time when you motivated others.
Tell me about a time when you delegated a project effectively.
What has been your experience in giving presentations to small or large groups? What has been your most successful experience in speech making?
Tell me about a team project when you had to take the lead or take charge of the project?
What did you do? How did you do it? What was the result?

Interpersonal Skills:
Give me an example of a time when you used your fact-finding skills to solve a problem.
Give me a specific example of a time when you used good judgment and logic in solving a problem.
Describe a situation in which you were able to use persuasion to successfully convince someone to see things your way.
Give an example of when you had to work with someone who was difficult to get along with. How/why was this person difficult? How did you handle it? How did the relationship progress?

Planning and Organization/Time Management:
How do you determine priorities in scheduling your time? Give examples.
Describe a time in school when you had many projects or assignments due at the same time. What steps did you take to get them all done?
Tell me about a time when you had too many things to do and you were required to prioritize your tasks.
How do you prioritize projects and tasks when scheduling your time? Give me some examples.

Teamwork:
Tell me about a time you were able to successfully deal with another person even when that individual may not have personally liked you (or vice versa).
Tell me about a recent situation in which you had to deal with a very upset customer or co-worker.
Describe a situation where you have had to work as part of a team to achieve a result. What was your role in this?
Describe a situation where others you were working with on a project disagreed with your ideas. What did you do?

Introduction to Programming

2008-12-11T04:25:00.000-08:00

Computer Systems
A computer system consists of all the components (hardware and software) used to execute the desires of the computer user. Hardware is the electronic phys- ical components that can retrieve, process and store data. It is generally broken down into five basic components:
Central Processing This is the unit where programs are executed. It
Unit (C.P.U.) consists of the control unit, which oversees the
overall operation of program execution and the
A.L.U. (Arithmetic/Logic Unit), which performs the
mathematical and comparison operations.
Main Memory The area where programs and data are stored for
use by the CPU
Secondary Storage The area where programs and data are filed (stored)
for use at a later time
Input Devices The devices used to get programs and data into the
computer (e.g., a keyboard)
Output Devices The devices used to get programs and data from the
computer (e.g., a printer)
Software consists of a sequence of instructions given to perform some pre-defined task. These labs concentrate on the software portion of a computer system.
Introduction to Programming
A computer program is a series of instructions written in some computer lan- guage that performs a particular task. Many times beginning students concentrate solely on the language code; however, quality software is accomplished only after careful design that identifies the needs, data, process and anticipated out- comes. For this reason it is critical that students learn good design techniques before attempting to produce a quality program. Design is guided by an algo- rithm, which is a plan of attacking some problem. An algorithm is used for many aspects of tasks, whether a recipe for a cake, a guide to study for an exam or the specifications of a rocket engine.

Problem example: Develop an algorithm to find the average of five test grades.

An algorithm usually begins with a general broad statement of the problem.
Find the average of Five Test Grades
From here we can further refine the statement by listing commands that will accomplish our goal.
Read in the Grades Find the Average Write out the Average

Each box (called a node) may or may not be refined further depending on its clarity to the user. For example: Find the Average may be as refined as an experienced programmer needs to accomplish the task of finding an average; however, students learning how to compute averages for the first time may need more refinement about how to accomplish the goal. This refinement process continues until we have a listing of steps understandable to the user to accomplish the task. For example, Find the Average may be refined into the fol- lowing two nodes.
Total=sum of 5 grades Average=Total/5

Starting from left to right, a node that has no refinement becomes part of the algo- rithm. The actual algorithm (steps in solving the above program) is listed in bold.
Find the Average of Five Test Grades
Read in the Grades
Find the Average
Total = sum of 5 grades Average = Total / 5
Write Out the Average
From this algorithm, a program can be written in C++.
Translation Process
Computers are strange in that they only understand a sequence of 1s and 0s. The following looks like nonsense to us but, in fact, is how the computer reads and executes everything that it does:
10010001111010101110010001110001000
Because computers only use two numbers (1 and 0), this is called binary code. can imagine how complicated programming would be if we had to learn this very complex language. That, in fact, was how programming was done many years ago; however, today we are fortunate to have what are called high level languages such as C++. These languages are geared more for human understanding and thus make the task of programming much easier. However, since the computer only understands low level binary code (often called machine code), there must be a translation process to convert these high level languages to machine code. This is often done by a compiler, which is a software package that translates high level

languages into machine code. Without it we could not run our programs. The fig-
ure below illustrates the role of the compiler.
High Level Low Level Code

Compiler

Language Code
(Object Code)

(Source Code)

The compiler translates source code into object code. The type of code is often reflected in the extension name of the file where it is located.
Example: We will write source (high level language) code in C++ and all our file names will end with .cpp, such as:
firstprogram.cpp secondprogram.cpp
When those programs are compiled, a new file (object file) will be created that ends with .obj, such as:
firstprogram.obj secondprogram.obj
The compiler also catches grammatical errors called syntax errors in the source code. Just like English, all computer languages have their own set of grammar rules that have to be obeyed. If we turned in a paper with a proper name (like John) not capitalized, we would be called to task by our teacher, and probably made to correct the mistake. The compiler does the same thing. If we have something that violates the grammatical rules of the language, the compiler will give us error messages. These have to be corrected and a grammar error free program must be submitted to the compiler before it translates the source code into machine language. In C++, for example, instructions end with a semicolon. The following would indicate a syntax error:
cout << "Hi there" << endl
Since there is no semicolon at the end, the compiler would indicate an error, which must be corrected as follows:
cout << "Hi there" << endl;
After the compile process is completed, the computer must do one more thing before we have a copy of the machine code that is ready to be executed. Most programs are not entirely complete in and of themselves. They need other mod- ules previously written that perform certain operations such as data input and out- put. Our programs need these attachments in order to run. This is the function of the linking process. Suppose you are writing a term paper on whales and would like a few library articles attached to your report. You would go to the library, get a copy of the articles (assuming it would be legal to do so), and attach them to your paper before turning it in. The linker does this to your pro- gram. It goes to a “software library” of programs and attaches the appropriate code to your program. This produces what is called the executable code, generated in a file that often ends with .exe.
Example: firstprogram.exe secondprogram.exe

The following figure summarizes the translation process:

firstprogram.cpp
Compiler
firstprogram.obj
Library Linker

firstprogram.exe

Source Code
(High Level Language
such as C++)
Compiler translates source code into object code.
The .obj file contains a translation of the source code.
Linker links library code with the object code to produce the .exe file.
The .exe file is executable.

Once we have the executable code, the program is ready to be run. Hopefully it will run correctly and everything will be fine; however that is not always the case. During “run time”, we may encounter a second kind of error called a run time error. This error occurs when we ask the computer to do something it cannot do. Look at the following sentence:
You are required to swim from Naples, Italy to New York in five minutes.
Although this statement is grammatically correct, it is asking someone to do the impossible. Just as we cannot break the laws of nature, the computer cannot violate the laws of mathematics and other binding restrictions. Asking the com- puter to divide by 0 is an example of a run time error. We get executable code; however, when the program tries to execute the command to divide by 0, the pro- gram will stop with a run time error. Run time errors, particularly in C++, are usu- ally more challenging to find than syntax errors.
Once we run our program and get neither syntax nor run time errors, are we free to rejoice? Not exactly. Unfortunately, it is now that we may encounter the worst type of error: the dreaded Logic error. Whenever we ask the computer to do something, but mean for it to do something else, we have a logic error. Just as there needs to be a “meeting of the minds” between two people for meaningful communication to take place, there must be precise and clear instructions that gen- erate our intentions to the computer. The computer only does what we ask it to do. It does not read our minds or our intentions! If we ask a group of people to cut down the tree when we really meant for them to trim the bush, we have a communication problem. They will do what we ask, but what we asked and what we wanted are two different things. The same is true for the computer. Asking it to multiply by 3 when we want something doubled is an example of a

logic error. Logic errors are the most difficult to find and correct because there are no error messages to help us locate the problem. A great deal of program- ming time is spent on solving logic errors.
Integrated Environments
An integrated development environment (IDE) is a software package that bun- dles an editor (used to write programs), a compiler (that translates programs) and a run time component into one system. For example, the figure below shows a screen from the Microsoft Visual C++ integrated environment.
Other systems may have these components separate which makes the process of running a program a little more difficult. You should also be aware of which Operating System you are using. An Operating System is the most important software on your computer. It is the “grand master” of programs that interfaces the computer with your requests. Your instructor will explain your particular sys- tem and C++ environment so that you will be able to develop, compile and run C++ programs on it.
A S S I G N M E N T
Fill-in-the-Blank Questions
1. Compilers detect errors.

2. Usually the most difficult errors to correct are the errors,

since they are not detected in the compilation process.
3. Attaching other pre-written routines to your program is done by the
process.
4.
code is the machine code consisting of ones and zeroes

that is read by the computer.
5. Dividing by zero is an example of a error.

Lesson 1A 7
Learn the Environment That You Are Working In
The following information may be obtained from your instructor.
1. What operating system are you using?
2. What C++ environment are you working in?
3. If you are not working in an integrated environment, what are the com- pile, run and edit commands that you will need?
L E S S O N 1 A
Your instructor may assign either Appendix A or Appendix B depending on your environment. Appendix A is for labs using Visual C++ and Appendix B is for labs using UNIX. If you are using an environment other than these two, your instructor will give you instructions for this first lesson and ask you to complete Lab 1.1 below.
LAB 1.1 Opening, Compiling and Running Your First Program
Exercise 1: Logon to your system based on your professor’s instructions.
Exercise 2: Bring in the firstprog.cpp program from the Lab 1 folder.
Exercise 3: Compile the program.
Exercise 4: Run the program and write what is printed on the screen.
The code of firstprog.cpp is as follows:
// This is the first program that just writes out a simple message
// Place your name here
#include // needed to perform C++ I/O
using namespace std;
int main ()
{
cout << "Now is the time for all good men" << endl;
cout << "To come to the aid of their party" << endl;
return 0;
}

LAB 1.2 Compiling a Program with a Syntax Error
Exercise 1: Bring in program semiprob.cpp from the Lab 1 folder.
Exercise 2: Compile the program. Here we have our first example of the many syntax errors that you no doubt will encounter in this course. The error message you receive may be different depending on the system you are using, but the compiler insists that a semicolon is missing somewhere. Unfortunately, where the message indicates that the problem exists, and where the problem actually occurs may be two different places. To correct

the problem place a semicolon after the line cout << "Today is a great day for Lab".
Most syntax errors are not as easy to spot and correct as this one.
Exercise 3: Re-compile the program and when you have no syntax errors, run the program and input 9 when asked. Record the output.
Exercise 4: Try running it with different numbers. Record your output.
Do you feel you are getting valid output?
The code of semiprob.cpp is as follows:
// This program demonstrates a compile error.
// Place your name here
#include using namespace std;
int main()
{
int number; float total;
cout << "Today is a great day for Lab"
cout <<>> number;
total = number * 2;
cout << total << " is twice the number you typed" << endl;
return 0;
}
LAB 1.3 Running a Program with a Run Time Error
Exercise 1: Bring in program runprob.cpp from the Lab 1 folder.
Exercise 2: Compile the program. You should get no syntax errors.
Exercise 3: Run the program. You should now see the first of several run time errors. There was no syntax or grammatical error in the program; however, just like commanding someone to break a law of nature, the program is asking the computer to break a law of math by dividing by zero. It cannot be done. On some installations, you may see this as output that looks very strange. Correct this program by having the code divide by 2 instead of 0.
Exercise 4: Re-compile and run the program. Type 9 when asked for input. Record what is printed.

Lesson 1B 9
Exercise 5: Run the program using different values. Record the output. Do you feel that you are getting valid output?
The code of runprob.cpp is as follows:
// This program will take a number and divide it by 2.
// Place your name here
#include using namespace std;
int main()
{
float number; int divider;
divider = 0;
cout << "Hi there" << endl;
cout << "Please input a number and then hit return" <<>> number;
number = number / divider;
cout << "Half of your number is " << number << endl;
return 0;
}
L E S S O N 1 B
LAB 1.4 Working with Logic Errors
Exercise 1: Bring in program logicprob.cpp from the Lab 1 folder. The code follows.
// This program takes two values from the user and then swaps them
// before printing the values. The user will be prompted to enter
// both numbers.
// Place your name here
#include
using namespace std;

int main()
{
float firstNumber; float secondNumber;
// Prompt user to enter the first number.
cout << "Enter the first number" <<>> firstNumber;
// Prompt user to enter the second number.
cout << "Enter the second number" <<>
cin >> secondNumber;
// Echo print the input.
cout << endl << "You input the numbers as " << firstNumber
<< " and " << secondNumber << endl;
// Now we will swap the values.
firstNumber = secondNumber; secondNumber = firstNumber;
// Output the values.
cout << "After swapping, the values of the two numbers are " <<>
return 0;
}
Exercise 2: Compile this program. You should get no syntax errors.
Exercise 3: Run the program. What is printed?
Exercise 4: This program has no syntax or run time errors, but it certainly has a logic error. This logic error may not be easy to find. Most logic errors create a challenge for the programmer. Your instructor may ask you not to worry about finding and correcting the problem at this time.

Lesson 1B 11
LAB 1.5 Writing Your First Program (Optional)
Exercise 1: Develop a design that leads to an algorithm and a program that will read in a number that represents the number of kilometers traveled. The output will convert this number to miles. 1 kilometer = 0.621 miles. Call this program kilotomiles.cpp.
Exercise 2: Compile the program. If you get compile errors, try to fix them and re-compile until your program is free of syntax errors.
Exercise 3: Run the program. Is your output what you expect from the input you gave? If not, try to find and correct the logic error and run the pro- gram again. Continue this process until you have a program that produces the correct result.

Kanbay Placement Test, Papers and Procedure

2008-10-22T22:34:00.000-07:00

Kanbay Exam conducted on 2nd Aug 2003.The Selection Process will have Written Test, GD & Interview. : GD : You are each given a role to play..u have to justify why yours is best suited to the question and final reach a general consensus. Tps: Be cool...... Listen carefully..... n talk..talk what u want but do say something.. don't be too aggressive nor too submissive n yes..don't address any one member only.Interview: They also ask puzzles like:

3 switches in the bottom floor, 3 bulbs on top floor..u can go upstairs only once.find out which switch is for which bulb. then , out of a group of 10 matchboxes..each with 10 matchsticks of 10 gms. if one weighs 9 gms..how will u find it in minimum no. of weighings..

Be confidant and preapre ques like why should we take u?

what are ur assets, hobbies, the last book that read , the last film that u saw ..name of characters in that film etc..

Few questions of KANBAY 2003,aug 1st,in KITS college Bhubaneswar

I am sending all those which I could remember,all were multiple choices..they said cut-off was 12 but it was actually 15 per section.

It had two sections ,LOGIC AND MATHS,cut of in each secn 12,each had

30 questions,1 mark each

LOGIC

1.problems on permutation combinations like BANANA,…..

2.if april 18 was Wednesday in 1998,when is april 18 in 1999?

3.if B has its shadow falling on right side early morning ,then in

which direction is he facing?

4.age problems like…….Mothers age was twice the the age of son two years ago.after how many years will she be three times her sons age??

5.analyzing data interpretations and around 4-5 questions based on tat

6.a Guy has some chocolates with him he distributes them equally among 5 people and remaning with him is 3.if he distributes them equlay among 7 people remaining is 5 with him. Which of them isn't is possible no.of chocolates he had??53,208……….

7.4-5 problems on profit And loss

8.in a test moti,ganesh,manali,rupali,raj, appear,according to the scores moti is not the leats scorer but is lower to raj………….who occupies the 2 nd postion is the order?

9.mr a meets mrs b.mr b is has a son and daughter .son is moti and is married and has a son .mrs moti is mr a mother .how is mr a related to mr b??

10.ram buys some dozens of apples and peaches .their price ratio is 5:7.if the price of 1 dozen of peach is is rs 9,how many dozens of apple did he bring?

11.problems based on relationships like those in rs aggarwal

12.in a queue A is is in 7 th positon from the left and B is 9 position from the left .if they switch positions A is in 11 th position ,find the total people in the row??

MATHS

1. S 1=={1,2,3,4}, S 2 =={A,B.C……….Z},S 3=={……………},(S1*S2)U S3==?

2. IF 5*4=,8*7=B,how much is 6*9==

3. 4 to 5 questions on simplifying complex nos. equations

4. sphere of radius 4.5 cm is divide in three spheres ,two have radius 1.5 and 2 cm,find the other ones??

5. if COMPLEX == 81,and……………….how much is ANALYSE==?? 2-3

6. two taps a and b fill up a cistern in 2 and3 hrs ,at wat time should b be clsed if the tank cistern is filled up in 17 minutes??

7. a doctor checks 5 patients every 3 hrs with abreak of 10 minutes between each two check ups.how many he patients he checks in 10 hrs and 15 minutes??

8. no. of diagonals friends if vertices of a octagon are joined??

9. an equilateral triangle is formed by joining the centers of sides of a equilateral triangle.wat is the ratio of area ,s of both the triangles??

10. A can finish the work in 3 days , B can finish the work in double efficiency,can finish with equal efficiency of both A and B.if all work together within how many days will they complete the work?

11. A.B,C,D stand at the edges of a square.they start moving along the square sides.after clockwise rotation where will each be??

12. if 1 is stop,2 is run,3 is go,4 is wait,5 is walk,then would be the next stage if the following pattern 5 5 4 3 2 1 ……………………..

4 1 2 2 3 1 ?

13. C remembers meeting B after 14 but before 18 ,but D remembers meeting B after 16 but before 18.when did both meet B??

14. avg age of boys in a class is 12.when the age of teacher is included it is 13.wat could be the age of teacher? 35 , 45,53,50

written test consists of 2 sections(apptitude and logical reasoning)

of 30 quest. each and cut off is 12 each.and the total time is 1 hour.

1. which is greater (1000)pow1001 and 1001pow999

2.one container contains milk and water in the ratio 3:7 and the other contains 8:11,in what ratio these two containers is to be mixed so that the ratio of milk and water is 4:5.

3. there are two simple problems on time and work. 4.four points will be given and you have to frame two st. line eq.s in such a way that their point of interesection lies in one of the four options.

5.there are two to three problems on profit and loss which are little bit time taking ,so i didn't attempt.

6.a series of nos will be given where the ans can be found by observing the diff bet two consecutive nos

logical reasoning

1. air is cloud

cloud is rain

rain is water

wateris sand so what is cloud? ans :sand

2. one quesion on relations

3. trafic: signal ans : river :dam

4. two more quesions are there 5. dsoighkl now if lk-(?)-sd , find letter in 4th place

6. some mammals are donkeys

allbuffalos will have horns

based on this 3 quesions r ther

7. two more r simmilar to above

8. to decode the noise :- H.................M ANS:C

9.cube is of size 5*5*5 .every side has been coloured. it is divided into 125 equal parts.

1) what is the no. of parts having only one side coloured - 54.

2) no. of parts having two sided coloured 36.

3) having no side coloured - 27.

10.find the no. of occurrence of T which is immediately preceded y P and no

timmediately followed by S in some series for eg. (TPTSTRUST.......) ans - 3

11.Four persons are there wearing different coloured shirts eg. A,B,C,D

wearing blue ,green, red, yellow.

Now, 1. A cannot wear yellow.

2. B can wear blue or green.

3. C /D is wearing yellow.

You have to find who is wearing which coloured shirt.

12.Find the root of 4a2+b2+c2+4ab-2bc-4ac Ans: 2a+b-c.Two

pipes can fill a tank in 5 hrs and 8 hrs. while a hole can empty it in 40 hrs.

What will be the time taken to fill if each operate at a time.

Soln: 1\x == 1\5 + 1\8 - 1\40

13.A can beat B by 20 mts. While C can beat B by 40 mts. In a race of 100

mts. By how much can C beat A? Soln: 75 mts.

14.If u start your journey 30 minutes late , u have to increase your speed by 250kms\hr. to cover up 1500 kms. In same time. What is your usual speed? Ans: 750kms\hr.

15.For a circle, radius is inc. by some % , find net change in area?

gd topics are

lov marriages r arranged marages

r tv serials helpful

R.S. AGRAWAL .

Go thru 1>blood relation.

2>analogy.

3>coding ?decoding.

4> puzzles.

Qus related to these topics were asked .

1)complete the series 600 ,180 ,54,

ans===.2( options were given)

2) some doctors are fool john is a doctor

a> john is a fool.b>all

b> fools are doctors from this you have to draw the conclusion given in the

options such as only a is true only b is tru both are tru or none is tru.

3> similar question like2

some teacher are female.a is female.

a>she is a teacher.

b>all females are teacher.

4>river : dam :: traffic:

ans.==== signal

other qus related to analogy were there .go thru R.S.AGRAWAL.

other qus were from the lbood relations .

some qus were from puzzles .

a,b,c,d,e,f,g are 7 epople seating on a wall facing

towards north.b is not at the end.c and d can not

seat together .

qus like this were there .

mathematical qus / aptitudes.

1)a sum of money doubles in 5 years by simple interest . how much time it will take for 300 to become 2400.

a>40 years b>25 years c>35 years d> 20 years.

2)if length of a rectangle is made 4 less and breadth is increased by 3 then the resultant square ?s area is equal to the rectangle. What is the perimeter of the rectangle .

3)what will be the no. at ? position below

51 11 61

64 30 32 35 ? 43

4>the L.C.M. and H.C.F. of two nos. are 84 and 21

and the nos. are in the ratio of 1:4 ,. Find the nos.

ans==== 21, 84

5)find the volume of the hemisphere having radius 2m .

6>problem based on compound interest were asked . so see the formula of compound interest.

7)a train goes from a to b. if it travels with 50 km/s then it is late by 10 mins. When it travels with30km/s then it bis late by 50 mins. Fi nd the distance between a and b.

8)a river is 8 m deep and 150 m wide.river?s speed is 5 km/s.

find the volume of water passed in one min.(1 m cube =1000 c.c.)

9) fin dthe equation of the st. line passing thru the intersection of the two lines and two other lines.(equ. Were given)

10) a man sells 20 mangoes + 15 oranges ath the same price as 15 mangoes+20 oranges. Ho would judge which is costlier .

11) a graph was given representing joint venture in the years. An dquestion related to the graph were asked such as A)in which year there was max. change.(ans. Was in the

last year)

12)A is counting the no from 1 to 32 and b from 32 .A is counting the odd no. only .both?s speed is same. What will be the number which will be pronounced by A

& B together. ( ans . aws none of these )but confirm yourself .

13) in the word ?DISTURBANCE? 1st is replaced by last 2nd is replced by 10th , 3rd is by 9th and so on. Which will be the next to ?T?.

14)GIVEN if x/y==3/5. if 1 is added to num . and 1 is subtracted from denominator then ratio ==5/7. find the number.

15)there are 5 black and 9 white balls .if one ball is drawn then find the probability of being white.

16)Avg. age of 5 children =.a child of 5 year age dies.after 4 years what will be the avg. age.

17)three nos. are given the product of first and last is equal to the square of the middle. Find the nos.(options were given) ans.== 10, 20, 40)

18) a rectangle was having length 100 m breadth 60 m. there is a road of 5m wide on each side of the rectangle . find the area of the road.

19) fir no. is the double of 2nd and ½ of the 3rd .(ans=H,24,96)

20) a girl cuts a cake in two halevs. One half is again cut into six equal parts . wt. Of the smaller one was 20 gms. Fin the wt. Of the whole cake.(ans=240gms.)

21)other question was based on the relative speed in the river . i.e. a person first goes upstream then down stream . river?s speed was given .also the diff. Of time was

given . find the speed of the man.

22) ravana speed is 5000 km/s when going towards the heaven. The distance == 75000. ravana has traveled 2 mins. When god?s messenger reaches the earth . Rama told him

to go back. The speed of the god?s messenger =`00 km/s. By how much he will increase or decrease his speed so that he and Ravana reaches exactly at the same time.

23) a man sells a product by giving 10% reduction on it .in spite of this he gets 10% profit . on a product of 330 rs. Original price What will be the buying price.

SECTION A) APTITUTE
1) day:night:: then
a) man:woman
b) spring:summer
c) light : dark
2)if BOMBAY = MYMYMY
then code of .......
ans) choose every third alphabet
3) 5 * 4 = 12
and 8* 7 =42
then 9* 6 = ?
solution (9-2)*6 =
4).if a certain money becomes twice in 5 years(simple interest).then the 300 rs. will become 2400 at the same rate in how many years........ ans 35 year
5)after giving 35.66% discount. a saler makes a loss of 11.11 rs..............
6).there is a number when diveded by 5 gives a remainder 3 and when divede by 7 gives a
remainder of 5 Ans is 33.
7).a boat is going along the stream and returning in the opposite direction of stream it travels
10 km along stream.the sppeed of stream is 3 km/hr,then find the speed of boat.

9).A and B runing around a circle of perimeter of 1200meter(may be differ).A is runing at 210
meter/minute and B is running 190 metre/minute in oppsite direction to each other.at
wich time they will meet. ans) 3 mins
10) A person goes to the house of Sita who is the neighbour of Gita. Amar married with Anita who is the
sister of Sita. Ashu is the father of Amar.

(a)What is the relation between Sita and Amar?
(b) What is the relation between Amar and Gita?
11) what is the day on 12 january 1979 ?
12).If GEN = 9 , ABOUT = 15 then GENERAL = ? solu. 3* 3 =9 , 5*3=15,so 7 *3= 21

13).A is richer than B. B is richer than C. C is richer than D. D is richer than E. Then who is
the middle of this relation.

14)A,Band C. B is as younger than A as b is as older than C if A and C age sum is 80 .then age of B is
15)A mother 1 year back is 4 times her son age .after 6 years she is 3 times her son age.if the present age of son is 20.find his mother age.
SECTION B) MATHS
1) s1 = { 1,2,3.......,20}
s2 = { a,b,c,d}
s3 = { b,d,e,f } then the number of element in (s1*s2 )U ( s1* s3) ans) 120
2)a graph was given and three question was asked on it.
3) | z-2|square + |z-1| = constant . this represent what a) circle b) ellipse c) parabola d) none
4)(4+6w+4w*w)cube - (2+4w+2w*w)square = ? where w is the complex root of unity
5) A contractor have to finish a road in 200.He employed 140 worker for 60 days and gets one-fourth of work done .find the addition number of worker is to be employed to complete the work in given
time. ans ) 120 worker (check)
6)there are two pipe ,one fill the tank in 12 hours and other fill in 32 hours .After how long the first pipe is to be closed so as to fill the tank in 16 hours.

7)A sphere is 3cm in radius .It was melted in three sphere out of which one is 1.5 cm radius and other is 2 cm radius .Find the radius of third sphere
8)A refrigator has dimension 6 x 8 x 2 cmcube.how many cube of 2cm square can be put into it.
9)In a equilateral triangle the mid point of its side is connected and the process was repeated one more time .find the ratio of inner triangle to the outermost triangle ans) 1: 16
10) A,B,C,D,E are in arithmatic progression.what is the value of 4A -6B +4C-.......+E. ans) zero
11) A train's to traverse between A &B. If it travels by 50Kmph it got late by 10min If it travels by 36Kmph it got late by 50 min. Find out the speed of the train.

12) I boy's to buy a bike whose cost is 75000. His fatherv gave him 1.5 times what he
can spend and his financial provider gave him 4 time of his father contribution. Find out the Rs. given by his father.
the topic given in GD was 1) iraq war 2) Role model ( ideal )

GD TOPICS ASKED: LOVE MARRIGE VS ARRANGE MARRIGE, IRAQ WAR, kUINKI SAAS BHI KABHI BAHU THI AND KHANI GHAR GHAR KI( TV SERIALS). SEC-1
1.IF rose code as 6786 hot coded as 879
then search will code as in this q there is one no. is assigned t each letter.so take search and
letter by letter see the given condition.
2.600,180,54........... complete the series.
3.sedane:pain :: solace:........ ans: grief.
4.play:director :: news ans: editor.
5.river:dam :: traffic (a)signal (b)motin (c)vehicle (d)
6.find the greatest no. (a)half 50%of 50 (b)3times 40%of 40 see the obtion & place 3times 40% of 40 blindly.
7.find the compound interest of 1000 rs. at the rate of 5% p.a. for 15 years.
8.find the greatest of 1000power of 1000,1001power of 999
9.product of two no is constt. if one no. is increased by 50% then other no is decreased how much.
ans: 33.3
10.l.c.m & h.cf of two no is 84 & 21 respectively and the ratio of these two no is 1:4 find the gretest no
ans: 84 place blindly.
11.if x is 90% of y then y is how much % of x. 12.the cost of 15 apples & 20 mangoes is much as equal to the 15 mangoes & 20 apple then what is the relation between their cost.. (a)apple is as much equal as mangoes. place blindly (a) obtion.
13.there r 20 men and 5 women then how much maximum couple can be made.....
ans: 20c1*5c1=100. place 100 blindly.
14.a bag contains 8 white and 6 black balls find the prob. of drawing a white ball....
ans: 4/7 place blindly.
15.if numerator is less than 2 by denominator and then if 1 is subtract from the numerator and 1 is added to the denominator then the ratio becomes half what is the no..... ans: 5/7 place blindly.
16.if a certain money becomes twice in 5 years.then the 300 rs. will become 2400 at the same rate in how
many years........

17.if the average of three numbers is 135.and the difference between others is 25 then find the
lowest no.
18.if the thrice of three consecutive odd no is equal to the more three of twice the last no.then
find the 3rd (largest odd no). ans: 11.
19.there are 5 questions in each of the two section.three questions must be attempt for passing the exam how many ways a student will choose the question ans: 100 place blindly.
20.if the lenght of the rectangle is decreased by 4 and breath is increased by 3.then it becomes sqaure
whose areas is equal to that of rectangle.what is the perimeter of the original rectangle.
21.there is a hemisphere of radius of 2 cm how much litre will be occupied in the hemisphere.
given 1 litre= 1000 cubic cm.

22.there is a water tank which has enough water to be consumed in 60 days.if there is a leakage
water stays there for 40 days.if there are more similar leakage then how lomg water will consumed.
23.a man saves money 1000 in each year.and he gives this amount at the end of year for the compound interest at the rate of 5% how much he will save after 25 years.

24.after giving 35.66% discount. a saler makes a loss of 11.11 rs.

25 there is an intersection question cannot remember it but the answer is b
26.the sides of a rectangle is 100 cm and 60 cm if there is a path of 5 cm around the rectanle.it is
included in that given rectangle.find the area of that path.......
27.there is a number when diveded by 5 gives a remainder 3 and when divede by 7 gives a
remainder of 5 Ans is 33.
Q28.a train when travelling from 2 station A and B when travelling a speed of 50km/hr is late by 10min,
and when travelling at 30km/hr arrives a late by 50min. Find the diatance.
29.rational no. is a......... ans: real no. place blindly.
30.a boat is going along the stream and returning in the opposite direction of stream it travels
10 km along stream.the sppeed of stream is 3 km/hr,then find the speed of boat.
31.a boy leaves his home 15 minute before his shedule time. he takes 10 minutes to reach the bus stop.he arrive at the stop at 8:40 am when he leaves the home.
32.A and B runing around a circle of perimeter of 1200meter(may be differ).A is runing at 210 meter/minute and bB is running 190 metre/minute in oppsite direction to each other.at wich time they
will meet.

33.a boy start to count from 32 in the descending order.and another boy start counting from 1 at the
same time and he count only the odd no.then find which no they will count at the same time.
there were 5 questions on syllogism.
if inference is true then A is right
if inference is false then B is right
if inference is probably true then c otherwise D
34.all the wives are women she is women.
inference: she is wife
35.some of the teachers are fool. A is a teacher.
inference: A is a fool.
36.there is a ladder and 4 persons (A,B,C,D) on the ladder. A is further up than B and C.
D is further up than A.Which is third from the bottom of the ladder? Ans: person A.
37.A person goes to the house of Sita who is the neighbour of Gita. Amar married with Anita who is the sister of Sita. Ashu is the father of Amar.(a) What is the relation between Sita and Amar?
(b) What is the relation between Amar and Gita?
38.In an elevator either 12 adults or 20 children can go. If 15 children already occupied the
space , how many adults can go with children? ans: 3
39.Amit's D.O.B. is 3rd March 1980. Amit is four day's older than Sumit. The Republic Day of 1980
is Thrusday. What is the day of Sumit's D.O.B.?
40.A complete a race of 120m taking 4sec less than B. B takes one sec less than C. How much time
taken by A to complete the race?
41.A person pointing towards a lady says She is the only sister of my father. Find the no. of
childs of grandfather? ans: can't say
42.If GEN = 9 , ABOUT = 15 then GENERAL = ?
43.If DUST is called AIR . AIR is called RAIN.RAIN is called WATER. WATER is called COLOUR.
COLOUR is called ROAD. ROAD is called DUST. Where the Fish lives?
44.A is richer than B. B is richer than C. C is richer than D. D is richer than E. Then who is
the middle of this relation.

45.there is question to find the code of SEARCH the ans is c. There are 5 or 6 questions based on coding and decoding.
46.A to Z. First letter A is swapped with Z, second letter B with Y, and so on. Which letter the
tenth from right.

1)Compound Interest (3 or 4)

2)Two taps are filling a tank and the third one is emptying it .. sort.

3)Problems on trains

Maybe RS AGarwal will help a lot.In aptitude there were problems on RELATIONS and on triangle area..Like

One equilateral triangle is divide into say into 3 equilateral traingle.What is the area proportion of the outermost to the innermost?

Kanbay Exam conducted on 2nd Aug 2003.

The Selection Process will have Written Test, GD & Interview. :

GD : You are each given a role to play..u have to justify why yours is best suited to the question and final reach a general consensus.

Tps: Be cool...... Listen carefully..... n talk..talk what u want but do say something.. don't be too aggressive nor too submissive n yes..don't address any one member only.

Interview: They also ask puzzles like:

Be confidant and preapre ques like why should we take u?

what are ur assets, hobbies, the last book that read , the last film that u saw ..name of characters in that film etc..

********** freshersworld.com

qstns

******

Few questions of KANBAY 2003,aug 1st,in KITS college Bhubaneswar

I am sending all those which I could remember,all were multiple choices..they said cut-off was 12 but it was actually 15 per section.

It had two sections ,LOGIC AND MATHS,cut of in each secn 12,each had

30 questions,1 mark each

LOGIC

1.problems on permutation combinations like BANANA,…..

2.if april 18 was Wednesday in 1998,when is april 18 in 1999?

3.if B has its shadow falling on right side early morning ,then in

which direction is he facing?

4.age problems like…….

Mothers age was twice the the age of son two years ago.after how many

years will she be three times her sons age??

5.analyzing data interpretations and around 4-5 questions based on

tat

53,208……….

7.4-5 problems on profit And loss freshersworld.com

8.in a test moti,ganesh,manali,rupali,raj, appear,according to the scores moti is not the leats scorer but is lower to raj………….who

occupies the 2 nd postion is the order?

9.mr a meets mrs b.mr b is has a son and daughter .son is moti and is married and has a son .mrs moti is mr a mother .how is mr a related to mr b??

10.ram buys some dozens of apples and peaches .their price ratio is

5:7.if the price of 1 dozen of peach is is rs 9,how many dozens of

apple did he bring?

11.problems based on relationships like those in rs aggarwal

12.in a queue A is is in 7 th positon from the left and B is 9

position from the left .if they switch positions A is in 11 th

position ,find the total people in the row??

MATHS

1. S 1=={1,2,3,4}, S 2 =={A,B.C……….Z},S 3=={……………},(S1*S2)U S3==?

2. IF 5*4=,8*7=B,how much is 6*9== ? freshersworld.com

3. 4 to 5 questions on simplifying complex nos. equations

4. sphere of radius 4.5 cm is divide in three spheres ,two have

radius 1.5 and 2 cm,find the other ones??

5. if COMPLEX == 81,and……………….how much is ANALYSE==?? 2-3

questions based on similar pattern

6. two taps a and b fill up a cistern in 2 and3 hrs ,at wat time

should b be clsed if the tank cistern is filled up in 17 minutes??

7. a doctor checks 5 patients every 3 hrs with abreak of 10

minutes between each two check ups.how many he patients he checks in

10 hrs and 15 minutes??

8. no. of diagonals friends if vertices of a octagon are joined??

9. an equilateral triangle is formed by joining the centers of

sides of a equilateral triangle.wat is the ratio of area ,s of both

the triangles??

10. A can finish the work in 3 days , B can finish the work in

double efficiency,can finish with equal efficiency of both A and B.if

all work together within how many days will they complete the work?

11. A.B,C,D stand at the edges of a square.they start moving

along the square sides.after clockwise rotation where will each be??

12. if 1 is stop,2 is run,3 is go,4 is wait,5 is walk,then would

be the next stage if the following pattern

5 5 4 3 2 1 ……………………..

4 1 2 2 3 1 ? freshersworld.com

13. C remembers meeting B after 14 but before 18 ,but D

remembers meeting B after 16 but before 18.when did both meet B??

14. avg age of boys in a class is 12.when the age of teacher is

included it is 13.wat could be the age of teacher?

35 , 45,53,50

the 2nd set was repeated frm NIT jamshedpur.most of the ques are

repeated ..but there are some sets that are real tough...

written test is very simple filteration will be done in GD.

written test consists of 2 sections(apptitude and logical reasoning)

of 30 quest. each and cut off is 12 each.and the total time is 1

hour.

1. which is greater (1000)pow1001 and 1001pow999

2.one container contains milk and water in the ratio 3:7 and the

other contains 8:11,in what ratio these two containers is to be mixed

so that the ratio of milk and water is 4:5.

3. there are two simple problems on time and work.

4.four points will be given and you have to frame two st. line eq.s

in such a way that their point of interesection lies in one of the

four options.

5.there are two to three problems on profit and loss which are little

bit time taking ,so i didn't attempt.

6.a series of nos will be given where the ans can be found by

observing the diff bet two consecutive nos

logical reasoning

1. air is cloud

cloud is rain

rain is water

wateris sand so what is cloud? ans :sand

2. one quesion on relations

3. trafic: signal ans : river :dam

4. two more quesions are there freshersworld.com

5. dsoighkl now if lk-(?)-sd , find letter in 4th place

6. some mammals are donkeys

allbuffalos will have horns

based on this 3 quesions r ther

7. two more r simmilar to above

8. to decode the noise :- H.................M

ANS:C

9.cube is of size 5*5*5 .every side has been coloured. it is divided

into 125 equal parts.

1) what is the no. of parts having only one side coloured - 54.

2) no. of parts having two sided coloured 36.

3) having no side coloured - 27.

10.find the no. of occurrence of T which is immediately preceded y P

and no

timmediately followed by S in some series for eg. (TPTSTRUST.......)

ans - 3

11.Four persons are there wearing different coloured shirts eg.

A,B,C,D

wearing blue ,green, red, yellow.

Now, 1. A cannot wear yellow.

2. B can wear blue or green.

3. C /D is wearing yellow.

You have to find who is wearing which coloured shirt.

12.Find the root of 4a2+b2+c2+4ab-2bc-4ac Ans: 2a+b-c.Two

pipes

can

fill a tank in 5 hrs and 8 hrs. while a hole can empty it in 40 hrs.

What

will be the time taken to fill if each operate at a time.

Soln: 1\x == 1\5 + 1\8 - 1\40

13.A can beat B by 20 mts. While C can beat B by 40 mts. In a race of

100

mts. By how much can C beat A? Soln: 75 mts.

14.If u start your journey 30 minutes late , u have to increase your

speed

250kms\hr. to cover up 1500 kms. In same time. What is your usual

speed?

Ans: 750kms\hr.

15.For a circle, radius is inc. by some % , find net change

in area? freshersworld.com

these r some of the quesion me and my frends remember

note : these r from 5 different sets

gd topics are

lov marriages r arranged marages

r tv serials helpful

Total no. of sets 0716 , 0717 , 0718 out of which

0717 was

Hard . I am sending the qus of 0717 . other section?s

qus . were not managed. Also other sections were easy

in comparison to 0717 .in my college most of the

students having 0717 set were not in the written test

. it was time taking .

I don?t remember the logic qus. For it go thru the

R.S. AGRAWAL .

Go thru 1>blood relation.

2>analogy.

3>coding ?decoding.

4> puzzles.

Qus related to these topics were asked .

I am sending you few questions.

1)complete the series 600 ,180 ,54,

ans===.2( options were given)

2) some doctors are fool john is a doctor

a> john is a fool.b>all

b> fools are doctors

from this you have to draw the conclusion given in the

options such as only a is true only b is tru both are

tru or none is tru.

3> similar question like2 freshersworld.com

some teacher are female.a is female.

a>she is a teacher.

b>all females are teacher.

4>river : dam :: traffic:

ans.==== signal

other qus related to analogy were there .go thru R.S.AGRAWAL.

other qus were from the lbood relations .

some qus were from puzzles .

a,b,c,d,e,f,g are 7 epople seating on a wall facing

towards north.b is not at the end.c and d can not

seat together .

qus like this were there .

mathematical qus / aptitudes.

1)a sum of money doubles in 5 years by simple interest

. how much time it will take for 300 to become 2400.

a>40 years b>25 years c>35 years d> 20 years.

2)if length of a rectangle is made 4 less and breadth

is increased by 3 then the resultant square ?s area is

equal to the rectangle. What is the perimeter of the

rectangle .( options were given)

3)what will be the no. at ? position below

51 11 61

64 30 32 freshersworld.com

35 ? 43

4>the L.C.M. and H.C.F. of two nos. are 84 and 21

and the nos. are in the ratio of 1:4 ,. Find the nos.

ans==== 21, 84

5)find the volume of the hemisphere having radius 2m .

6>problem based on compound interest were asked . so

see the formula of compound interest.

7)a train goes from a to b. if it travels with 50 km/s

then it is late by 10 mins. When it travels with30km/s

then it bis late by

50 mins. Fi nd the distance between a and b.

8)a river is 8 m deep and 150 m wide.river?s speed is

5 km/s.

find the volume of water passed in one min.(1 m cube =1000 c.c.)

9) fin dthe equation of the st. line passing thru the

intersection of the two lines and two other

lines.(equ. Were given)

10) a man sells 20 mangoes + 15 oranges ath the same

price as 15 mangoes+20 oranges. Ho would judge which

is costlier .

( four options were given . I didn?t remember those)

11) a graph was given representing joint venture in

the years.

An dquestion related to the graph were asked such as

A)in which year there was max. change.(ans. Was in the

last year) freshersworld.com

Two other qus were asked.they were long so I don?t

remember them .

12)A is counting the no from 1 to 32 and b from 32 .A

is counting the odd no. only .both?s speed is same.

What will be the number which will be pronounced by A

& B together.

( ans . aws none of these )but confirm yourself .

13) in the word ?DISTURBANCE? 1st is replaced by

last 2nd is replced by 10th , 3rd is by 9th and so

on. Which will be the next to ?T?.

14)GIVEN if x/y==3/5. if 1 is added to num . and 1 is

subtracted from denominator then ratio ==5/7. find the

number.

15)there are 5 black and 9 white balls .if one ball is

drawn then find the probability of being white.

16)Avg. age of 5 children =.a child of 5 year age

dies.after 4 years what will be the avg. age.

17)three nos. are given the product of first and

last is equal to the square of the middle. Find the

nos.(options were given)

(ans.== 10, 20, 40) freshersworld.com

18) a rectangle was having length 100 m breadth 60

m. there is a road of 5m wide on each side of the

rectangle . find the area of the road.

19) fir no. is the double of 2nd and ½ of the 3rd .

other statement was also given which I don?t

rememeber.(ans=H,24,96)

20) a girl cuts a cake in two halevs. One half is

again cut into six equal parts . wt. Of the smaller

one was 20 gms. Fin the wt. Of the whole cake.(ans=240gms.)

21)other question was based on the relative speed in

the river .

i.e. a person first goes upstream then down stream .

river?s speed was given .also the diff. Of time was

given . find the speed of the man.

22) ravana speed is 5000 km/s when going towards the

heaven.

The distance == 75000. ravana has traveled 2 mins.

When god?s messenger reaches the earth . Rama told him

to go back. The speed of the god?s messenger =`00

km/s.

By how much he will increase or decrease his speed so

that he and Ravana reaches exactly at the same time.

23) a man sells a product by giving 10% reduction on

it .in spite of this he gets 10% profit . on a

product of 330 rs. Original price What will be the

buying price.

Essay

2008-10-22T22:30:00.000-07:00

Essay  - 15 mins

 How to improve IT business in India

OR

Deforestation is not an issue we can live in concrete jungles

Q1) 3 - Marks

A tank has two inlets and one out let.  one inlet can fill the tank in 8 hours,

another inlet can fill the tank in 6 hours. The outlet can empty the tank in 10 hours.

If all the taps are working together  in 1.68 what fraction of the tank will be filled

Q2) 5 - Marks

Tom, Dick and harry are walking to-gether. Tom always tell truth, dick tells truth only sometimes,

harry tell lie always. Dick says "He is harry". Harry the person in the middle is "Tom".

Identify the postion of each person.

Q3) 8 - Marks

A jeweller has two glass cases for displaying the jewels left case and right case.

He has always display  6 of 8 jewels Alchemist, Diamond, garnet, sapphire, ruby, pearl, gold and emerald,

3 in each

1. Alchemist must always be displayed in the Left case

2. Diamond must always be displayed in the right case

3. emerald and sapphire should be displayed together

4. If ruby, then diamondis not displayed together.

5. If garnet  then pearl is not displayed together.

1. Which of the following combination is correct in the left case

a) Alchemist, diamond, ruby

b)alchemist, garnet, emerald

2. Which of the following combination is correct in the left case

a)diamond, ruby, pearl

b)alchemist, garnet, pearl

Q4)  5 - Marks

A person wants to travel from A to B a distance of 189 kms.

He can take either the train or coach. He decides to take the coach.

Both the train and coach leave the together.  They meet at a point.

The time taken for the person to travel is equal to more distance covered by

him combined for the entire distance. Find the time taken by the Person.

Q5)8 - Marks

Sally and sue want to date joe.

Sally asks joes "Your house number is a square"

Joe answers "Yes"

Sally asks joes "Your house number is greater than 50"

Joe answers "No"

Sally thinks that she has got the number

Sue asks joes "Your house number is a cube"

Joe answers "Yes"

Sue asks joes "Your house number is greater than 25"

Joe answers "No"

Sue thinks that she has got the number

Both sally and sue reach the wrong house.

If joe had anwered the sally's first question wrong

and sue second question wrong and if the joe's house number

is square of the sallys and sue number.

1. What is sallys guess

2. What is sues guess

Q6)8 - Marks

Bill, smith, conners, william are the First names.

Conners, joe, jack, ted are the last names not in the correct order.

They play a game of cards with following rules

First winner will get 10$ from each.

Second winner will get 20$ from each.

Third winner will get 30$ from each.

Fourth winner will get 40$ from each.

After four turns each one is a winner.

Bill is the first winner,  williams is the last winner.

If smith had more money in the first round and jack had more money in the last round.

Match their first and Last Names.

Q7) 8 - Marks

There are 6 towns A, B, C, D, E, F, G.

Town A and B are in the same longitude.

Towns D, E are in the same latitude.

E,F are industrail towns. Industrial towns cannot be harbours.

C,G are the harbours

The temperature in the harbour is always 10 degrees less than other towns.

The temperature in the longitude is alway higher than that in the latitude by

16 degress. The temperature in the harbour is less than the industrail towns

The temperature in harbour is 20 degrees.

Find the temperatures of all towns.

INTERVIEWS

2008-08-06T09:08:00.000-07:00

What is the purpose of Interview?
An interview will enable an employer:
to check that you have the required skills and knowledge for the job
to ensure that you are clear about what the job involves and that you know what will be required of you
to make sure you know about and are committed to the company, and that you genuinely want to work for them.

Know Yourself

Imaging
Imaging is the most important philosophical aspect for any success. Let me explain imaging with an example.
Do you think whenever Sachin scores a century it is only due to his game on the field? No! There is something which is responsible for it which is off the field.
One day prior to the match Sachin imagines, sitting alone. He imagines: “Tomorrow I get up at 6 ‘O Clock. I will warm myself up for an hour, have break fast, take out my kit and go to the ground at 9 ‘O Clock. At 9:30 Dravid will go for toss, he wins it and selects fielding. I will stand at covers and field every ball that comes to me. Agarkar and Irfan ball tidy spells. I will take a flying catch, etc. In spite of that, Smith scores 140 runs, and the team score 359 runs.
Imaging
“I will open our batting. Initially I will take singles Then I will charge Nel. I score 50 in 15 overs. I will never go for paddle sweep, as there will be bounce for spinners. I will play aggressively. We will win and I will get man of the match award”
Then next day Sachin will just repeat his images. This is called imaging techniques. Every successful person uses this. If you use this technique your confidence grows exponentially.

So before you go to bed, lie down and start imaging in your mind. You go to the place, write test well, get short listed, give interview well, results announced, you are selected.

More the depth you imagine more the success rate grows.

I recommend you to pray and ask the God to make you successful. Please sleep for at least 6 hours
Items to take to Interview
A summary of the research you have done on the company.
A list of questions you have prepared to ask the interviewer.
A notepad and writing tool to take notes with and write down questions.
Any additional materials you may need to present to the interviewer such as reference lists, personal identification pieces, certificates, transcripts or letters of recommendation.
A quick snack that will keep you from getting hungry in the event of a long interview.
Finally be sure that you turned off your mobile phones.

Success Formula for interview
The two things that make you succeed in the interview are preparation and confidence.
Preparation + Confidence = Success -------------- (1)
After good preparation confidence comes automatically which makes you perform well.
So confidence ~ Preparation
So from--- (1)
Preparation + Preparation = Success
? Preparation = Success
2
This implies that if you prepare well, you are already half succeeded.

What employer expects from you?
Leadership - demonstrates effective leadership and motivates and inspires others to perform well
Teamwork - works effectively as part of a team
Motivation - demonstrates a personal drive to achieve, even in uncomfortable situations
Brainpower - ability to analyse and manage information, to identify key issues
Lateral thinking - thinks “outside the box” to come up with imaginative solutions

Perform in the interview
UNDERSTAND HOW THE INTERVIEW WORKS
The interview can be divided into 3 parts
There is an opening period of a few minutes where the scene is being set and first impressions are being formed
A middle period in which the conversation will embrace the organization, the job itself and you and your potential fit. This is where you will be asked many questions.
The closing period-again a few minutes- will be an opportunity for the interviewer to summarize and to indicate the process from here. You will also be able to ask questions here if you haven’t had a prior opportunity to do so.
Exhibit only the required skills
Don’t Lie

Watch your body language!
Give a firm, dry handshake
Make eye contact with all members of the panel
Smile to show your interest and enthusiasm
Avoid extravagant hand gestures
Sit slightly forward to indicate involvement

Body Language: What signals are you sending?
Positive Signals
Leaning forward = interest
Smiling = friendly
Nodding = attentive and alert
Eye contact = curious and focused
Negative Signals
Crossed arms = defensive
Fidgeting hands or tapping feet = nervous or bored
Lack of eye contact = untrustworthy
Leaning back= discomfort

TECHNICAL INTERVIEW
PREPARING FOR TECHNICAL INTERVIEW
In the early years of engineering, students think that in interviews, hi-fi technology is asked which is very complex and difficult.
So they don’t think of learning or refreshing the technical concepts keeping interview in mind.
But the companies ask those technical questions which we have learnt like, what is amplifier, counter, XOR GATE, what is microprocessor, what is signal, what are pointers, data structures, what is linking, what are motors, gears etc., depending on your branch and your skill set that you have mentioned in your resume.
PREPARING FOR TECHNICAL INTERVIEW
When you apply, you look at the pattern of interview, the area of work of the company. You can get to know on what subjects they would ask questions in interview. You can study those two, three subjects in depth. You also have to just touch all the subjects especially electives.
For software companies, prepare the languages you know like C, C++, Java, etc..
TECHNICAL INTERVIEW

Keep all your certificates, mark cards and resume in a file and carry your project reports to the interview.

At the interview centre meet the people who have finished their interview, and ask them what they were asked in the interview. Around 50% of the technical questions that were asked to them will be asked to you. So get to know the answers of those questions.
TECHNICAL INTERVIEW
Enter the interview room with a smile saying ‘may I come in sir?’ go near the chair and shake hands with the interviewer firmly. Generally oldies don’t shake hand and young interviewers prefer doing it.
Sit only after they ask you to sit. Sit straight and make comfortable posture with legs open (don’t cross them).
Give a fresh, eager, alert smiling look. Technical interviewers may not ask HR questions, but to start with, they ask ‘ tell about yourself’, you can tell about yourself in brief. c
TECHNICAL INTERVIEW
Then they may ask ‘what are your favorite subjects?’ Name at least 2 to 3 subjects which you have studied in depth.

The questions asked will only be on basics of these subjects.
They will surely ask questions about the projects you have done and electives you have mentioned in your Resume.
Prepare in depth about your projects, papers and Area of Interest. Specifically your core.
They will ask why you chose this branch.
TECHNICAL INTERVIEW
The questions just look simple.

They may grill you if your answers don’t look confident or if you try to bluff.

If you don’t know, you can say ‘sir we don’t have that in our syllabus’ or ‘sir I am not remembering it’ or ‘I don’t know sir’.

When they ask about projects you can spent more time on them, as you will be more comfortable with the projects you have done.
TECHNICAL INTERVIEW
Non-CS students who apply for software companies, should say, they at least know one programming language, generally C; and should be prepared to face questions like what are strings, pointers, header files or simple ‘for loop’ usage programs.

Speak clearly and convince your answers to them. Don’t rush at your answers and end up stammering, getting confused. Speak slowly and steadily; such are the guys who impress more.

HR INTERVIEW
There are many questions that HR managers from different companies ask. Let me list some of the questions and answers in a format, which I think, can be better ones.

There can be hundreds of good answers, which can be given, based on your views, thoughts, personality, goals, expectations and finally the mood.
Prepare for the HR questions like
Self description
Family background
Asked to know the social, cultural and economic background of your family.
Besides describing the family bkgnd, mention basic ethos and good principless which have been imbibed in you by your family environment.
Strength and weakness
How much you know about yourself
Success and failures
This job is not a bed of roses………….

HR INTERVIEW FAQ’S
First thing in your HR interview will be Introduce yourself – prepare and present it well.
How was your written test?
Why do you want to work in a software company?
After scoring good marks in HSC why did you score less in engineering?
Why do you want to join our company?
What are your strengths or why should we hire you only?
What weakness do you have?
Who is your role model?
Your Hobbies?
Where do you see yourself in 5 years time?
How would your friends describe you in 3 words?

HR INTERVIEW some unexpected questions
Consider yourself as C. E. O., what do you do for growth of the company?
How can you improve employee relationships in the company?
You said you are innovative; you better suit to join a product company rather than our services company.
You being weak in communicating skills do you expect you will get the job?
What has been your biggest achievement to date?
HR INTERVIEW
Back to imaging again. The day prior to the interview you sit alone and rehearse the interview.
It’s like taking your interview by yourself.
Ask HR questions to yourself and answer them loudly as you do in an interview.
You can anticipate even technical questions and rehearse.
Do you have any questions?
What would my career prospects be like?
What training/support could I expect?
What would the key objectives be in the first 6 months of the job?
How will my performance be measured?

However….
Do not ask questions just for the sake of it
Do not ask questions if you should already know the answer e.g. if it is in the company literature
Do not ask about fringe benefits – that conversation can take place when you have been offered the job
And remember….it may be that all your questions have been answered over the course of the interview

SUMMARY

Establish a connection by relating to each interviewer. Note the wording that is used by each interviewer and when appropriate use similar words. Maintain eye contact with each of the interviewers throughout the interview.
7. Sit comfortably and erectly, but don’t sit stiffly, slouching or sprawled over the chair.
8. Project confidence and a positive attitude. Maintain awareness of your voice, posture, energy level, and enthusiasm. Make hand gestures to emphasize important points, but avoid distracting gestures or making too many hand gestures.

Be attentive. Listen to each question carefully and don’t interrupt. If you aren't sure of what is being asked, politely request that the question be repeated.
Close the interview with a strong closing statement of your qualifications for the job.
Thank the interviewers. Shake their hands individually and thank each interviewer by name.

GROUP DISCUSSION

2008-08-06T09:07:00.000-07:00

Why do we have group discussion?
Group discussion allows you to exchange information and ideas and gives you the experience of working in a team.
In the work place, discussions enable management to draw on the ideas and expertise of staff, and to acknowledge the staff as valued members of a team.
PURPOSE OF G.D. IN RECRUITMENT
G.D. is to check
How you behave, participate and contribute in a group.
How much importance do you give to the group objective as well as your own.
How well do you listen to viewpoints of others.
How open minded are you in accepting views contrary to your own.
What is group discussion?
A topic is given and 8 to 10 of you are allowed to speak on the subject for around 10 minutes.
How they evaluate?
Personality
Knowledge
Communication skills
Leadership traits
Personality
DRESS
The clothes need not be costly, dazzling or of latest fashion; they should be clean, neat and well stitched.
It improves confidence
Don’t try new
Polished footwear
Body language
Your movements and posture must be active, positive, alive and responsive enough to make the group and the examiner take to you immediately.
It gives signal to a person’s frame of mind.
Postures are said to divulge what is on one’s mind
Tone and voice
More than words, it is the tone that conveys the message
News reading
A tone that orders or commands, hurts the listener’s ego and self esteem.
Cultivate a voice that is lively and cheerful and conveys a request.
Countenance
A cheerful countenance is most important for a good appearance.
A ready, pleasant and spontaneous smile invariably conveys friendliness and creates a favourable impression.
Self confidence, optimism and amicability automatically create cheerfulness and bring happy smile to the face.
Manners
It is one’s manners that leave a lasting impression on others.
There are people who stand out not for their intellectual abilities but for their good manners.
A courteous, helpful, polite and interested person automatically draws people to himself.
KNOWLEDGE
In a GD knowledge of the subject concerned, backed by common sense will help you deal with any situation and win laurels.
The greater your knowledge of subjects, the more interested, enthusiastic and confident will you be and the more fluent and forceful would be your speech and contribution.
Books, perodicals, daily newspaper
Besides reading, a great deal can be learnt from the talks by and speeches of experts.
COMMUNICATION SKILL
An idea can be appreciated only when it is expressed powerfully and effectively.
Shakespeare’s Mark Antony could transform a hostile mob into a quiescent crowd with his words
British PM Winston Churchill inspired his country with his oratorical skills to continue their fight during the darkest hours of the II world war.
Gandhi, Nehru,…….
Effective communication is not an inborn triat; it can be learnt and mastered.
ROLE PLAYERS
INITIATOR
INFORMER
ILLUSTRATOR
COORDINATOR
ORIENTER
Negative Roles to be Avoided
DISGRUNTLED NON-PARTICIPANT:
ATTACKER
DOMINATOR
CLOWN
How do you face it?
Usually the topic is debatable, so one needs to quickly decide whether you are far or against the given topic.
I suggest, try to be different in your choice among the group.
You are given some 2 minutes time to make points about the subject.
If you initiate, you will get the advantage, but don’t initiate without ideas. It’s better to speak after two to three have spoken.
Be cool and look fresh.

How do you face it?
Don’t look at the judges
Speak clearly and loudly facing all. Try to anchor the group, not dominate it
Clearly explain your ideas with few weighted words. Don’t speak too much of nonsense.
Don’t murmur or stammer.
Don’t criticize others.
Always look at the person who is speaking and nod your head so that judges will see that you are listening.

How do you face it?

If somebody is speaking more, you can say ‘you have spoken enough, let’s give chance to this person’ or ‘I agree with him’ or ‘you are going out of topic, let’s stick to the topic’
Speak around 2-3 times. I mean don’t speak just once for 2 long minutes and keep quite for rest of the time, so try to speak in bursts. If somebody is listening to the discussion from outside, he should see that you are alive inside.
Try to conclude yourself (if they ask to)
One can practice mock GD with their friends to become familiarize with it. “We the people” and “The Big Fight” in NDTV had inspired me.
What is Brainstorming?
Brainstorming is an excellent way of developing many creative solutions to a problem.
It works by focusing on a problem, and then coming up with very many radical solutions to it.
Ideas should deliberately be as broad and odd as possible, and should be developed as fast as possible.
Brainstorming is a lateral thinking process
It is designed to help you break out of your thinking patterns into new ways of looking at things.
During brainstorming sessions there should be no criticism of ideas.
Group Brainstorming
Group brainstorming can be very effective as it uses the experience and creativity of all members of the group.
When individual members reach their limit on an idea, another member's creativity and experience can take the idea to the next stage.
Therefore, group brainstorming tends to develop ideas in more depth than individual brainstorming.
POSITIVE TRAITS
NEGATIVE TRAITS
Summary
Be assertive
A patient listener
Right language
Be analytical and fact-oriented
Maximize participation
Respect other speakers
Show leadership abilities
Be precise
Accept criticism ( thank if criticized on right thing)

Freshers Aproach - Complete questions and answers

2008-08-02T07:09:00.000-07:00

1. GENERAL FAQ
2.
1.1 How is the IT field?
""Market is good or bad, we should get a good job"". Always fresher should keep this
mentality. Market is really very good. We need not worry about market status. Keep on trying till you get a good job. Do fight with your job hunting. Surely you will win.

1.2 Do we need to study any mainframe/ testing/ .NET, etc?
For fresher, absolutely no need for computer courses. Aptitude, C, C++ is enough to get a
good job and there is no need of practical knowledge. A good guidance is hundred times better than a computer course.
If you got degree before 2004 and not strong in any of the software language, better join
some computer courses like testing/ mainframe/ .NET, prepare a fake a resume with one year
experience and do apply regularly. In the interview, many times they don’t ask about your experience. Your technical knowledge and way to explain the project is enough to get a job.

1.3 How to get call letters from companies?

Create one Yahoo ID and register it in to the following yahoo groups.
nestjobs (nestjobs-subscribe@yahoogroups.com), chetana, freshers
You use to get at least 100 mails daily regarding recruitment. Don't use your personal id,
create a new one. One more point, Every Wednesday, follow "Economic Times or Times of India"(Bangalore openings) and "The Hindu"(Chennai openings) without fail. There you can find more opportunities Try to get past one year Economic Times and Hindu papers from library. Collect all the jobs related ids.(including experience also.)
Apply to all the ids. You will be regularly getting interview calls from companies.
Visit these blogs : http://latestjobopening.blogspot.com/
http://jobcollector.blogspot.com/

1.4 How do we prepare resume?
Freshers: Companies like Infosys, TCS and Wipro expects your percentage from 10th
onwards, so it is better include all your curriculum (10th, 12th, all Degree) percentage in your resume.

Resumes should be scanable it should be simple and easy to get information within a single look. It should not contain unwanted information.
Experience: You resume should have the following details, apart from the basic details.
1. Company name
2. Project name
3. Project duration
4. Client
5. Team size
6. Role
7. Project description
8. Activities (We have to mention our project activities)
9. Platform
You can get sample resume formats from section 6 of this document.

1.5 How do we apply?
If you get any openings specific to your skill set, follow as indicted in the advertisement.
If you are applying for multiple companies, without advertisements or for positions not
specific to your skill sets,
1. Prepare a generalized cover letter, ascii format resume(plain text format resume) and
Word format resume
2. Paste your covering letter followed by the plaintext resume in the compose box of your
mail
3. Attach your word format resume.
4. Subject should be like, “Resume for Software Engineer (C, C++, JAVA and VC++)”
5. Type your id in “TO’ field and bulk of ids in “BCC” field, do apply.

1.6 How do we receive job mails?
Visit - http://latestjobopening.blogspot.com/
http://jobcollector.blogspot.com/

1.7 Where do we get company model question papers?
If you get a call letter for written test, from any companies then go to the following sites...
http://allplacementpaper.blogspot.com/

Collect the previous question papers and prepare well. Never miss to go to that site before
you go for Interview/Test. There may be a chance to get the same question papers.

1.8 What are the books we have to prepare before we go for test/ interview?
Aptitude:
Arithmetic Reasoning - R.S.Agarwal
Barron’s GRE Guide.
Shakuntala Devi, George summer puzzle books
Technical Books:
For freshers, C and C++ is enough to get a job.
Let us C, C++, Exploring C - YASHAVANT P. KANETKAR
Turbo C++ - Robert lafore (A very good guide to get basic idea about C++ and OOPS)
Complete Reference – C, C++

1.9 Where do we get the details about companies and details?
http://all-faqs.blogspot.com/
1.10 Am I suitable for IT field?
Anyone who has completed a graduation from an affiliated university is suitable for IT field.
IT field does not expect any specialization from your graduation but it expect good problem solving,
logical thinking and good communication skills. This can be achieved along with your curriculum
subjects by spending an hour per day. R.S. Agarwal is good subject oriented book for preparing
aptitude. Any MBA entrance book is suitable to prepare logical reasoning etc. In fact anyone who is not technically strong but having logical thinking skills is very much suitable for this field. It does not mean that technical people are not suitable.

1.11 Employee reference for MNC’s
If anyone need reference to attend written test or interview or forwarding resume kindly
contact any of our career guidance team members. Our career guidance team maintains the spool of reference and provides you when the need arises.

2. COMPANY TEST PATTERNS
2.1 How to prepare for Infosys?
There is nothing to worry about the Infosys written test. It is easy if you keep your mind cool.
There will be 10 questions in aptitude test, each of different marks & without multiple choices.
Duration is 1 hr & you have to get at least 7-8 correct to get short-listed. You had to put down the

procedure also in the paper. These puzzles are similar to the one in Shakuntala & George Summers. Attempt all questions, as there is no negative marking. No problem if we guess also. Mostly there will be questions on time & distance, probability, puzzles (George Summers), watch questions (related to time), escalator problem, completion of series & profit-loss questions.
Verbal is very easy. There will be 45 multiple-choice questions to be answered in 30 min.
Attempt all questions. Mostly there will be completion of sentences (20 Q), correction of sentences (10Q) reading comprehension (5Q), synonyms & antonyms (10Q).
Short listing is mainly based on aptitude not on verbal. Concentrate more on aptitude. We
can do very silly mistakes there. So be cool.
Regarding interview, firstly it’s not a technical interview. It is purely HR. It will be around
20-30 min. They will even ask 2-3 puzzles. They are easy. If we don’t answer any of them also there is no problem. You should be confident whether it is right or wrong. If you are through the written test then you will be almost through the interview. They almost select everyone in the interview. So concentrate more on the written test.

2.2 How to prepare for TCS?
There were 3 main sections verbal, aptitude and reasoning. Generally any company will not
change the question paper for a year. So, you people can give importance to 2004 Question Papers. You can collect the sample QP from the about websites. We can see QP from 1995 onwards . Preparing all those papers is enough to get placement. There will be section cut off. Aptitude any one can clear. But In verbal section only we can beat others.
Don’t miss to prepare all the verbal section from 1995 onwards. The choices given to
synonym and antonym part will be changed. But the question may be the same one. So, Open "MS WORD" and collect synonym and antonyms for all the words found in all the QP.

Regarding interview:
They check only the confidential level of the candidate. They never expect you to answer for
each and every question. All they need to check is how bold you are, how much confidence you have on you. always don’t expect questions from Areas of Interest. Always have a pleasant smile in your face and keep yourself very cool. That is more important than anything. They may sometime ask very basic questions like what is the version of WINDOWS you have worked on? But answers for them are very much important. For non-computer students the interview will be very simple. They need not worry that they don’t know much technically.
Then HR interview, you should be very careful here. They may ask very tricky questions.
Think twice before answering to these questions. The general questions in HR interview will be, why do you want to join TCS? What do you want to become after 3 years? Why TCS should take you in?

Be confident and be cool, which is enough to clear TCS interview.

3. USEFUL WEBSITES
3.1 Company question paper sites
http://allplacementpaper.blogspot.com/

3.2 Technical document sites

Source Code http://examplesourcecode.blogspot.com/

C Programming http://cprogrammings.blogspot.com/

SQL Server Interview Questions with answers http://sqlserverfaqs.blogspot.com/

Oracle Interview Questions and Answers http://oracleiqs.blogspot.com/

Quality Analysis and Testing ,WinRunner ,Load Runner Interview Questions and Answers http://qualityanalysisfaqs.blogspot.com/

All companies placement papers for past 10 years http://allplacementpaper.blogspot.com/

All fresher’s resources http://allfreshers.blogspot.com/

Interview Puzzles with answers http://puzzleszone.blogspot.com/

.Net Interview Questions and Answers http://dotnetframeworkfaq.blogspot.com/

C#.Net Interview Questions and Answers http://microsoftcsharp.blogspot.com/

ASP.Net Interview Questions and Answers http://www.aspfaqs.blogspot.com/

ADO.Net Interview Questions and Answers http://www.adofaqs.blogspot.com/

VB.Net Interview Questions and Answers http://www.vbfaqs.blogspot.com/

Data structures and algorithms Interview Questions and Answers http://datastructurefaqs.blogspot.com/

Quick Test Professional Interview Questions and Answers http://qtpfaqs.blogspot.com/

WCF- WPF .Net 3.0 Interview Questions and Answers http://wpf-wcffaq.blogspot.com/

Java Interview Questions and Answers http://javaqanda.blogspot.com

SAP Interview Questions and Answers http://sapque.blogspot.com/

Mainframes Interview Questions and Answers http://mainframesfaqs.blogspot.com/

Perl, shell, vb, java, scripts Interview Questions and Answers http://scriptingfaqs.blogspot.com/

VC++ Interview Questions and Answers http://vcprofessional.blogspot.com/

VC++ and MicroSoft Technologies Job postings http://latestjobopening.blogspot.com/

Job postings from Naukri, monster http://jobcollector.blogspot.com/

Guide for Finance, investments, loans http://wise-finance.blogspot.com/

General Guides http://feedlines.blogspot.com/

3.3 Puzzle sites
http://puzzleszone.blogspot.com/

5. INTERVIEW TIPS

5.1 Common interview questions
1. Tell me about yourself
The most often asked question in interviews. You need to have a short statement prepared in
your mind. Be careful that it does not sound rehearsed. Limit it to work-related items unless
instructed otherwise. Talk about things you have done and jobs you have held that relate to the
position you are interviewing for. Start with the item farthest back and work up to the present.

2. Why did you leave your last job?
Stay positive regardless of the circumstances. Never refer to a major problem with
management and never speak ill of supervisors, co-workers or the organization. I f you do, you will be the one looking bad. Keep smiling and talk about leaving for a positive reason such as an
opportunity, a chance to do something special or other forward-looking reasons.

3. What experience do you have in this field?
Speak about specifics that relate to the position you are applying for. If you do not have
specific experience, get as close as you can.

4. Do you consider yourself successful?
You should always answer yes and briefly explain why. A good explanation is that you have
set goals, and you have met some and are on track to achieve the others.

5. What do co-workers say about you?
Be prepared with a quote or two from co-workers. Either a specific statement or a paraphrase
will work. Jill Clark, a co-worker at Smith Company, always said I was the hardest workers she had ever known. It is as powerful as Jill having said it at the interview herself.

6. What do you know about this organization?
This question is one reason to do some research on the organization before the interview.
Find out where they have been and where they are going. What are the current issues and who are the major players?

7. What have you done to improve your knowledge in the last year?
Try to include improvement activities that relate to the job. A wide variety of activities can be
mentioned as positive self-improvement. Have some good ones handy to mention.

8. Are you applying for other jobs?
Be honest but do not spend a lot of time in this area. Keep the focus on this job and what you
can do for this organization. Anything else is a distraction.

9. Why do you want to work for this organization?
This may take some thought and certainly, should be based on the research you have done on
the organization. Sincerity is extremely important here and will easily be used. Relate it to your longterm career goals.

10. Do you know anyone who works for us?
Be aware of the policy on relatives working for the organization. This can affect your answer
even though they asked about friends not relatives. Be careful to mention a friend only if they are well thought of.

11. What kind of salary do you need?
A loaded question. A nasty little game that you will probably lose if you answer first. So, do
not answer it. Instead, say something like, that’s a tough question. Can you tell me the range for this position? In most cases, the interviewer, taken off guard, will tell you. If not, say that it can depend on the details of the job. Then give a wide range.

12. Are you a team player?
You are, of course, a team player. Be sure to have examples ready. Specifics that show you
often perform for the good of the team rather than for yourself is good evidence of your team attitude. Do not brag; just say it in a matter-of-fact tone? This is a key point.

13. How long would you expect to work for us if hired?
Specifics here are not good. Something like this should work: I’d like it to be a long time. Or
As long as we both feel I’m doing a good job.

14. Have you ever had to fire anyone? How did you feel about that?
This is serious. Do not make light of it or in any way seem like you like to fire people. At the
same time, you will do it when it is the right thing to do. When it comes to the organization versus the individual who has created a harmful situation, you will protect the organization. Remember firing is not the same as layoff or reduction in force.

15. What is your philosophy towards work?
The interviewer is not looking for a long or flowery dissertation here. Do you have strong
feelings that the job gets done? Yes. That’s the type of answer were that works best here. Short and positive, showing a benefit to the organization.

16. If you had enough money to retire right now, would you?
Answer yes if you would. But since you need to work, this is the type of work you prefer. Do
not say yes if you do not mean it.

17. Have you ever been asked to leave a position?
If you have not, say no. If you have, be honest, brief and avoid saying negative things about
the people or organization involved.

18. Explain how you would be an asset to this organization?
You should be anxious for this question. It gives you a chance to highlight your best points as
they relate to the position being discussed. Give a little advance thought to this relationship.

19. Why should we hire you?
Point out how your assets meet what the organization needs. Do not mention any other
candidates to make a comparison.

20. Tell me about a suggestion you have made?
Have a good one ready. Be sure and use a suggestion that was accepted and was then
considered successful. One related to the type of work applied for is a real plus.

21. What irritates you about co-workers?
This is a trap question. Think real hard but fail to come up with anything that irritates you. A
short statement that you seem to get along with folks is great.

22. What is your greatest strength?

Numerous answers are good, just stay positive. A few good examples: Your ability to
prioritize, Your problem-solving skills, Your ability to work under pressure, Your ability to focus on projects, Your professional expertise, Your leadership skills, Your positive attitude

23. Tell me about your dream job.
Stay away from a specific job. You cannot win. If you say the job you are contending for is it,
you strain credibility. If you say another job is it, you plant the suspicion that you will be dissatisfied with this position if hired. The best is to stay genetic and say something like: A job where I love the work, like the people, can contribute and can’t wait to get to work.

24. Why do you think you would do well at this job?
Give several reasons and include skills, experience and interest.

25. What are you looking for in a job?
See answer # 23

26. What kind of person would you refuse to work with?
Do not be trivial. It would take disloyalty to the organization, violence or lawbreaking to get
you to object. Minor objections will label you as a whiner.

27. What is more important to you: the money or the work?
Money is always important, but the work is the most important. There is no better answer.

28. What would your previous supervisor say your strongest point is?
There are numerous good possibilities: Loyalty, Energy, Positive attitude, Leadership, Team
player, Expertise, Initiative, Patience, Hard work, Creativity, Problem solver

29. Tell me about a problem you had with a supervisor?
Biggest trap of all. This is a test to see if you will speak ill of your boss. If you fall for it and
tell about a problem with a former boss, you may well below the interview right there. Stay positive and develop a poor memory about any trouble with a supervisor.

30. What has disappointed you about a job?
Don’t get trivial or negative. Safe areas are few but can include: Not enough of a challenge.
You were laid off in a reduction Company did not win a contract, which would have given you more responsibility.

31. Tell me about your ability to work under pressure?
You may say that you thrive under certain types of pressure. Give an example that relates to
the type of position applied for.

32. Do your skills match this job or another job more closely?
Probably this one. Do not give fuel to the suspicion that you may want another job more than
this one.

33. What motivates you to do your best on the job?
This is a personal trait that only you can say, but good examples are: Challenge, Achievement
and Recognition.

34. Are you willing to work overtime? Nights? Weekends?
This is up to you. Be totally honest.

35. How would you know you were successful on this job?
Several ways are good measures: You set high standards for yourself and meet them. Your
outcomes are a success. Your boss tells you that you are successful.

36. Would you be willing to relocate if required?
You should be clear on this with your family prior to the interview if you think there is a
chance it may come up. Do not say yes just to get the job if the real answer is no. This can create a lot of problems later on in your career. Be honest at this point and save yourself future grief.

37. Are you willing to put the interests of the organization ahead of your own?
This is a straight loyalty and dedication question. Do not worry about the deep ethical and
philosophical implications. Just say yes.

38. Describe your management style.
Try to avoid labels. Some of the more common labels, like progressive, salesman or
consensus, can have several meanings or descriptions depending on which management expert you listen to. The situational style is safe, because it says you will manage according to the situation, instead of one size fits all.

39. What have you learned from mistakes on the job?
Here you have to come up with something or you strain credibility. Make it small, well intentioned mistake with a positive lesson learned. An example would be working too far ahead of colleagues on a project and thus throwing coordination off.

40. Do you have any blind spots?
Trick question. If you know about blind spots, they are no longer blind spots. Do not reveal
any personal areas of concern here. Let them do their own discovery on your bad points. Do not hand it to them.

41. If you were hiring a person for this job, what would you look for?
Be careful to mention traits that are needed and that you have.

42. Do you think you are overqualified for this position?
Regardless of your qualifications, state that you are very well qualified for the position.

43. How do you propose to compensate for your lack of experience?
First, if you have experience that the interviewer does not know about, bring that up: Then,
point out (if true) that you are a hard working quick learner.

44. What qualities do you look for in a boss?
Be generic and positive. Safe qualities are knowledgeable, a sense of humor, fair, loyal to
subordinates and holder of high standards. All bosses think they have these traits.

45. Tell me about a time when you helped resolve a dispute between others?
Pick a specific incident. Concentrate on your problem solving technique and not the dispute
you settled.

46. What position do you prefer on a team working on a project?
Be honest. If you are comfortable in different roles, point that out.

47. Describe your work ethic.
Emphasize benefits to the organization. Things like, determination to get the job done and
work hard but enjoy your work are good.

48. What has been your biggest professional disappointment?
Be sure that you refer to something that was beyond your control. Show acceptance and no
negative feelings.

49. Tell me about the most fun you have had on the job.
Talk about having fun by accomplishing something for the organization.

50. Do you have any questions for me?
Always have some questions prepared. Questions prepared where you will be an asset to the
organization are good. How soon will I be able to be productive? And what type of projects will I be able to assist on? are examples.

5.2 Job Interviewing Do’s and Don’ts
Here are the keys to successful job interviewing. Follow these simple rules and you should
achieve success in this important phase of job-hunting.
Do take a practice run to the location where you are having the interview -- or be sure you
know exactly where it is and how long it takes to get there.
Do your research and know the type of job interview you will be encountering. (See types of
job interviews.) And do prepare and practice for the interview, but don’t memorize or overrehearse
your answers. (See our some of the best collections of interview questions.)
Do dress the part for the job, the company and the industry. And do err on the side of
conservatism. If you’re not sure, you should consider reading our article, when Job-Hunting:
Dress for Success.
Do plan to arrive about 10 minutes early. Late arrival for a job interview is never excusable.
If you are running late, do phone the company.
Do greet the receptionist or assistant with courtesy and respect. This is where you make your
first impression.
Don’t chew gum during the interview.
If presented with a job application, do fill it out neatly, completely, and accurately.
Do bring extra resumes to the interview. (Even better, if you have a job skills portfolio, do
bring that with you to the interview.)
Don’t rely on your application or resume to do the selling for you. No matter how qualified
you are for the position, you will need to sell yourself to the interviewer.
Do greet the interviewer(s) by title (Ms., Mr., and Dr.) and last name if you are sure of the
pronunciation. (If you’re not sure, do ask the receptionist about the pronunciation before
going into the interview.
Do shake hands firmly. Don’t have a limp or clammy handshake!
Do wait until you are offered a chair before sitting. And do remember body language and
posture: sit upright and look alert and interested at all times. Don’t fidget or slouch.
Don’t tell jokes during the interview.
Do make good eye contact with your interviewer(s).
Do show enthusiasm in the position and the company.
Don’t smoke, even if the interviewer does and offers you a cigarette. And don’t smoke
beforehand so that you smell like smoke. And do brush your teeth, use mouthwash, or have a
breath mint before the interview.
Do avoid using poor language, slang, and pause words (such as "like," "uh” and "um").
Don't be soft-spoken. A forceful voice projects confidence.
Do have a high confidence and energy level, but don't be overly aggressive.
Don't act as though you would take any job or are desperate for employment.
Do avoid controversial topics.
Don't say anything negative about former colleagues, supervisors, or employers.
Do make sure that your good points come across to the interviewer in a factual, sincere
manner.
Don't ever lie. Answer questions truthfully, frankly and succinctly. And don't over-answer
questions.
Do stress your achievements. And don't offer any negative information about yourself.
Don’t answer questions with a simple "yes" or "no." Explain whenever possible. Describe
those things about yourself that showcase your talents, skills, and determination. Give
examples.
Do show off the research you have done on the company and industry when responding to
questions. (See our Guide to Researching Companies.)
Don’t bring up or discuss personal issues or family problems.
Do remember that the interview is also an important time for you to evaluate the interviewer
and the company she represents.
Don’t respond to an unexpected question with an extended pause or by saying something like,
"boy, that’s a good question." And do repeat the question out loud or ask for the question to
be repeated to give you a little more time to think about an answer. Also, a short pause before
responding is okay.
Do always conduct yourself as if you are determined to get the job you are discussing. Never
close the door on an opportunity until you are sure about it.
Don’t answer cell phone calls during the interview, and do turn off (or set to silent ring) your
cell phone and/or pager.
Do show what you can do for the company rather than what the company can do for you.
Don’t inquire about salary, vacations, bonuses, retirement, or other benefits until after you’ve
received an offer. Be prepared for a question about your salary requirements, but do try and
delay salary talk until you have an offer. (You might consider visiting our salary tutorial for
more tips and strategies.)
Do ask intelligent questions about the job, company, or industry. Don’t ever not ask any
questions -- it shows a lack of interest.
Do close the interview by telling the interviewer(s) that you want the job and asking about the
next step in the process. (Some experts even say you should close the interview by asking for
the job.)
Do try and get business cards from each person you interviewed with -- or at least the correct
spelling of their first and last names. And don’t make assumptions about simple names -- was
it Jon or John -- get the spelling.
Do immediately take down notes after the interview concludes so you don’t forget crucial
details.

MOTIVATING WORDS
Tell yourself you are a great individual and believe in your self, for if you don’t believe
in your self, no one else will believe in you. Create your own life and then go out and live it.
The law of averages tells us you must achieve more, if you are trying more. More, more and
more. The more self-confidence you have the less you will be affected by temporary setbacks (never final, always temporary) and short-term disappointments. The more self-confidence you have the likely it is that you will live a life full of achievement, riches, satisfaction and pure bliss.
MY FRIEND, YOU ARE EXTRAORDINARY!! The odds are greater than 50 crore to 1
against their ever being anyone with the unique combination of talents, skills, and abilities that you possess. You are unique, never forget my friend. The unbelievable achievements that you are capable of, no one knows, not even your self. Exploit your strengths and starve your weaknesses. Yes, of course there is more to it than this but not much more. "WE ARE WHAT WE THINK ABOUT!" YOU MUST! You must make up your mind to look at you honestly and make future decisions based on your uniqueness. NOW! TODAY! THIS VERY MOMENT is time to realize how extraordinary you are.
Albert Einstein used his brain.
Napoleon used his power.
Thomas Edison used his brain.
Thatz why they reached that position. Use your brain my friend. You can reach a
unbelievable position. You can.

The psychologist Abraham Maslow says the story of the human race is the story of men and
women selling themselves short. The great majority of people tend to compare themselves
unfavorably with others. They dwell on there own weaknesses and limitations and they usually end up with far less then they are really capable of. Instead of taking control of their life and enjoying high levels of self-esteem, self-respect and personal pride, the average person just gets by from day to day. GOD put you here on this glorious earth to do more than "just get by." If self-confidence and the self-esteem that goes with it is so desirable, why is it so few people have enough self-confidence to live the lives that are possible for them?
From time to time, (rarely) we have seen people with naturally high levels of self-confidence.
These people have gone on to achieve extraordinary things. In studying the lives of these superachievers we have found that "some" of them started out with high levels of self-confidence, which they learned from there parents, quite fortunately, in early childhood. But, most of them started out like most of us with down deep feelings of inferiority and inadequacy. Because of criticism and lack of love and other mistakes parents made in early childhood, we grow up with little self-esteem and feel less than others.
The starting point in developing a high level of self-confidence and in reality becoming an
EXCELLENT human being is to think through and to decide upon your valves. For example, what is really, really important to you? How do you define values? Having defined a clear set of values, not vague, not unsure, but clear, concise, values will cause you to develop the convictions and enthusiasm necessary for self-confidence. Your starting point toward higher self-confidence and personal greatness is to clarify your values for yourself. Ask yourself what you truly believe in! (?) What do you stand for? What will you not stand for? What would you pay for? Work for? or even DIE FOR????
Make your own list and remember, unshakeable self-confidence comes from unshakeable
commitment to your values. When deep down inside yourself you know you will never violate your highest principles you experience a deep sense of "personal power" and confidence that
empowers you to deal with life openly and honestly and with complete self-confidence in almost
every human situation.
Did you know that Edison failed over 9000 (that’s thousand) times before perfecting the light
bulb! How many of us would have thrown in the "proverbial" towel at 20 failures, 150 failures or at the 8000th failure. After Edison had invented and produced the light-bulb a reporter asked him how it felt to fail over 9000 times. Edison replied, "I was glad I found 9000 ways not to invent the light bulb! From this point forward Edison went on to receive 1,093 patents, more than any other person in U.S. history.

Read as many books, and magazines that are positive inspirational and motivational as you
possibly can. Study the lives of the people who have a positive message to share with all of us, nd
especially in the given field you have chosen to be great at.

Nothing in life that is worthy is ever too hard to achieve, if you have the courage to try it
and you have the faith to believe. Faith is a force that is greater than knowledge or power or skill.
"The secret of success in life is for u to be ready for your opportunity when it comes."
"Success comes in cans, not cannot."
"There are no secrets to success. It is the result of preparation, hard work, learning from failure."
"Self-trust is the first secret of success."
"Success is going from failure to failure without loss of enthusiasm."
"We can succeed at almost anything for which we have unlimited enthusiasm."
Dear friend, you should get Strength to battle with difficulties and overcome them. You
should get Patience enough to toil until some good is accomplished. You should hope enough to
remove all anxious fears concerning the future.
Emotional decisions come from the heart, thinking ones from the brain. You should not take
any emotional decisions. This is the age we all take only emotional decisions. Ask your brain always, it will tell you, what is correct and wrong.
To have a positive day keep the following in mind:
1. Every problem has a solution.
2. Failures always lead to learning something you can use later.
3. Many times you must take a step back before u take two steps forward.
4. After a crisis is always an opportunity.
5. You control your thoughts and feelings.
6. You make the choices that determine your fate.
Michael Jordan wordings. (He is famous US basket ball player.)
1. I have missed more than 9000 shots in my career. I have lost almost 300 games. 26 times, I have been trusted to take the game winning shot and missed. I have failed over and over and over again in my life. And that is why I succeed.
2. I can accept failure, but I can’t accept not trying.
3. I have always believed that if you put in the work, the results will come. I don’t do things halfheartedly. Because I know if I do, then I can expect half-hearted results.
4. If you are trying to achieve, there will be roadblocks. I have had them; everybody has had them.
5. Obstacles don’t have to stop you. If you run into a wall, don’t turn around and give up. Figure out how to climb it, go through it, or work around it.

9. AT ANY COST DON’T LET YOUR HOPE DOWN, WE ARE HERE
TO SUPPORT YOU
Always keep in mind that ‘what do you want right now?' 'What is lacking behind YOU to get
that?' 'What has to be done to get as early as possible?'
To overcome all the above mentioned questions, always there is only one thing with
you...That is 'Continuous hard work without loosing rays of hope'....You should not lose your hope even you didn't get job after a month or two months or even a year(Just for sake I am telling
this)...But no one will do that...You should not stop initiation (whatever you have to do to get job) or approach towards getting job from your side ...You just have to keep on trying to achieve whatever you want?...I am sure you will do that because you are in that situation and also I can support you to the extend I can...See if you think you can always you can...Isn't it?...
Don't loose your hope and always have positive attitude in your mind...Think always about
getting job and do something related to that (which can add value to get a job. we will also help you what you need to do. Nothing should be there in your mind apart from getting job.
For example, If you walking along the road suppose you are seeing an advertisement during that time even that is not related to yours but you should be able to notice or something has to be triggered on your mind regarding your job...Because opportunities can come in any way, you should aware and should not miss that one...It won't come again...To really understand this I can tell you N number of examples even from my friends circle and from my own experience also...You don't attend courses by paying 30 to 50 thousand.....This is I am telling you from my own experience...Because even I didn't know how to type in computer keyboard also I didn't attend for any courses when I got selected into TCS...You don't have to worry about technical knowledge for a fresher....The company which hires you will give you lots of training in software. Just you have to prepare to clear the written test and interview to get into the company.

Questions Paper format

2008-07-25T11:04:00.001-07:00

This is just a sample format of the questions for practicing only. Do not bring this material to the office at any cost.

Mathematics questions:

1. If a number is increased by 20% and then decreased by 20%., then the final number will be

Ans: 4% less

2. A cricketer has an average score of 24 runs in 24 innings. How many runs must he score in the 25th innings to make his average 25?

Ans: 49

3. Evaluate 617 + 6.017 +0.617 + 6.0017

Ans: 629.6357

4. 0.05* 0.4 /0.98 =

Ans: none of these

5. The age of a father is 3 times that of his son. After 20 years he will be twice as old as his son. What is current age of father?

Ans: 60 years

6. If 9/x = x/144 , x = ?

Ans: 36

7. A number is twice the first and thrice the second and their average is 44. What is the largest number?

Ans : 72

8. A can do a work in 8 days and B can do it in 24 days. In how many days they can together do it?

Ans: 6 days

9. A trader fixes the price of article 30 % above the cost price. If he allows a discount of 10% find his gain %

Ans: 17 %

10. Find the unit digit in the product (256*27*159*182)

Ans: 6

SECTION II

1) Starting from a point, Raju walked 12 meters towards north, he turned right and walked 10 meters; he again turned right and walked 12 meters, then he turned left and walked 5 meters. How far is he now and in which direction from the starting point?
Ans: 15 m towards east

2) Raghu ranks 19th in the class of 40. What is his rank from the left?
Ans: 22

3) Sudha is taller than Pushpa.but shorter than Malathi; Geetha is shorter than Vijju; Vijju is not as tall as pushpa. Who should come in the middle if all stand in a row according to height?
Ans: Pushpa

4) Drama is related to Director in the same way as Magazine is related to
Ans: Editor

5) In a certain code CLOCK is written KCOLC. How is STEPS written in that code?
Ans: SPETS

6) If “light” is called “dark”; “dark” is called “green”; “green” is called “blue”; “blue” is called “red” ; ”red” is called “white” is called “yellow” what is the color of blood ?
Ans: White

7) In a certain code language “123” means “ hot filter coffee”; “356” mean “very hot day”; and “589” means “ day and night” Which digit in that code means “very”
Ans: 6

8) How many such 7s are there in the following number sequence which are immediately followed by 4 but not immediately preceded by 8?

5 4 7 8 9 7 4 3 8 7 5 7 4 7 8 7 4 1 2 7 4 5 7 9 4

Ans: Three

9) In a telephone directory which of the following names will appear in the middle ?

a) Rajrathnam b) Rajrathanam c) Rajratnam d) Rajratanam e) Raajrathnam

Ans: Rajrathanam

10) In a basket, there are some apples which are getting doubled for every one minute. If the basket becomes full with apples within an hour, when would it have been exactly half?
Ans: At the 59th minute

SECTION III

COMPREHENSIVE PASSAGE I

1) Trinidad and Tobago is /are
Ans: One country composed of two islands

2) Tourists have been attracted by Trinidad and Tobago mainly because of its
Ans: Music and Dance

3) Investors are attracted towards Trinidad and Tobago mainly because of its
Ans: Oil deposits

4) The flowers of Trinidad resembles those of
Ans: South America

5) The topography of Tobago is marked by
Ans: Sugarcane fields

COMPREHENSIVE PASSAGE II

1) The passage is about:
Ans: Day care for babies

2) A baby is likely to feel more at ease with
Ans: an infant

3) Dr. Benjamin Spock
Ans: Writes books on babies

4)According to the passage, to provide care for their babies working parents should
Ans: Find a private home with other infants

5) Pediatrician
Ans: A child specialist

PART III

Read the following sentences carefully and tick one of the options which is very close to the bolded and underlined word in the sentence:

11) A batsman walking back to the pavilion before the umpire has given verdict is a rare sight these days.
Ans: Judgement

12) Four countries – Brazil, Russia, India & China – are likely to play a significant role in the world economy sooner than 2050, a new report by international consultants Goldman Sachs has said.
Ans: Important

13) Andhra Pradesh government is planning to impose tariff at the rate of one rupee a unit on power consumed by agriculture pump sets in corporate forms
Ans: Enforce

14) A human cell contains some hundred thousand different proteins which have numerous important functions.
Ans: Several

15)Expert in meterological dept are quite skeptical about the benefits from the cloud seeding operations for which the government has so far paid nearly Rs. 7 crores to the contracters.
Ans: Doubtful

Tick the right spelling of the word from the given options

16)Ans: Immortal

17) Ans: Symmetrical

18)Ans: Encyclopedia

19)Ans: Mortgage

20)Ans: Dictionary

Written communication: Duration 10 minutes

Please write an email apologizing to the customer for serving him/her with a non-vegetarian pizza instead of a vegetarian pizza.

Typing Test Passage ( Typing Master Software) Duration 2 minutes

1. Reflection
2. A History of Photography

Instruction for interview - Voice Process

2008-07-25T11:02:00.002-07:00

Before you come for the interview, I would like to give certain Hints & tips for success at interview.

About our Company:

Our parent company is First American Corporation. Its Indian operation is First Indian Corporation. We have two branches in India, one in Bangalore & other at Hyderabad. The head office is at Dallas, USA. Previously, our office was at ITPL and in January, we shifted our office to Bagamane Tech Park, located in CV Raman Nagar. We are about 2,500 employees working at Bagamane & about 2000 at Hyderabad, and nearly 36,000 employees worldwide. We mainly deal with Mortgage information. We have software, BPO- Voice & Non-voice comprising of more than 100 processes at FIC. For more information about our company, you can visit the websites: http://www.firstindiancorp.com and www.firstam.com

You will be having 4 rounds of interview as stated earlier.

Round 1: Aptitude Test (General English & Maths)

This will cover your basic Maths course related to Profit & loss, ratio & proportion, problems on work & time,
For better score, please refer Quantitative Aptitude by R.S Agarwal available at Gangarams or Sapna Book House.

Round 2: HR
You are asked to tell about yourself.

Round 3: Voice Test
Here you are tested on the US Accent.
.
Round 4: Operations Manager Round
This is the most important of all the rounds. Here you are asked to tell more about yourself.

In the HR & Operations Manager round, you need to speak about your family background, your educational qualifications, technical qualification, your strengths and finally your work experiences in different companies and reason for leaving the company in each case. Please mention your role and responsibilities in each work experience and stress on how you can implement those work experience in the new job to provide a quality work and for the growth of the company.

Note: Please wish the interviewer before you take the seat with a warm shake hand.

Here is sample format for How to speak in the interview taken me (Anil Kumar) as example:

Good Morning Sir, this is Anil, a B.Sc Graduate seeking a prospective & growth oriented job. I was born and brought up in Bangalore. My father is a section officer at Vidhana Soudha. My mother is a retired head constable. I have two younger sisters. Both of them working medical transcriptionist at Maxhealthscirbe located at Koramangala.About my educational qualification, I did my SSLC from Sri Saraswathi Vidya Mandira located at Chamarajpet. I completed my PUC with first class from BHS First Grade College located at 4th Block Jayanagar. My optional subjects were Physics, Chemistry, Mathematics & Biology. Then I completed my graduation BSc with First class from the same college in 1998. My optional subjects were Physics, Chemistry & Mathematics since I loved Maths & Chemistry very much. In my school days, I was weak in Maths and there were certain times wherein I developed fever thinking of Maths. Then I was introduced my Maths teacher Vijaydvaja, who imparted the basic fundamental of mathematics to me. Later on, I met my Maths guru Sri B V Nagaraj, Principal of Bangalore High School, where I went for Maths & Science coaching. My Guru BV Nagaraj, implemented confidence in Maths and Vedic Maths helped me to master Maths.

About my technical qualification, I have done 6 months course in Diploma in Computer Applications from St Joseph College. Later on, I did 2 years course in Honor diploma in Software Engineering from Aptech computers, MG Road with a brief exposure to C, C++, Java, Oracle, Internet & other technical aspects.

About my work experience, I first worked as a office assistant at Universal Academy located at 4th Block Jayanagar for a period of 3 months. My job role was to maintain student’s academics information in a database. I worked there for a period of three months as I got good offer to work as Subject Specialist for chemistry at Asian Institute of Technology which is located in Jayanagar. My job role was to prepare questionnaires for IIT-JEE, CET & other engineering entrance exams. I worked there for 1 year as it was a contract.

Then, I entered the BPO section as Insurance Claim Processor at Dharma Systems, located in Koramangala. My Job profile was to enter patient information of various American hospitals into a Database called Medsuite which was sent to Insurance company for processing the medical claims. I was also responsible for training the new joinees and generation of daily report of issues related the work and mail it to the head office located in USA. There, I worked for 2 years. I am unable to continue in that company since it is a two year contract. Last week, we received a mail from USA for cutting down the staff members.

About my hobbies & interests, I like conducting science experiments. From the childhood days, I used to do lot of science experiments especially chemistry like preparation of different chemical compounds like Sulphuric acid, phosphorus pentoxide etc. at home. I had also constructed a telescope during my school days. In my college days, I was introduced to Vedic Maths by my Friend Yogesh, which made me an expert in Mathematics. I have published 4 books in Maths for college students. During my free time, I handle tuitions for college & High school students. I love watching movies and listening to music.

I came to know about your company from my ex-colleague Gokul , who is working in your company. He told me that job is related to mortgage information. He told me that FIC offers a good working environment for the employees which motivate them to work with pleasure. This encouraged me to seek a job in your company. He also told about his job profile that this job involves searching information on internet based on certain criteria. I have good knowledge about internet & I am aware of search engines like yahoo, Google & hotmail which are use to get information related to news, entertainment etc. I feel that it is an interesting assignment for challenging person like me to work here to provide a quality work to the company. I possess good analyzing skills and can understand the nature of job quickly. I am willing to work in shift if the job demands. I am flexible to work individually as well as in teams as per the company requirements. I came to know from Gokul that this job demands good analyzing and searching skills. I have worked efficiently providing quality work to my previous companies. If you provide me an opportunity, I can dedicate myself to provide a quality work for a better growth & prospects of the company.

Note:
1) Speak clearly with medium speed so that everyone can understand what you speak.
2) Present yourself as a special person by speaking about your talents if you have. For example, painting, sports, dancing, singing etc.
3) Talk about your roles and responsibilities in your previous company and how you used to manage the work.
4) Please write in a piece of paper about what to speak in the interview in the above format and practice in front of a mirror.
5) Put stress on your willingness to work in the company.
6) Be confident, please put in your best efforts and leave the rest to God.

Tips for making the resume:

Let the resume contains at least two pages in the format as specified by me. I don’t want any resume of only one page. Let it have the following headlines:

Career Objective:

Job specialization:

Academic Details:

Technical qualifications: any basic computer course that you have done.

Work experience: company name, designation, role and duration.

Personal details:

Hobbies and Interests: Like playing chess, debate and extra curricular activities

Languages known:
Some common questions asked during the HR and Operations Manager rounds:

1) Tell about yourself :
Ans: Refer the document for this question.

2) What salary are you expecting?
Ans: As per company standards but negotiable depending upon my performance.

3) Why do you want to leave your previous company?
Ans: Give a valid reason and do not mention that you are getting less salary in the current company where you are working. Instead, say that the job is not stable since it is on contract basis. Tell that you would like to have long term relationship with company where you work.

4) Why should I offer you the job at FIC?
Or why should I hire you?
Ans: I came to know about your company from my friend Anil, who is working in Agency Refund department of your organization. He told me that FIC offers a good working environment for the employees which motivate them to work with pleasure. This encouraged me to seek a job in your company. He told me that job is related to mortgage information which involves searching information on internet based on certain criteria and one should possess good analyzing skills. I have good knowledge about internet & search engines like yahoo, Google & hotmail which are use to get information related to news, entertainment etc. I feel that it is an interesting assignment for challenging person like me to work here to provide a quality work to the company. I have worked efficiently being a good team player providing quality work to my previous companies. I possess good analyzing skills and can understand the nature of job quickly. I am willing to work in shift if the job demands. I am flexible to work individually as well as in teams as per the company requirements. I can contribute significantly to challenging assignments. I have been keen in learning things and implementing the new ideas as a continuous improvement initiative. If you provide me an opportunity to work in your organization, I can dedicate myself to provide a quality work for a better growth & prospects of the company.

5) What are your strengths and weakness?
Ans: Tell something special about yourself like knowledge, ability to grasp the nature of job quickly, ability to handle the job individual without any extra support etc. But don’t say too much of it.

6) Explain your roles in the previous company or explain your job profile in the previous company.
Ans: Try to present the nature of your job in the present company and give a clear picture of your roles and responsibilities. Also, tell about the challenges and problems you faced and how you tackled with your skills to become a good team player.

7) What do you mean by Mortgage?
A loan to finance the purchase of real estate, usually with specified payment periods and interest rates.

8) What is BPO?
BPO is the act of transferring some of an organization's repeated non-core and core business processes to an outside provider to achieve cost reductions while improving service quality.
Outsourcing gives you the right combination of people, processes and technology to operate effectively in the Global market place without burdening your time and budget.

The most common business process that gets outsourced is call centers. Call centers and Help Desks of many multi national and fortune 500 companies are being outsourced to low waged, English speaking countries such as Philippines and India.

9) What do you know about our company?

First Indian Corporation Private Limited is a subsidiary of First American Corporation. It is a leading provider of offshore transaction and technology services to the Real Estate Information and Mortgage Industry with over 4,700 professionals in Bangalore and Hyderabad. Also, I came to know that FIC is launching its new operation in Mangalore in January 2007.

First Indian Corporation is a pioneer in BPO industry in India having commenced its Image Processing operations in Hyderabad in 1994.
First Indian Corporation's primary focus is on the Title Insurance, Property Tax, Flood Certification, Default Management Services, Credit and Real Estate Information segments.

The First American Corporation is America’s largest provider of business information products and services combining advanced analytics with its vast data resources. The corporation commands leading market share positions in many of the segments it operates with $8.10 billion revenue in 2005 with 35,000 employees worldwide.

10) Where do you see yourself in 5 years?
I would like to see myself as a professional who is well equipped with knowledge, who can perform at his best and would like to lead a group of people who are ambitious and can work towards the fulfillment of their ambitions and help them in developing creative thoughts and contributing them towards the growth of my society, my organization & for my people.

11) What is your career goal or ambition?
Well, everybody looks for good pay, and would love to work with deep industry and business process expertise, broad global resources and with a work environment where you would have work & life balance both.

12) Tell something about your family background.

13) Tell something about your hobbies.

14) Are you willing to work in night shift?

It is better to take a print out of the information that I have sent and practice it before coming to the interview.

Please quote my name, employee id, email Id and department name on your resume and in the interview, tell the HR/Manager that you are my friend and personally know each other because the interview is strictly through employee reference only. Please meet me in person at the reception of FIC (3rd Floor) before coming for the interview for better acknowledgement.