Saturday 23 June 2012

What is the primary purpose of a Web Service Connector? | WebMethods

The purpose of Web Service Connector is to invoke a Web Service on a different web server Start up service will execute whenever the package is loaded or re-loaded

How to preserve existing pipeline before a restorePipeline step ? | WebMethods

Set the "$merge" variable in restorePipeline or "merge" in restorePipelineFromFile to be true. This will ensure that everything in the pipeline before a restorePipeline step is preserved.

How should I organise connection pools ? | WebMethods

If you have adapter notifications and adapter services then you will need to have two separate connections. Otherwise you may get strange errors about transactions and the like. You should also avoid having connection pools shared across different functional areas, even if they are pointing to the same database. The reason for this is that tuning the size of the pool becomes quite difficult if you have multiple types of usage of a pool. You are also unable to easily change the database settings for one without impacting on the other. One approach that seems to work quite well is to have separate pools for each package (generally.. not a hard and fast rule though), as your packages should generally be divided up according to functional area too.

How do I sort using the JDBC select adapter service? | WebMethods

Although there is no tab to specify "order by" the same functionality is able to be specified in the "SELECT" tab. One of the columns in the is labelled "Sort Order" which will allow you to specify the column(s) you wish to sort by. To alter the order: simply alter the order of the columns selected.

How to get the current index of the List in a loop? | WebMethods

There is a special variable on the pipeline called $iteration which will be incremented as the loop operator works up through the list.

How do I throw an exception when using a try-catch block ? | WebMethods

Set a flag in your catch block or leave a variable holding the error message in the pipeline.
Outside the catch block put a branch on that variable or flag and if it is non-null then exit with failure or call the service that generates the exception.

How do I see the java code for my flow service ? | WebMethods

Flow is not turned into java code. It resides on disk as XML representing the flow operations which is then parsed and turned into an in-memory java tree of the operations. Although the underlying code that implements the flow operations is java, it is stored on disk as XML.

What is the difference between drop and delete pipeline variable? | WebMethods

Drop pipeline is an explicit cleanup. It is a request for the pipeline to remove a variable from the available list of variables and make the object it refers to available for garbage collection by the Java Virtual Machine.
Delete is purely a design time operation to remove the variable from the current view. It is only of use if you have created a variable that you didn't mean to create. If you delete a variable that was there because it was previously in the pipeline when you change the view in developer you will see the variable appear again.

How do I debug the Developer IDE itself ? | WebMethods

Start the developer up in debug mode, similar to the Integration server:

cd pathToWMInstall/Developer/bin
developer.bat -debug 10

How do I change the JVM used by Integration Server? | WebMethods

To change to the JDK used by webMethods you will need to edit the IntegrationServer\bin\server.bat or IntegrationServer/bin/server.sh file used to start up Integration Server.
Edit the file and change the following line to point to the JDK path

SET JAVA_DIR=C:\opt\j2sdk1.4.2

How to find dependents of a selected element on the server? | WebMethods

Right click on the element for which you have to find the dependents in the navigational pannel.and click on the option find dependents.

How to Find Elements in the Navigation Panel? | Webmethods

Just right click on the element which you want to see then u click Locate in navigation option then u can see that element in the navigation panel.

How to remove a system lock from an element? | WebMethods

System locks can be removed by making the server side files of the element as readable.right Click on the element in developer which is system locked.and choose the lock properties. It will display the server side files for the element.Make the files as readable and click the refresh button in the developer.You will find that the element is no more locked.

How to Move Flow Steps? | WebMethods

Open the webMethods developer in EditPrespective.Select the flow step u wanna move just drag it to the place you want to move.Otherwise use the arrow buttons on the editor pannel to move the selected flow steps.

What are Structural transformations ? WebMethods

Splitting one field into several or merging fields, reordering portions of a message or renaming fields are know as structural transformations.

How to Change the Order of Steps in a Flow Service? | WebMethods

We can change the Order of steps in a Flow Service of Various other services which are called in sequence within Flow service using "Shift Up and Shift Down" buttons exists at top of Editor Panel.
As well we can move any service or Map inside a SEQUENCE or BRANCH using "Shift Left and Shift Right" buttons

How ACLs Affect locking? | WebMethods

ACLS are used to give the authorization to the particular user groups.If u give ACL to administrator then the admin group users who are there in that group they can have the acess to that particular service.Otherwise we can not use it.This is called ACL locking.

How to open a session on a different server? | WebMethods

Select "session" from the menu in toolbar and click open. key in the server IP and port on which you have to open the connection.The user name and password on that server.

How to Restore a Session on a Server? | WebMethods

Developer gets disconnected from the server if the server goes down or if there is a problem in the network. Donot close the developer.If you close the developer you wont be able to save the changes.Once the server come up or the network problem is resolved. you will be automatically connected to the server and then you can retsore your session.

How to use SEQUENCE as the Target of a BRANCH? | WebMethods

Set evaluate label property of branch step to true. Then set the label property of sequence with the value on which it needs to be processed.

After a default installation, in order to use the pub.file:getFile service, what needs to be done?

pub.file:getFile does not require any modifications to the Integration Server.

The Flow Services are physically stored on the webMethods Integration Server in the form of: | WebMethods

Flow Services are physically stored on the webMethods Integration Server as "XML" files.

The Integration Server requires access to the Java classes for each JDBC driver that it will use. Typically, where must such Java classes be placed?

webMethods6\IntegrationServer\lib\jars.

If the webMethods Integration Server is started with from the server root directory with this command, "bin\server.bat -debug 9 -log none", what does this tell the server to do? | WebMethods

Start in level 9 debug mode and write all server log information to the screen.

When creating Flow services, what is the purpose of a SEQUENCE operation? | WebMethods

The purpose of Sequence operation is to group a subset of Flow operations so that they are treated as a unit.

For a REPEAT operation to execute as long as the specified repeat condition remains true, the count parameter needs to be set to:

The count parameter needs to be set to "-1 " .

When coding IS Services, how can a variable of type Document Type be represented in Java? | WebMethods

Variable of type Document Type be represented as "IData ".

How can the webMethods Integration Server logging date format be changed? | Web

By editing the watt.server.dateStampFmt parameter in the server.cnf file.

By default, the webMethods Integration Server has an HTTP listener assigned to which port?

5555.

An Integration Server package may have one or more startup services. When does a startup service execute? | Webmethods

Whenever the package is loaded or re-loaded.

What is the default behavior, if a Flow EXIT does not specify a "from"? | Webmethods

$loop will be assumed, and a com.wm.lang.flow.FlowException will be thrown if the EXIT is not in a LOOP.

What is the Branch operation? | Webmethods

Branch operation conditionally executes an operation based on the value of a variable at run time.

When you create and save the FLOW "my.pack:myFlow" in the "MyPack" package, where will you find the code? | WebMethods

In the "MyPack\ns\my\pack\myFlow\flow.xml" file.

What is the primary function of the built-in pub.flow:savePipeline service? | WebMethods

Save the current pipeline to a named memory location on the Integration Server.

When creating a BRANCH flow element, what is the purpose of the "scope" field on the properties tab?

To restrict pipeline access to only the data in this document.

What happens when the pub.flow:tracePipeline service is invoked? | WebMethods

The Integration Server logs the name-value pairs in the pipeline at that time.

How to invoke a service from a browser ? | WebMethods

Use a URL in the form:
http://servername:port/invoke/folder.subFolder.subsubFolder/serviceName
(the package name is not part of the URL in any way).

What Is the Pipeline? | WebMethods

The pipeline is the general term used to refer to the data structure in which input and output values are maintained for a flow service. It allows services in the flow to share data.The pipeline starts with the input to the flow service and collects inputs and outputs from subsequent services in the flow. When a service in the flow executes, it has access to all data in the pipeline at that point.

What Is a Flow Service? | WebMethod

A flow service is a service that is written in the webMethods flow language. This simple yet powerful language lets you encapsulate a sequence of services within a single service and manage the flow of data among them.

What Is a Startup Service? | WebMethods

A startup service is one that Integration Server automatically executes when it loads a package into memory.

What Is an Element? | WebMethods

An element is an item that exists in the Navigation panel in webMethods Developer.Elements include folders, services, specifications, IS document types, triggers, and ISschemas. In the Navigation panel, servers and packages are not considered to be elements.

What Is Developer? | WebMethods

webMethods Developer is a graphical development tool that you use to build, edit, and test integration logic. It provides an integrated development environment in which to develop the logic and supporting objects that carry out the work of an integration solution. It also provides tools for testing and debugging the solutions you create.

What are the tools of webMethods Integration ? | WebMethod

    WebMethod Tools:
  i.    webMethods Adapters
  ii.   webMethods Developer
  iii.  webMethods Integration Server
  iv.  webMethods Integration Platform
  v.   webMethods Broker
  vi.  webMethods Monitor
  vii. webMethods Optimize for Infrastructure
  viii. webMethods Trading Networks
  ix.  webMethods EDI Module
  x.  webMethods EDIINT
  xi. webMethods eStandards Modules
  xii. webMethods PIM

What are the modules of webMethods Product Suite? | WebMethods

 WebMethods Product Suite Modules:
  i.    Integration and B2B
  ii.   Service Oriented Architecture
  iii.  Business Process Management
  iv.  Business Activity Monitoring

What is WebMethods?

A company that provides integration tools. The key products include Integration Server, Enterprise Server, Business Integrator, Workflow and Mainframe Integration Server. WebMethods is a company, not a product.

What are the main companies which provide EAI tools / software? | WebMethods

  The below companies are provide EAI tools:
    i. TIBCO
    ii. webMethods
    iii. Vitria
    iv. iPlanet
    v. MQSeries (IBM)
    vi. iPlanet
    vii. BizTalk (Microsoft)
    viii. WebLogic (BEA)
 

What are the disadvantages of EAI? | Web Methods

The main disadvatages of using EAI systems:

   i. Constant change: The very nature of EAI is dynamic and requires dynamic project managers to manage their implementation.
   ii. Lack of EAI experts : EAI requires knowledge of many issues and technical aspects.
   iii. EAI is a tool paradigm: EAI is not a tool, but rather a system and should be implemented as such.
   iv. Building interfaces is an art : Engineering the solution is not sufficient. Solutions need to be negotiated with user departments to reach a common consensus on the final outcome. A lack of consensus on interface designs leads to excessive effort to map between various systems data requirements.
   v. Loss of detail : Information that seemed unimportant at an earlier stage may become crucial later.
  vi.  Accountability : Since so many departments have many conflicting requirements, there should be clear accountability for the system's final structure.

What are the Advantages of EAI? | WebMethods

Advantages of EAI solutions are:
    i.  Streamlines business processes and helps raise organizational efficiency.
    ii. Real time information access among systems.
    iii. Maintains information integrity across multiple systems.
    iv. Speedier transactions at reduced costs.
 If one of the applications misbehaves and requires to be shut down for maintenance, then with EAI, we can easily “decouple” it from rest of the systems. Which avoids having to bring down other systems.

What are the Major categories of EAI? | WebMethods

Integration can be at different application layers:
  1.    Data Level Integration:
  2.    Batch data transfer, OR
  3.    On-line propagation of data updates
  4.    API Level Integration:
  5.    Data is accessed through published API services
  6.    Service Method Level Integration:
  7.    Common services shared by different applications
  8.    User Interface Level Integration:The controller reacts to the user input. It creates and sets the model.
  9.    Common user interface (e.g. web based) for unified access to multiple applications.

Friday 22 June 2012

What is EAI ? | WebMethods

EAI or Enterprise Applications Integration can be defined as data that can be integrated from disparate applications regardless of the platform, allowing the sharing of business processes amongst multiple organizations.

WebMethods Interview Questions and Answers for Freshers & Experienced PDF Free download

WebMethods Interview Questions List

Virtusa Placement Papers

Virtusa Placement Paper & Interview Pattern on 2010

1.verbal
2.analytical
3. programming ability
4.domain knowledge (C or Java)
5.learning ability
6.English test

Verbal Section consists of questions like Articles, prepositions, correction of sentences etc.

Analytical Section consists of some reasoning questions like coding and decoding series, reading comprehensions and some aptitude questions.

Programming ability and domain knowledge questions consists of questions like find out the output and some questions on data structures like.

Question: Which is the worst case complexity of quick sort?
Questions are bit easy but time taking .Programming ability questions consists of questions like finding the output of program which consist of some 24 loops etc

Learning ability Section in this section they will give a passage we have to read in 10 minutes. we have see main points of the passage and remember them .they will take off the paper and will give paper consisting of 10 questions on paper .they wont even allow us to write on a paper while reading the passage. so guys. be careful while reading. I got a passage on “usage of plastic bags” .

English test .We have given a situation like
Digi comp company gives a printer cartridge free for every PC.One customer got a complaint with cartridge and reported it to company. imagine you are the company manager and write a letter to the customer indicating that you will replace the cartridge if necessary and also send their technician. we have completed the exam and waited for nearly 5 hrs for results. finally we got results at about 8 p.m. and i got short listed for technical interview. The next day we had technical interview.

Technical Interview was a stress interview for me. The interviewer criticized me on my resume. and i kept smiling at him whatever he speak guys .they will test our patience. be cool and confident while answering your questions. that’s it you can crack the interview be prepared for data structures and C. I was short listed for HR round .it was very cool .he asked me some general hr questions like ..why virtusa?. tell me about yourself, hobbies, strengths, weaknesses. and at last our results were announced at morning 3.30 AM. and finally I got placed in virtusa. I think my experience would help you to get through virtusa placement..

VALUE LABS Placement Paper

VALUE LABS Placement Paper @ Hyderabad On 2007

Here is the pattern

1.Verbal( 9 questions)

it is very easy one total 9 questions are there , some are spelling corrections , some antonyms and synonyms, easy ones, i didn’t remember the questions

2.Aptitude(7 questions)

this is also easy one, i got
1.numerical problems,
2. what is the angle when the time is quarter past 9,
3.one problem like there are hens and cows the legs r double the number of heads then how many hens r there,
4.if one number is divided by 10 it gives 9 , if divided by 9 gives 8 as reminder, with 8 gives 7………….and if 2 gives i what is that number.
5.problem on interest , like for a given amount 4500 the rate for some amount is 4 % and for the rest of amount it is 6 %, even though he is getting the same amount what is the average rate
6. one person A sold his flat to B for 10% gain , again b sold his flat for 10%loss, what is the deal given for A by B
7.some thing related to % problem (error)
3.Analytical
this one is very very easy
1.if a word RESULT is represented as 346751 and CAM E is represented as 4651 not the same like this one
2. if word MANAGER represents as AAEGMNR then what should SANDEEP represents not the same, like this one
3.problem on streams
4. and 4 more easy questions easy one , you can mark by seeing them
4 .Basic computers
all easy questions like
1.wat is IP
2. identify the binary number given below
3.wat is other name for mother board (system board)
4.wat is the first micro processor(8088)
like this easy ones
here only I lost with out attempting the 4th section because lack of pattern (i.e. timer shown by computer)
so friend’s beware of this model, I know this will help you a lot , all the best for you all
all the remaining rounds are common i.e. gd, tech1, tech + hr all are depending upon your resume.

TCS Placement Paper V

TCS Placement Paper & Interview On 2010 @ Noida

Aptitude Paper:

1. There are 150 weights. Some are 1 kg weights and some are 2 kg weights. The sum of the weights is 260. What is the number of 1kg weights?
Ans: 40

2. A is driving on a highway when the police fines him for over speeding and exceeding the limit by 10 km/hr. At the same time B is fined for over speeding by twice the amount by which A exceeded the limit. If he was driving at 35 km/hr what is the speed limit for the road?
Ans: 15 kmph

3. A moves 3 kms east from his starting point . He then travels 5 kms north. From that point he moves 8 kms to the east. How far is A from his starting point?
Ans: 13 kms

4. A car travels 12 kms with a 4/5th filled tank. How far will the car travel with 1/3 filled tank?
Ans: 5 kms

5. The sum of the digits of a two digit number is 8. When 18 is added to the number, the digits are reversed. Find the number?
Ans: 35

6. The cost of one pencil, two pens and four erasers is Rs.22 while the cost of five pencils, four pens and two erasers is Rs.32.How much will three pencils, three pens and three erasers cost?
Ans: 27

7. Fathers age is 5 times his son’s age. 4 years back the father was 9 times older than son. Find the fathers’ present age.
Ans: 40 years

8. What number should be added to or subtracted from each term of the ratio17 : 24 so that it becomes equal to  1 : 2 ?
Ans: 10 should be subtracted

9. What is the 12th term of the series 2, 5, 8, ….
Ans: 35

10. If 20 men take 15 days to to complete a job, in how many days can 25 men finish that work?
Ans: 12 days

11. In a fraction, if 1 is added to both the numerator at the denominator, the fraction becomes 1/2. If numerator is subtracted from the denominator, the fraction becomes 3/4. Find the fraction.
Ans. 3/7

12. If Rs.1260 is divided between between A, B and C in the ratio 2:3:4, what is C’s share?
Ans: Rs. 560

13. A shopkeeper bought a watch for Rs.400 and sold it for Rs.500.What is his profit percentage?
Ans: 25%

14. What percent of 60 is 12?
Ans: 20%

15. Hansie made the following amounts in seven games of cricket in India: Rs.10, Rs.15, Rs.21, Rs.12, Rs.18, Rs.19 and Rs.17(all figures in crores of course).Find his average earnings.
Ans: Rs.16 crore

16. If two pencils cost 8 cents, then how much do 5 pencils cost?
Ans: 20 cents

17. Some work is done by two people in 24 minutes. One of them can do this work alone in 40 minutes. How much time does the second person take to do the same work ?
Ans: 60 minutes

18. A car is filled with four and half gallons of fuel for a round trip.If the amount of fuel taken while going is 1/4 more than the amount taken for coming, what is the amount of fuel consumed while coming back?
Ans: 2 gallons

19. The lowest temperature in the night in a city A is 1/3 more than 1/2 the highest during the day. Sum of the lowest temperature and the highest temperature is 100 degrees. Then what is the low temp?
Ans: 40 degrees

20. Javagal, who decided to go to weekened trip should not exceed 8 hours driving in a day. The average speed of forward journey is 40 miles/hr.Due to traffic on sundays, the return journey’s average speed is 30 m/h. How far he can select a picnic spot?
Ans: 120 miles

21. A salesperson by mistake multiplied a number and got the answer as 3, instead of dividing the number by  3.What is the answer he should have actually got?
Ans: 3

22. A building with height D shadow upto G. What is the height of a neighbouring building with a shadow of C feet.
Ans: (C*D)/G

23. A person was fined for exceeding the speed limit by 10 mph. Another person was also fined for exceeding the same speed limit by twice the same. If the second person was travelling at a speed of 35 mph, find the speed limit.
Ans: 15 mph

24 A bus started from bus stand at 8.00am, and after staying for 30 minutes at a destination, it returned back to the bus stand. The destination is 27 miles from the bus stand. The speed of the bus is 18mph. During the return journey bus travels with 50% faster speed. At what time does it return to the bus stand?
Ans: 11.00am

25. In a mixture, R is 2 parts and S is 1 part. In order to make S to 25% of the mixture, how much of R is to be added?
Ans: One part of R

26. Wind flows 160 miles in 330 min, for travelling 80 miles how much time does it require?
Ans: 2 hrs 45 mins

27. With a 4/5 full tank a vehicle can travel 12 miles, how far can it travel with a 1/3 full tank
Ans: 5 miles

28. There are two trees in a lawn. One grows at a rate 3/5 of the other in 4 years. If the total growth of trees is 8 ft. What is the height of the smaller tree after 2 years
Ans: 1 1/2 feet

29. Refer to the figure below. A ship started from P and moves at a speed of I miles per hour and another ship starts from L and moving with H miles per hour simultaneously .Where do the two ships meet?
||—g—||—h—||—i—||—j—||—k—||—l—||
PG H I J K L are the various stops in between denoted by || . The values g, h, i, j, k, l denote the distance between the ports.
Ans: Between I and J, closer to J

30. If A is travelling at 72 km per hour on a highway. B is travelling at a speed of 25 meters per second on a highway. What is the difference in their speeds in m/sec.
Ans: 1 m/sec

31. If the word ‘ddosszm’ is changed to ‘central’ then what will be the change for ‘rtjbl’ ?
Ans: quick

32. The word unimpressive was given.they asked us to do change 1st & 2nd,3rd & 4th,so on.then they asked what will be 10th letter from right?
Ans: m

33. The ques on a man,a woman and a boy finish work together in 6 days.man takes 10 days,woman takes 24 days then how much boy will take?
Ans: 40 days

34. If DDMUQZM is coded as CENTRAL then RBDJK can be coded as ———
Ans: QCEIL

35. In the word ECONOMETRICS, if the first and second , third and forth ,forth and fifth, fifth and sixth words are interchanged up to the last letter, what would be the tenth letter from right?
Ans: word is CENOMOTEIRSC tenth word is R

36. Find the physical quantity in units from the equation: (Force*Distance)/(Velocity*Velocity)
Ans: Ns2/m

37. Find the value of @@+25-++@16, where @ denotes “square” and + denotes “square root”.
Ans: 621

38. If f(0)=1 and f(n)= f(n-1)*n, find the value of f(4).
Ans: 24

TCS Placement Paper IV

TCS Placement Paper & Interview On 2010 @ Karakul

Aptitude Paper:

1. Adam sat with his friends in the Chinnaswamy stadium at Madurai to watch the 100 metres running race organized by the Asian Athletics Association. Five rounds were run. After every round half the teams were eliminated. Finally, one team wins the game. How many teams participated in the race?
(a) 30 (b) 32 (c) 41 (d) 54
 
2. (1/3) of a number is 5 more than the (1/6) of the same number?
a) 6 b)36 c)30 d)72
 
3. There are two pipes A and B. If A filled 10 liters in an hour, B can fill 20 liters in same time. Likewise B can fill 10, 20, 40, 80, 160. If B filled in 1/16 of a tank in 3 hours, how much time will it take to fill the tank completely?
a) 9 B) 8 c) 7 d) 6
 
4. Leena cut small cubes of 3 cubic cm each. She joined it to make a cuboid of length 10 cm, width 3 cm and depth 3 cm. How many more cubes oes she need to make a perfect cube?
a) 910 b) 250 c) 750 d) 650
 
5. A lady has fine gloves and hats in her closet- 26 blue, 30 red, and 56 yellow. The lights are out and it is totally dark. In spite of the darkness, she can make out the difference between a hat and a glove. She takes out an item out of the closet only if she is sure that if it is a glove. How many gloves must she take out to make sure she has a pair of each color?
 
6. 10 men and 10 women are there, they dance with each other, is there possibility that 2 men are dancing with same women and vice versa?
a) 22 b) 20 c) 10 d) none
 
7. A game is played between 2 players and one player is declared as winner. All the winnersfrom first round are played in second round. All the winners from second round are played in third round and so on. If 8 rounds are played to declare only one player as winner, how many players are played in first round?
a) 256 b) 512 c) 64 d) 128
 
8. 49 members attended the party. In that 22 are males, 17 are females. The shake hands between males, females, male and female. Total 12 people given shake hands. How many such kinds of such shake hands are possible?
a) 122 b) 66 c) 48 d)1 28
 
9. There is 7 friends (A1, A2, A3….A7).If A1 have to have shake with all without repeat. How many handshakes possible?
a) 6 b) 21 c) 28 d) 7
 
10. 20 men handshake with each other without repetition. What is the total number of handshakes made?
a) 190 b) 210 c) 150 d) 250
 
11. On planet korba, a solar blast has melted the ice caps on its equator. 9 years after the ice melts, tiny planetoids called echina start growing on the rocks. Echina grows in the form of circle, and the relationship between the diameter of this circle and the age of echina is given by the formula d = 4*v (t-9) for t = 9 where d represents the diameter in mm and t the number of years since the solar blast.Jagan recorded the radius of some echina at a particular spot as 7mm. How many years back did the solar blast occur?
a) 17 b) 21.25 c) 12.25 d) 14.05
 
12. A man goes 50Km north , then turned left walked 40Km, then turned right ? In which direction he is?
a) North b) South c) East d) West
 
13. In T.Nagar the building were numbered from 1 to 100.Then how many 4’s will be present in the numbers?
a) 18 b) 19 c) 20 d) 21.
 
14. Ferrari S.P.A is an Italian sports car manufacturer based in Maranello, Italy. Founded by Enzo Ferrari in 1928 as Scuderia Ferrari, the company sponsored drivers and manufactured race cars before moving into production of street-legal vehicles in 1947 as Ferrari S.P.A. Throughout its history, the company has been noted for its continued participation in racing, especially in Formula One where it has employed great success .Rohit once bought a Ferrari. It could go 4 times as fast as Mohan’s old Mercedes. If the speed of Mohan’s Mercedes is 35 km/hr and the distance traveled by the Ferrari is 490 km, find the total time taken for Rohit to drive that distance.
a) 20.72 b) 3.5 c) 238.25 d) 6.18
 
15. A sheet of paper has statements numbered from 1 to 70. For all values of n from 1 to 70. Statement n says ‘ At least n of the statements on this sheet are false. ‘Which statements are true and which are false?
a) The even numbered statements are true and the odd numbered are false.
b) The odd numbered statements are true and the even numbered are false.
c) The first 35 statements are true and the last 35 are false.
d) The first 35 statements are false and the last 35 are false.
 
16. If there are 30 cans out of them one is poisoned if a person tastes very little he will die within 14 hours so if there are mice to test and 24 hours to test, how many mices are required to find the poisoned can?
a) 3 b) 2 c) 6 d) 1
 
17. It is dark in my bedroom and I want to get two socks of the same color from my drawer, which contains 24 red and 24 blue socks. How many socks do I have to take from the drawer to get at least two socks of the same color?
a) 2 b) 3 c) 48 d) 25
 
18. How many 9 digit numbers are possible by using the digits 1,2,3,4,5 which are divisible by 4 if the repetition is allowed?
a) 57 b) 56 c) 59 d) 58
 
19. Given a collection of points P in the plane, a 1-set is a point in P that can be separated from the rest by a line, .i.e the point lies on one side of the line while the others lie on the other side.
The number of 1-sets of P is denoted by n1(P). The minimum value of n1(P) over all configurations P of 5 points in the plane in general position (.i.e no three points in P lie on a line) is
a) 3   b) 5   c) 2   d) 1
Ans: 5
 
20. The citizens of planet nigiet are 8 fingered and have thus developed their decimal system in base 8. A certain street in nigiet contains 1000 (in base   buildings numbered 1 to 1000. How many 3s are used in numbering these buildings?
a) 54 b) 64 c) 265 d) 192
Ans: 192
 
21. Given 3 lines in the plane such that the points of intersection form a triangle with sides of length 20, 20 and 30, the number of points equidistant from all the 3 lines is
a) 1  b) 3  c) 4  d) 0
 
22. Hare in the other. The hare starts after the tortoise has covered 1/5 of its distance and that too leisurely3. A hare and a tortoise have a race along a circle of 100 yards diameter. The tortoise goes in one direction and the. The hare and tortoise meet when the hare has covered only 1/8 of the distance. By what factor should the hare increase its speed so as to tie the race?
a) 37.80  b)8  c) 40  d) 5
Ans: 37.80
 
23. Here 10 programers, type 10 lines with in 10 minutes then 60lines can type within 60 minutes. How many programmers are needed?
a) 16 b) 6 c) 10 d) 60
 
24. Alok and Bhanu play the following min-max game. Given the expression
N = 9 + X + Y – Z
Where X, Y and Z are variables representing single digits (0 to 9), Alok would like to maximize N while Bhanu
would like to minimize it. Towards this end, Alok chooses a single digit number and Bhanu substitutes this for a variable of her choice (X, Y or Z). Alok then chooses the next value and Bhanu, the variable to substitute the value. Finally Alok proposes the value for the remaining variable. Assuming both play to their optimal strategies, the value of N at the end of the game would be
a) 0 b) 27 c) 18 d) 20
 
25. Alice nd Bob play the following coins-on-a-stack game. 20 coins are stacked one above the other. One of them is a special (gold) coin and the rest are ordinary coins. The goal is to bring the gold coin to the top by repeatedly moving the topmost coin to another position in the stack.
Alice starts and the players take turns. A turn consists of moving the coin on the top to a position i below the top coin (0 = i = 20). We will call this an i-move (thus a 0-move implies doing nothing). The proviso is that an i-move cannot be repeated; for example once a player makes a 2-move, on subsequent turns neither player can make a 2-move. If the gold coinhappens to be on top when it’s a player’s turn then the player wins the game. Initially, the gold coinis the third coin from the top. Then
a) In order to win, Alice’s first move should be a 1-move.
b) In order to win, Alice’s first move should be a 0-move.
c) In order to win, Alice’s first move can be a 0-move or a 1-move.
d) Alice has no winning strategy.
 
26. For the FIFA world cup, Paul the octopus has been predicting the winner of each match with amazing success. It is rumored that in a match between 2 teams A and B, Paul picks A with the same probability as A’s chances of winning. Let’s assume such rumors to be true and that in a match between Ghana and Bolivia, Ghana the stronger team has a probability of 2/3 of winning the game. What is the probability that Paul will correctly pick the winner of the Ghana-Bolivia game?
a)1/9    b)4/9    c)5/9    d)2/3
Ans: 5/9
 
27. 36 people {a1, a2, …, a36} meet and shake hands in a circular fashion. In other words, there are totally 36 handshakes involving the pairs, {a1, a2}, {a2, a3}, …, {a35, a36}, {a36, a1}. Then size of the smallest set of people such that the rest have shaken hands with at least one person in the set is
a)12    b)11    c)13    d)18
Ans: 18
 
28. A sheet of paper has statements numbered from 1 to 40. For each value of n from 1 to 40,
statement n says “At least and of the statements on this sheet are true.” Which statements are true and which are false?
a)The even numbered statements are true and the odd numbered are false.
b)The first 26 statements are false and the rest are true.
c)The first 13 statements are true and the rest are false.
d)The odd numbered statements are true and the even numbered are false.
 
29. There are two boxes, one containing 10 red balls and the other containing 10 green balls. You are allowed to move the balls between the boxes so that when you choose a box at random and a ball at random from the chosen box, the probability of getting a red ball is maximized. This maximum probability is
a)1/2    b)14/19     c)37/38 d)3/4
 
30. A circular dartboard of radius 1 foot is at a distance of 20 feet from you. You throw a dart at it and it
hits the dartboard at some point Q in the circle. What is the probability that Q is closer to the center of the circle than the periphery?
a) 0.75    b) 1    c) 0.5    d) 0.25
 
31. A sheet of paper has statements numbered from 1 to 40. For all values of n from 1 to 40, statement n says: ‘Exactly n of the statements on this sheet are false.’ Which statements are true and which are false?
a) The even numbered statements are true and the odd numbered statements are false.
b) The odd numbered statements are true and the even numbered statements are false.
c) All the statements are false.
d) The 39th statement is true and the rest are false.

TCS Placement Paper III

TCS Placement Paper & Interview On 2011 @ Hyderabad

They asked almost from previous question paper model only but not the same questions.
Work out all problems you people definitely achieve it.
You already know time : 80 min
Questions : 35

Technical Questions:

1.What are the functionals of Operating System?
Ans: Its 1st question i din’t answer well.He explained the answer.
2.Tell me what are OOPS concepts?
Ans: I answered well.
3.What is Inheritance?
Ans: I said excellent answer.
4.What is Encapsulation?
Ans: Answered well.
5.Write a program for Reverse a Number.
Ans: I wrote, he satisfied.
6.Given one Number check each digit and if it is even subtract 1 and if it is odd add 1.
Ans: I said the logic,but couldn’t write the program.
7.what is latest version of Google Browser?
Ans: I said google chrome.I dnt knw whether this is right or not.
8.Which Operating System you Use?
Ans: Linux(ubuntu)
9.What is Difference Between Ubuntu and other Linux distribution?
Ans: I said diff btn ubuntu and fedora.
In ubuntu we have to download each and every file.so Internet needed and for fedora not
required.
He asked me which version you are using?
I said 10.04
10.Tell me about your self?
Ans: its actually first question.
11.where we need Operator Overloading?
Ans: I explained nicely.

HR Round:

Its around at 7 pm on 30th sep’11
1.Tell me abot your self?
Ans: while i was answering he asked another question.
2.What are the two problems software facing now a days?
Ans: I said software crices,and he asked crices..????
then I replied Sir I dnt have great idea about it.
3.Where did u complete your Graduation?
Ans: I said my college Name and its importance.
4.What you learn two great things from this University?
Ans:
1.We can interact with different people coming from differnt states.
2.We can utilise internet and get more and more knowledge.
5.What you got less percentage compare with degree,inter and X?
Ans: I said exact reason.
Friends interviewers are very interactive so we have to interact with polite way. and donot
involve in politics even if they ask. just we have to say i dont have any idea sir/madam.
and also donot support any region.
I finally I selected in TCS.

TCS Placement Paper II

TCS Placement Paper & Interview On 2011 @ Hyderabad

They asked almost from previous question paper model only but not the same questions.
Work out all problems you people definitely achieve it.
You already know time : 80 min
Questions : 35

Technical Questions:

1.What are the functional of Operating System?
Ans: Its 1st question i din’t answer well.He explained the answer.
2.Tell me what are OOPS concepts?
Ans: I answered well.
3.What is Inheritance?
Ans: I said excellent answer.
4.What is Encapsulation?
Ans: Answered well.
5.Write a program for Reverse a Number.
Ans: I wrote, he satisfied.
6.Given one Number check each digit and if it is even subtract 1 and if it is odd add 1.
Ans: I said the logic,but couldn’t write the program.
7.what is latest version of Google Browser?
Ans: I said google chrome.I dnt knw whether this is right or not.
8.Which Operating System you Use?
Ans: Linux(ubuntu)
9.What is Difference Between Ubuntu and other Linux distribution?
Ans: I said diff btn ubuntu and fedora.
In ubuntu we have to download each and every file.so Internet needed and for fedora not
required.
He asked me which version you are using?
I said 10.04
10.Tell me about your self?
Ans: its actually first question.
11.where we need Operator Overloading?
Ans: I explained nicely.

HR Round:

Its around at 7 pm on 30th sep’11
1.Tell me abot your self?
Ans: while i was answering he asked another question.
2.What are the two problems software facing now a days?
Ans: I said software crices,and he asked crices..????
then I replied Sir I dnt have great idea about it.
3.Where did u complete your Graduation?
Ans: I said my college Name and its importance.
4.What you learn two great things from this University?
Ans:
1.We can interact with different people coming from differnt states.
2.We can utilise internet and get more and more knowledge.
5.What you got less percentage compare with degree,inter and X?
Ans: I said exact reason.
Friends interviewers are very interactive so we have to interact with polite way. and donot
involve in politics even if they ask. just we have to say i dont have any idea sir/madam.
and also donot support any region.
I finally I selected in TCS.
See you then.

TCS Placement Paper I

TCS Placement Paper – Aptitude Questions – 2011

Aptitude Question Paper – TCS – 2011

1. There are seventy clerks working in a company, of which 30 are females. Also, 30 clerks are married; 24 clerks are above 25 years of age; 19 married clerks are above 25 years, of which 7 are males; 12 males are above 25 years of age; and 15 males are married. How many bachelor girls are there and how many of these are above 25?
 
2. A man sailed off from the North Pole. After covering 2,000 miles in one direction he turned West, sailed 2,000 miles, turned North and sailed ahead another 2,000 miles till he met his friend. How far was he from the North Pole and in what direction?
 
3. Here is a series of comments on the ages of three persons J, R, S by themselves.
S : The difference between R’s age and mine is three years.
J : R is the youngest.
R : Either I am 24 years old or J 25 or S 26.
J : All are above 24 years of age.
S : I am the eldest if and only if R is not the youngest.
R : S is elder to me.
J : I am the eldest
R : S is not 27 years old.
S : The sum of my age and J’s is two more than twice R’s age.
One of the three had been telling a lie throughout whereas others had spoken the truth. Determine the ages of S,J,R.
 
4. In a group of five people, what is the probability of finding two persons with the same month of birth?
5. A father and his son go out for a ‘walk-and-run’ every morning around a track formed by an equilateral triangle. The father’s walking speed is 2 mph and his running speed is 5 mph. The son’s walking and running speeds are twice that of his father. Both start together from one apex of the triangle, the son going clockwise and the father anti-clockwise. Initially the father runs and the son walks for a certain period of time. Thereafter, as soon as the father starts walking, the son starts running. Both complete the course in 45 minutes. For how long does the father run? Where do the two cross each other?
 
6. The Director of Medical Services was on his annual visit to the ENT Hospital. While going through the out patients’ records he came across the following data for a particular day : ” Ear consultations 45; Nose 50; Throat 70; Ear and Nose 30; Nose and Throat 20; Ear and Throat 30; Ear, Nose and Throat 10; Total patients 100.” Then he came to the conclusion that the records were bogus. Was he right?
 
7. Amongst Ram, Sham and Gobind are a doctor, a lawyer and a police officer. They are married to Radha, Gita and Sita (not in order). Each of the wives have a profession. Gobind’s wife is an artist. Ram is not married to Gita. The lawyer’s wife is a teacher. Radha is married to the police officer. Sita is an expert cook. Who’s who?
 
8. What should come next?
1, 2, 4, 10, 16, 40, 64,

Questions 9-12 are based on the following : Three adults – Roberto, Sarah and Vicky – will be traveling in a van with five children – Freddy, Hillary, Jonathan, Lupe, and Marta. The van has a driver’s seat and one passenger seat in the front, and two benches behind the front seats, one beach behind the other. Each bench has room for exactly three people. Everyone must sit in a seat or on a bench, and seating is subject to the following restrictions: An adult must sit on each bench. Either Roberto or Sarah must sit in the driver’s seat. Jonathan must sit immediately beside Marta.
 
9. Of the following, who can sit in the front passenger seat ?
(a) Jonathan (b) Lupe (c) Roberto (d) Sarah (e) Vicky
 
10. Which of the following groups of three can sit together on a bench?
(a) Freddy, Jonathan and Marta (b) Freddy, Jonathan and Vicky
(c) Freddy, Sarah and Vicky (d) Hillary, Lupe and Sarah
(e) Lupe, Marta and Roberto
 
11. If Freddy sits immediately beside Vicky, which of the following cannot be true ?
a. Jonathan sits immediately beside Sarah
b. Lupe sits immediately beside Vicky
c. Hillary sits in the front passenger seat
d. Freddy sits on the same bench as Hillary
e. Hillary sits on the same bench as Roberto
 
12. If Sarah sits on a bench that is behind where Jonathan is sitting, which of the following must be true ?
a. Hillary sits in a seat or on a bench that is in front of where Marta is sitting
b. Lupe sits in a seat or on a bench that is in front of where Freddy is sitting
c. Freddy sits on the same bench as Hillary
d. Lupe sits on the same bench as Sarah
e. Marta sits on the same bench as Vicky
 
13. Make six squares of the same size using twelve match-sticks. (Hint : You will need an adhesive to arrange the required figure)
 
14. A farmer has two rectangular fields. The larger field has twice the length and 4 times the width of the smaller field. If the smaller field has area K, then the are of the larger field is greater than the area of the smaller field by what amount?
(a) 6K (b) 8K (c) 12K (d) 7K
 
15. Nine equal circles are enclosed in a square whose area is 36sq units. Find the area of each circle.
16. There are 9 cards. Arrange them in a 3*3 matrix. Cards are of 4 colors. They are red, yellow, blue, green. Conditions for arrangement: one red card must be in first row or second row. 2 green cards should be in 3rd column. Yellow cards must be in the 3 corners only. Two blue cards must be in the 2nd row. At least one green card in each row.
 
17. Is z less than w? z and w are real numbers.
(I) z2 = 25
(II) w = 9
To answer the question,
a) Either I or II is sufficient
b) Both I and II are sufficient but neither of them is alone sufficient
c) I & II are sufficient
d) Both are not sufficient
 
18. A speaks truth 70% of the time; B speaks truth 80% of the time. What is the probability that both are contradicting each other?
 
19. In a family 7 children don’t eat spinach, 6 don’t eat carrot, 5 don’t eat beans, 4 don’t eat spinach & carrots, 3 don’t eat carrot & beans, 2 don’t eat beans & spinach. One doesn’t eat all 3. Find the no. of children.
 
20. Anna, Bena, Catherina and Diana are at their monthly business meeting. Their occupations are author, biologist, chemist and doctor, but not necessarily in that order. Diana just told the neighbor, who is a biologist that Catherine was on her way with doughnuts. Anna is sitting across from the doctor and next to the chemist. The doctor was thinking that Bena was a good name for parent’s to choose, but didn’t say anything. What is each person’s occupation?

TCS Placement Papers

Polaris Placement Paper II

The test was for one hr.– 40 technical questions (electrical) for 1/2 hr. and 30 aptitude questions (1/2 hr.)

Technical questions:

What is motor is used in ceiling fan & washing m/cs
In electric traction
what is 8255
8085 has ___ address and ___ data lines
8051 is a ____ bit microcontroller (ans:8 bit)
74LS244 is _____
Bucholz relay is used for _____ protection (transformer)
Transmission line parameters are called ____
No. of poles and freq given find speed
In which motor starting torque can be increase by adding rotor resistance (IM) there were 4 questions form Power plants (had to guess in that) 4 questions from Controls (pretty easy…..like zetaL)
1 means a) under damped b) un damped c) over damped  d)critically damped
questions abort transistor. basic working
Boolean expression was given for simplification-simple
How many flags does 8085 have? (ans: 5)
which of the following are universal gates? (ans : nand, nor)
what’s the frequency range of mobile communication?
The resolution of picture in TV depends on..
a. no: of lines scanned b. video detector o/p and 2 more choices were given…
Question on stability of FET
What is the modulation used to transmit sound in TV signal
a. VSB b. FM and 2 more choices were there…
What is double integration of a unit step signal?
a. ramp signal
b. parabola
It mainly covers Operating system. consists of questions in semaphore( 2 questions), job scheduling algorithms (shortest job), paging (2 or 3 questions), virtual memory, hashing, etc virtual memory is used for…………
RDBMS covers “Define Query” (simple but 4 options made some complications)

Data structure : order of randomly searched binary tree
Electronics based questions which covers microprocessor 80386(not 8085) 2or 3 questions
A pulse is passed through a pipe. to detect any damage. this process is called ……….
a. Time reflectometry
b. Piggy backing

Aptitude
25. Given a 3×3 matrix, find the minor of one of the elements
26. find the odd one out of the series 48 47 44 40 32 23 12
27. A goes to school at 4 kmph and reaches 10 mins b4 schedule and at  3 kmph reaches 10 mins after schedule find the dist (ans: 4 km)
28. Meaning of COY
29. Opposite of Grimace
30. Opposite of FLOODED WITH
31. JUMBLED letters find out the word, the word was FATIGUE
32. Simple interest problem
33. Smallest of four given fractions
34. A guy walks @ 4kmph from a point. After 4hrs a cyclist starts from the same point @ 10kmph….At what distance will they meet from the starting point? the qn was almost like this.
35. x% of people have tea, y% have coffee, z no: of people have both…find the total no: of people… soln: easy. have to use n(AUB)=n(A)+n(B)-n(A intersect B)..
36. Complete the series…. 1,4 ,9,25,… (choices- 47,49,64,none)
37. Analytical question
“failures are stepping stones to success” this means…
a. all success are preceded by failures
b. success consists of failures
c. future can lead to success
d. none..
38. about matrices.. which of the following don’t have inverse? u have to find for which matrix |A|=0…time consuming…
39. There was 1 big square which had 16 squares in it..4 in a row & column.. each square had a no: in it.. except one square.. . had 2 find the missing no:…i don’t remember the no’s…
40. 4 sentences given..& 4 choices of word given…have to choose 1 word that suits all the 4 sentences… *the police are ___ about the missing boy in the forest. * the detective was ___ her face for marks. and 2 more sentences were there… choices (investigating, searching….).ans: investigating.
41. Hcf of 2 no’s…1024 & 1214…don remember no’s exactly. like in RS Aggarwal…
42. out of 500 students,75% of boys and 72% of girls passed. Total pass percentage is 77%.How much girls …?
43. how many prime numbers are between 1 to 100?
44. A greater than B and B less than C. what is the relation between A and C ?
45. given a set of different sentences …we have to choose an appropriate word which should be matching with all sentences
e.g.: A person ————–the child
The government—————the people options may be 1)saved 2)preserve (this is not the exact question)

Polaris Placement Papers

Polaris Placement Paper Technical, Aptitude Questions 2011

Technical Section: 40 Questions in 30 Minutes

It covered basics of almost all ECE subjects like about Transistors, Digital & Microprocessors, Communication, Microwave etc, but Questions were only basics nothing in deep and all questions had choices.
1. Questions about Transistor basic working.
2. Boolean expression was given for simplification-simple.
3. How many flags does 8085 have? (ans-5)
4. Which of the following are universal gates?
(Ans. Nand, Nor)
5. What is the frequency range of mobile communication?
6. The resolution of picture in TV depends on..
a. Number of lines scanned
b. Video detector o/p
And two more choices were given…
7. Question on stability of FET
8. What is the modulation used to transmit sound in TV signal
a. VSB
b. FM
And 2 more choices were there.
9. What is double integration of a unit step signal?
a. Ramp signal
b. Parabola
Don’t remember the other Two…
(Ans. b)
10. Question about spectral density-basic.
11. Question about basics of finite fourier transform(FFT), It was something about 8pt FFT…don’t remember exactly…but if u know the definition you can do…
I am not able to memorize the rest frenz…but there were few more Questions on transistors…

Aptitude Section: 30qns in 30min, All Questions had choices.

1. Completing Series of alphabets was given.
2. A guy walks @ 4kmph from a point, After Four hrs a cyclist starts from the same point at 10kmph, At what distance will they meet from the starting point?
The question was almost like this don’t remember exact wordings.
3. x% of people have tea, y% have coffee, z number of people have both, find the totalnumber of people.
Solution: Easy have to use n (AUB)=n(A)+n(B)-n(A intersctn
4. Figure given & we have to find out the number of four sided figures in it, little complicated because less time.
5. Complete the series
1,4,9,25,… (choices- 47,49,64, none)
6. Complete series
7. Analytical Questions
“failures are stepping stones to success” this means…
a. all success are preceded by failures
b. success consists of failures
c. failures can lead to success
d. none..
8. About matrices.
which of the following don’t have inverse?
you have to find for which matrix |A|=0…time consuming.
9. Another about matrices.
10. There was one big square which had 16 squires in it. four in a row & column.. each square had a number in it.. Except one square. had 2 find the missing number I don’t remember the numbers
11. For sentences given..& four choices of word given…have to choose 1 word that suits all the for sentences…
The police are ___ about the missing boy in the forest.
The detective was ___ her face for marks.
And two more sentences were there…choices (investigating, searching….).
ans. Investigating.
12. Opposites… sluggish x rapid
13. Rising x setting
14. Meanings…easy
15. Meanings…
16. HCF of two numbers 1024 & 1214…don’t remember numbers.

Polaris Placement Papers

Patni Placement Paper III

Patni Placement Paper Technical(PL/SQL) 2008 @ Chennai

Technical Questions:

1) A package without body is possible.(T/F)
ans:T

2) Subprograms have equal scope as variables.(T/F)

3) Can a cursor be closed for two times(T/F)
ans:F

4) Transaction function can be used in trigger(T/F)
ans:F

5) DDL can be used in trigger(T/F)
ans:T

6) A trigger name can have the same name as that of its base table name(T/F)
ans:T

7) In a PL/SQL block a variable and a table name both are same then which will get highest precedence.

8) Is PL/SQL reserved words can be used in SQL
Ans:It can be used with quotation.

9) How to write a single quote in SQL
i)””                    ii)”’                   iii)”

10) Can a labeled go to statement goto the inner loop(T/F)
ans:F

11)Which are the mandatory parts of PL/SQL procedure.

12)SQL%ISOPEN for implicit cursor is always evaluateto false(T/F)
ans:T

13)Any variable not declared in the declare part assigns value

14)For cursor %NOTFOUND and for PL/SQL NO_DATA_FOUND(exception)gives the same result.(T/F)
ans:T

15)If exception occured in the exception then it will
i)raise in the same block
ii)raise in the outer block
iii)not raise in the same block

Patni Placement Paper II

Patni Placement Paper Technical 2008 @ Gujarat

1) PMON command is used for__________
 
2) Can an inbuilt exception be redifined by a user(T/F)ans:F
 
3) Raise_application_error is used for……….
4) In SQL SGA area the parser tree and exceptions are stored which are used for multipleapplications (T/F)
ans:F
 
5)exceptions are executed at
i)compile time
ii)runtime(ans)
 
6)When a subprocedure will be declared within a procedure?
 
7)Record1 and record2 are declared.each record has two fields with same datatypes.
i)Record1:=Record2;
ii)Record1.field1:=Record2.field1;
iii)Record1.field2:=Record2.field2;
a)only i is legal
b)only ii and iii are legal
c)all are legal
d)none is legal
 
8)  Trigger syntax declaration without the option for each row is legal(T/F)
ans:T
 
9) Tablespace contains physical data(T/F)
ans:T
 
10) Rowid is a pseudo column of every oracle table (T/F)
11) Lpad and Rpad have default pad character is space (T/F)
 
12) when %ROWCOUNT is 0 what will happen
i)NO_DAT_FOUND exception will raise
ii)%FOUND will be false

Patni Placement Paper I

Patni Placement Paper Technical 2009 @ Orissa

1. An index is automatically generated with the following constraints.
a. Check
b. Not null
c. Primary key
d. Foreign key
 
2. Select mod(16,3) from emp;
a. 1
b. 2
c. 3
d. Error in the stmt
 
3. The data dictionary view to see the list of constraints enabled on a table is
a. user_tables
b. user_table_constraints
c. user_constraints
d. There is no dictionary view available for the same
 
4. Identify the pseudo columns
a. row id
b. sys date
c. row val
d. dual
 
5. select deptno, count(empno) from emp
where count(empno)>=5
group by deptno; identify the line no which contains the error
a. 1
b. 2
c. 3
d. 1,3
 
6. choose the group function that can be used with any data type
a. sum()
b. min()
c. avg()
d. all
 
7. which of the following sequence is true
a. WHERE,HAVING,GROUPBY,ORDERBY
b. GROUPBY, WHERE, HAVING, ORDERBY
c. ORDERBY,GROUPBY,WHERE,HAVING
d. NONE OF THE ABOVE
 
8. which of the proper keyword to deallocate memory
a. free
b. delete
c. clear
d. remove
 
9. what is the index no of the last element of an array with 29 elements
a. 29
b. 28
c. 0
d. programmer defined
 
10. what is the final value of x when the code for(int x=0;x<10;x++) is run?
a. 10
b. 9
c. 0
d. 1
 
11. What is the data type of FILE?
a. integer
b. union
c. pointer
d. structure
 
12. if “a” is an array of 5*5 dimension, a[2][4] is same as
a. **(a+2+4)
b. *(a+2) + *(a+4)
c. **(a+2)+4
d. *(*a+2)+4)
 
13. what is the output of ..
#include<stdio.h>
void main()
{
char buffer[10]={“Genesis”};
printf(“%d”,&buffer[4]-(buffer));
}
a. 3
b. 4
c. 0
d. illegal pointer subtraction
 
14. what is the output for
#include<stdio.h>
main()
{
static int a[]={5,10,15,20};
int * ptr=a;
int ** ptr_ptr=&ptr;
printf(“\n %d”,**ptr_ptr++);
}
a. 5
b. 10
c. 15
d. 6
 
15. what is the value of expr..
1+2/3*4+1
a. 2
b. 3
c. 4
d. 4.666666
e. 5
 
16. identify the relationship between the many employees working in a dept..
a. one to one
b. one to many
c. many to one
d. many to many
 
18. The process of including some controlled redundancy for the sake of performance is known as
a. normalization
b. Cartesian product
c. De normalization
d. None
 
19. in a doubly linked list
a. the last node contains the address of the first node
b. each node contains the address of previous and next node
c. each node contains the address of previous node
d. none
 
20. in a queue each node contains
a. the address of previous node
b. address of next node
c. address of both the previous and next node
d. none of the above

Patni Placement Papers and Answers

Oracle Placement Papers V

Oracle Placement Paper Technical 2009 @ Nagpur

1. Identify the relationship between the many employees
working
in a dept..
a. one to one
b. one to many
c. many to one
d. many to many
 
2. The process of including some controlled redundancy for the sake of performance
is known as
a. normalization
b. Cartesian product
c. Denormalization
d. None
 
3. In a doubley linked list
a. the last node contains the address of the first node
b. each node contains the address of previous and next node
c. each node contains the address of previous node
d. none
 
4. In a queue each node contains
a. the address of previous node
b. address of next node
c. address of both the previous and next node
d. none of the above
 
5. can a database table exist without a primary key ?
6. whether higher normal forms better than lower forms as far redundancy is concerned ?
 
7. what is a foreign key?
8. The purpose of defining an index is
(A) Enhance Sorting Performance
(B) Enhance Searching Performance
(C) Achieve Normalization
(D) All of the above
 
9. A transaction does not necessarily need to be
(A) Consistent
(B) Repeatable
(C) Atomic
(D) Isolated
 
10. To group users based on common access permission one should use
(A) User Groups
(B) Roles
(C) Grants
(D) None of the above
 
11. PL/SQL uses which of the following
(A) No Binding
(B) Early Binding
(C) Late Binding
(D) Deferred Binding
 
12. Which of the constraint can be defined at the table level as well as at the column level
(A) Unique
(B) Not Null
(C) Check
(D) All the above
 
13. To change the default date format in a SQLPLUS Session you have to
(A) Set the new format in the DATE_FORMAT key in the windows Registry.
(B) Alter session to set NLS_DATE-FORMAT.
(C) Change the Config.ora File for the date base.
(D) Change the User Profile USER-DATE-FORMAT.
 
14. Which of the following is not necessarily an advantages of using a package rather than independent stored procedure in data base.
(A) Better performance.
(B) Optimized memory usage.
(C) Simplified Security implementation.
(D) Encapsulation.
 
15. Integrity constrains are not checked at the time of
(A) DCL Statements.
(B) DML Statements.
(C) DDL Statements.
(D) It is checked all the above cases.

Oracle Placement Papers IV

Oracle Placement Paper Aptitude & Technical On Mar 2011 @ Chennai

Aptitude section of Oracle

1. Two words are given by
Word 1: 83263641
Word 2: 3715468 ( don?t remember the order of the numbers.)
Each character is represented by a digit and each digit represents a character.
It is given that T and R occur four times. S and A occur two times. E, P, O and M occur one time each. The word
 
2. starts with T. The letter E occurs in word one only. The questions were,
a). Which number represents T.
b). Which number represents S.
c). Which character represents 2.
d). Which digit represents A.
e). Which word represents word 2.
 
3. There was a table with data related to net sales, gross profit, etc? and some questions
were asked related to it. Very easy?
 
4. A man spent 1/6th of his life in child hood, 1/12th of his life as youngster and 1/7th of his life as a bachelor. After five years of his marriage a son was born to him. The son died four years before the father died and at the time of his death his age was half the total age of his father.
The questions were,
a. What is the age of the father. (84)
b. At what age was he married.(33)
c. What is the age of his son.(42)
 
5. Rita puts 9 pairs of black socks and 8 pairs of white socks in a drawer. She takes 3 socks.
What is the probability that we get a pair of black socks.
 
6. What is the value of the following series 1/7 + 2/72 + 1/73 +2/74 + 1/75 + ???.
 
7. What should be the value of a, in the polynomials x2 ? 11x + a and x2 ? 14x + 2a, so that these two polynomials have common factors. a) 24 b)1 c)-1 d)1/2
 
8. What is the sum of all the four digit numbers formed using the digits 0, 1, 2 and 3. None of the two digits should be repeated.
 
9. a right angled triangle, the square of the hypotenuse is twice the product of the other two sides. Then one of the acute angles of the triangle is? a) 450 b) 300 c) 600 d) 150
 
10. There are two square rooms. Both are of same height. The second room is 5m longer than the first room. The rate for papering the walls is 10 paisa per square meter. The total cost for papering the rooms is Rs 60 and Rs 80. What is the height of the rooms.
 
11. There are two numbers in the ratio 8:9. if the smaller of the two numbers is increased by 12 and the larger number is reduced by 19 thee the ratio of the two numbers is 5:9.
Find the larger number.
 
12. In class of 10 students, the teacher writes a number on the board. The first student tells that the number is divisible by 1, the second student tells that the number is divisible by 2, the third by 3, the forth by 4 and so on till 10. If the statement of one of the students in wrong then what is the least number possible.
 
13. The first and the last sentences of a set of sentences are given. The middle four sentences are in jumbled form we have to select the order in which the sentences are to be placed so that they convey a meaningful message.
 
14. A passage with two paragraphs is given. Then two questions are asked based on it. Could not remember it.
 
15. A stamp collector arranges his stamps during his free time. When he arranges his stamps in pairs, there is one stamp left. It is the same when he arranges the stamps in groups of 3, 4,5 and 6. Now, how many stamps will he be left with when he arranges them in groups of 8.
Technical section of Oracle
 
16. Delete from table tempv where rowid in (select rowid from tempv where rowid in
(((select min(rowid) from tempv where ? count(*) > 1))) union(select rowid from tempv
where rowid in (((select min(rowid) from tempv where ? count(*) > 1)));
 
17. When there is a failure in fetching the rows from a cursor?
a. %isopen
b. %notfound
c. %found
d. %rowcount
 
18. Select ?oracle? from dual where null = null;
a. oracle
b. null
c. error out
d. no rows selected
 
19. here is a question of Package body and Package Specification, they have provided the
code for that describing the scenario of movie_tickets_sold and asked the programmer to
insert a block of code?., where that code block to be inserted? In Package body? or in
Package Specification?
 
20. Which of the following operator is not used in Outer Join?
a. =
b. !=
c. AND
d. OR
 
21. PL/SQL uses which of the following
a. Early Binding
b. Late binding
c. No Binding
d. Deferred Binging
 
22. Following is a database trigger, CREATE OR REPLACE TRIGGER delete_row ON
DELETE not remember the complete question.
 
23. If table contains 100 rows and it is truncated, how many rows get updated
a. 0
b. 1
c. 100
d. No rows updated
 
24. There are some questions on Basic SELECT STATEMENTS?
25. Some questions on Triggers, Procedures
 
26. VARRAYS/Nesting of Table: 1 question is there
27. NLS_DATE_FORMAT: 1 question
 
28. The size of the float data type in C language is ?
29. he size of the float data type in C language is ?
What is the output of the following C program.
Main()
{
printf(?%c?,?abcdefgh?[4]);
}
 
30. What is the o/p of the following C-program.
Main()
{ char str[7]=?strings?;
printf(?%s?,str);
}
 
31. main()
{
file *fp;
fp=fopen(?xyz?,?r?);
}
What does fp point to?
 
32. What is the maximum no. of arguments that can be given in a command line in C.
 
33. When the variables are pushed into the stack, which method is used to retrieve them from it.
a) pop b) pull c) remove d) none of these.
 
34. What is the size of integer variable in JAVA?
 
35. A programs reads ?The man and the boyrn? from a file using fgets() and stores it in str[].
Then the string stored in str is
a) ?The man and the boyrn

Oracle Placement Papers III

Oracle Placement Paper Pattern & Interview On 2011 @ Mumbai

Paper Pattern:

30 Technical Questions – Time 30 minutes. Mostly on DBMS, Oracle (like what would be the output), C, C++, Java (2-3 Questions on class and constructors) and data structures.
30 General Questions – Time 30 minutes.7 Aptitude Questions, more like English (filling up prepositions, same meaning, reading comprehension, four sentences would be given ? you have to order them to form a paragraph, similarly four questions would be given – you have to say which one is a inference statement, which one is a judgment, etc.)
The technical test would be easy and general test would be little difficult.
In the interview, they asked me the following questions:
 
1. what are the macros other than C macros (the macros in word, excel)?
Ans. A macro in MS-word is used to group a sequence of jobs and make it as a button or
keyboard shortcut. Suppose, if you need always to draw a table containing 2 rows and 5 cols,you can start,record a macro and make it as a button and put in taskbar, so that when you press it, you will be provided with a fixed table.
 
2. Can you delete a column from a table?
Ans. In oracle fine, you can do it by the statement ALTER TABLE table1 DROP COLUMN
column1; In oracle 8, you can’t.
 
3. Can you store a image in oracle and by which data type?
Ans. Yes, you can and it can be achieved by using a BLOB (binary large object) type and
store up to 4GB in a single column.
 
4. Have you used reports and forms in oracle?
 
5. Have you written applications to retrieve stored images in a table?
 
6. Some DOS commands and UNIX.
 
7. Project description (both academic and mini projects, if any)
 
8. Some situation questions like what would you do if your company is burning, etc.

Oracle Placement Papers II

Oracle Placement Paper & Interview On 2011 @ Kolkatta

1.void main()
{
struct a
{ char ch[10];
char *str;
};
struct a s1={“Hyderabad”,”Bangalore”};
printf(“\n%c%c”,s1.ch[0],*s1.str);
printf(“\n%s%s”,s1.ch,s1.str);
getch();
}
Ans: HB, HyderabadBangalor
 
2. main(int argc,int *argv[])
{ int i;
for(i=1;i<argc;i++)
printf(“\n%s%s”,argv[i],(i<argc-1)?”":”");
return 0;
getch();
}
Ans: I work for oracle
 
3.void main()
{ int i,j,k;
for(i=0;i<3;i++)
k=sum(i,i);
printf(“\n%d”,k);
getch();
}s
um(s,t)
{s
tatic int m;
m+=s+t;
return m;
}
Ans: 6
 
4.void main()
{ int i;
clrscr();
for(i=1;i<6;++i)
switch(i)
{ case 1:
case 2: printf(“%d,”,i++);break;
case 3: continue;
case 4: printf(“%d,”,i);
}
printf(“%d”,i);
getch();
}
Ans: 1,4,6
 
5.Which of the storage class(es) becomes the global variables for the entire Program
(A) Extern
(B) Static
(C) Auto
(D) Register
Ans: A
 
6. What is the output of the program
void main()
{ char s[]=”oracle is the best”;
char t[40];
char *ss,*tt;
while(*tt++=*ss++);
printf(“%s”,t);
getch();
} // A. oracle is the best
// B. Core dump
// c. Error Message
// D. Goes into infinite loop
Ans: B. core dump (Garbage value)
 
7. What is the output of the program
void main()
{ int j[10]={9,7,5,3,1,2,4,6,9};
int i=1;
clrscr();
for(;i<9;i++)
printf(“%d “,–j[i++]);
getch();
} // A. 6,2,1,5
// B. 6,2,1,5,7
// c. Error Message
// D. core dump
Ans: A. 6,2,1,5
 
8. What is the output of the program
void main()
{ int i,j,k,n=5;
clrscr();
for(i=5;i>0;i–)
{j
=1<i;
k=n&j;
k==0?printf(“0?):printf(“1?);
}
getch();
} // A. 00011
// B. 11110
// c. 11001
// D. 11100
Ans: B. 11110
 
9.Which of the following storage class(es) became the global variable for the entire
program
A. Extern
B. Static=20
C. Auto
D. Register
Ans: A
 
10.What is the output of the program, if integer occupies 2 bytes memory?
union
{ int a;
char b;
char c[10];
}u1;
void main()
{ int l=sizeof(u1);
printf(“%d”,l);
getch();
} // A. 13
// B. 10
// c. 16
// D. None of the above
Ans: B. 10
 
11.What is the output of the program
void main()
{
fork();
printf(” Hello World”);
getch();
} // A. Hello World
// B. Hello World Hello World
// c. Error Message
// D. None of these
Ans: B
 
12. What is the output of the program
void main()
{
struct a
{ int i;
char *st1;
};
typedef struct a ST;
ST *str1;
str1=(ST*)malloc(100);
str1->i=100;
strcpy(str1->st1,”Welcome to Oracle”);
printf(” %d%s\n”,str1->i,str1->st1);
getch();
} // A. core dump
// B. will not compile
// c. 100,Welcome to Oracle
// D. None of these
Ans: C
 
13. What is the output of the program
void main()
{ int i,j,k;
i=2;
j=4;
k=i++>j&2;
printf(“%d\n”,k);
if(++k && ++i<–j|| i++)
{
j=++k;
}
printf(” %d %d %d”,i,-j–,k);
getch();
} // A. 4,-3,2
// B. 5,-3,2
// c. 4,-2,2
// D. 5,-2,2
Ans: D
 
14.Which of the following is not true incase of Command line arguments
A. The argc parameter is used to hold the number of arguments in the = command line and is
an integer
B. The argv parameter is a pointer to an array of a character = pointer and each one points to
command line arguments
C. The argv[1] always point to program name
D. None of above
Ans: C
 
15. A function without any return type declares return=20
A. Integer
B. Float
C. Void
D. Syntax Error
Ans: A
 
16.What is the output of the program
#include<stdio.h>
#include<conio.h>
#define sqr(a) a*a
void main()
{ int a=10,b=1,c;
c=sqr(10+1);
printf(“Sqr Root of (10+1)is %d”,c );
getch();
} // A. 121
// B. 21
// c. 13
// D. Syntax Error
Ans: B
 
17. What is the output of the program
#include<stdio.h>
#include<conio.h>
void main()
{ int i,j=20;
clrscr();
for(i=1;i<3;i++)
{
printf(“%d,”,i);
continue;
printf(“%d”,j);
break;
}
getch();
} // A. 1,20
// B. 1,20,1,20
// c. 1,2
// D. 1,2,20,20
Ans: c
 
18. What is the output of the program
#include<stdio.h>
#include<conio.h>
void main()
{ int i=1*4/3-27%3^2+100*0.5-(4>3?1:2);
clrscr();
printf(“%d”,i);
getch();
} // A. 49
// B. compile error
// c. 51
// D. 48
Ans: b
 
19. What is the output of the program
#include<stdio.h>
#include<conio.h>
void main()
{ char *
st1[3]= {“Hello”,”World”,”Oracle”};
*st1=st1[2];
st1[1]=*st1;
free(st1[0]);
free(st1[1]);
clrscr();
printf(“%s %s %s”,st1,st1[1],st1[2]);
getch();
} // A. Garbage Garbage Oracle
// B. oracle oracle oracle
// C. Hello World Oracle
// D. Core Dump:cannot Print after freeing the memory
Ans: D
 
20.Consider the following structure
Struct {
int data;
struct node *prev;
struct node *next;
}NODE;
NULL <– 5 –> 8 –> 10 –> NULL
p <– q <– r=20
WHAT WILL BE THE VALUE OF r–>prev–>–>next–>data
?
A. 8
B. Null
C. 5
D. 10
Ans: 10
 
21. What will be the output of the fallowing SELECT statement ?
SELECT count(*)
FROM emp
Where exist (select ‘X’ From dept
Where dept_name =’Stores’ and dept.dept_id=emp.dept_id)
A. select total number of employees belonging to department ” stores ”
B. select all employees belonging to department “X”
C. select all employees belonging to department “stores”
D. select total number of employees belonging to department “X”
 
22. Denormalisation is done to
A. Check for Data Integrity
B. Reduce Data Redundancy
C. Intoduce Security Check
D. Increase Query performance .
 
23. How many columns are retrived from this query:
SELECT address1 || ‘,’ ||address2 ||’,’
||address2 “Address” FROM =
employee;
A. 3
B. 2
C. 1
D. 0
 
24. What is the is the result of the fallowing Code
Piece=20
Insert into table A value(a1):
CREATE TABLE B AS SELECT * FROM A;
ROLLBACK ;
A. Table B gets created with the row inserted in the first statement.
B. Table B is not created
C. Table B gets created , but no row gets inserted into Table A
D. Rollback throws up an exception .
 
25. The key word used in Oracle for string searching is
A. SOUNDEX
B. DECODE
C. LIKE
D. HAVING
 
26. What does the ROLLBACK statement will do in the fool segment of code
PROGRAM STARTS HERE
……..
SOME DML STAT.
…SAVEPOINT1
SOME DML STAT.
…SAVEPOINT2
SOME DML STAT.
…ROLLBACK
A. Rollback Dml changes to savepoint 1
B. Rollback Dml changes to savepoint 2
C. Rollback Dml changes of the last DML ststs. just before = ROllback stats
D. Rollback DML changes to the place whre the program starts
 
27. Which clause u use to exclude the rows before grouping them?
A. Group By
B. Having
C. Where
D. Minus
 
28. Which of the following statements is not true about views?
A. you can create a index on views
B. Views do not have permanent data
C. Views can be based on one or more tables
D. Views can be dropped without dropping tables
 
29 How many JION conditions are needed in JOIN query to avoid a Cartesian Product?
A. No of tables + 1
B. No of tables – 1
C. No of colums + 1
D. No of colums – 1
 
30. “An item could be either a component or spare “.
How can you represent this scenerio in a E-R=20
A. Subtype Relation
B. Arc Relation
C. Recursive Relation
D. Many to Many Relationscription