Friday, December 31, 2010

Lawyers and engineers

Three lawyers and three engineers are traveling by train to a conference. At the station, each of the three lawyers buys a ticket while the three engineers buy only one ticket.
“How can the three of you travel on one ticket?” asks a lawyer.

“Watch and you’ll see,” answers an engineer.
Aboard the train the lawyers take their respective seats while all three engineers cram into the restroom and squeeze the door closed behind them.
When the conductor comes around collecting tickets, he knocks on the restroom door and says, “Ticket, please.” The door opens a crack and a single arm emerges with a ticket in hand. The conductor takes it and moves on.
The lawyers are impressed with this clever idea. One the way home from the conference, they decide to copy the engineers’ technique. At the station, they buy a single ticket for their return trip. To their astonishment, the engineers don’t buy a ticket at all!
“How in the hell are you going to pull this off?” asks a lawyer.
“Watch and you’ll see,” answers an engineer.
They board the train. The three lawyers cram into one restroom and the three engineers cram into the other restroom.
Shortly after the train departs, one of the engineers leaves his restroom and knocks on the other restroom door. “Ticket, please!”

Color Of Friendhip

Once upon a time the colors of the world started to quarrel: all claimed that they were the best, the most important, the most useful, the favorite.

GREEN said: “Clearly I am the most important. I am the sign of life and of hope. I was chosen for grass, trees, leaves - without me, all animals would die. Look over the countryside and you will see that I am in the majority.”

BLUE interrupted: “You only think about the earth, but consider the sky and the sea. It is the water that is the basis of life and, drawn up by the clouds, forms the deep sea. The sky gives space and peace and serenity. Without my peace, you would all be nothing.”
YELLOW chuckled: “You are all so serious. I bring laughter, gaiety, and warmth into the world. The sun is yellow, the moon is yellow, the stars are yellow. Every time you look at a sunflower, the whole world starts to smile. Without me there would be no fun.”
ORANGE started next to blow her trumpet: “I am the color of health and strength. I may be scarce, but I am precious for I serve the needs of human life. I carry the most important vitamins. Think of carrots, pumpkins, oranges, mangoes, and pawpaws. I don’t hang around all the time, but when I fill the sky at sunrise or sunset, my beauty is so striking that no one gives another thought to any of you.”

RED could stand it no longer. He shouted out: “I am the ruler of all of you - I am blood - life’s blood! I am the color of danger and of bravery. I am willing to fight for a cause. I bring fire into the blood. Without me, the earth would be empty as the moon. I am the color of passion and of love, the red rose, the poinsettia and the poppy.”

PURPLE rose up to his full height. He was very tall and spoke with great pomp: “I am the color of royalty and power. Kings, chiefs, and bishops have always chosen me for I am the sign of authority and wisdom. People do not question me - they listen and obey.”
Finally, INDIGO spoke, much more quietly than all the others, but with just as much determination: “Think of me. I am the color of silence. You hardly notice me, but without me you all become superficial. I represent thought and reflection, twilight and deep water. You need me for balance and contrast, for prayer and inner peace.”

And so the colors went on boasting, each convinced of his or her own superiority. Their quarreling became louder and louder. Suddenly there was a startling flash of bright lightening - thunder rolled and boomed. Rain started to pour down relentlessly. The colors crouched down in fear, drawing close to one another for comfort.
In the midst of the clamor, rain began to speak: ” You foolish colors, fighting amongst yourselves, each trying to dominate the rest. Don’t you know that you were each made for a special purpose, unique and different? Join hands with one another and come to me.”
Doing as they were told, the colors united and joined hands. The rain continued: “From now on, when it rains, each of you will stretch across the sky in a great bow of color as a reminder that you can all live in peace. The RAINBOW is a sign of hope for tomorrow.”

And so, whenever a good rain washes the world, and a rainbow appears in the sky, let us remember to appreciate one another.

Tuesday, December 28, 2010

Be Happy Right Now

We convince ourselves that life will be better after we get married,

have a baby, then another, get a new job, get a new house.

Then we are frustrated that the kids aren't old enough

and we'll be more content when they are.

The truth is, there's no better time to be happy than

right now! If not now, when?

Your life will always be filled with challenges.

It's best to admit this to yourself and decide to be happy anyway.

Happiness is the way.

So, treasure every moment that you have and

treasure it more because you shared it with someone special,

special enough to spend your time with...

And remember that time waits for no one!

So, stop waiting...

...until your car or home is paid off

...until you get a new car or a new job

...until you go back to school

...until you lose ten pounds

...until you gain ten pounds

...until you finish school

...until you get married

...until you get a divorce

...until you have kids

...until your kids leave the house

...until you retire

...until summer

...until fall

...until winter

...until spring

...until you die!

There is no better time than right now to be happy...

Choose To Be Happy TODAY!

Monday, December 27, 2010


A little boy came up to his mother in the kitchen one evening while she was fixing supper, and handed her a piece of paper that he had been writing on. After his Mom dried her hands on an apron, she read it, and this is what it said:

For cutting the grass: $5.00
For cleaning up my room this week: $1.00
For going to the store for you: $.50
Baby-sitting my kid brother while you went shopping: $.25
Taking out the garbage: $1.00
For getting a good report card: $5.00
For cleaning up and raking the yard: $2.00
Total owed: $14.75

Well, his mother looked at him standing there, and the boy could see the memories flashing through her mind. She picked up the pen, turned over the paper he'd written on, and this is what she wrote:

For the nine months I carried you while you were growing inside me:
No Charge

For all the nights that I've sat up with you, doctored and prayed for you:
No Charge

For all the trying times, and all the tears that you've caused through the years:
No Charge

For all the nights that were filled with dread, and for the worries I knew were ahead:
No Charge

For the toys, food, clothes, and even wiping your nose:
No Charge

Son, when you add it up, the cost of my love is:
No Charge.

When the boy finished reading what his mother had written, there were big tears in his eyes, and he looked straight at his mother and said, "Mom, I sure do love you." And then he took the pen and in great big letters he wrote: "PAID IN FULL".

You will never how much your parents worth till you become a parent
Be a giver not an asker, especially with your parents. there is a lot to give, besides money.

Thursday, December 23, 2010


A crow was sitting on a tree, doing nothing all day. A rabbit asked him,”Can I also sit like you and do nothing all day long?” The crow answered: “Sure, why not.” So, the rabbit sat on the ground below the crow, and rested.

A fox jumped on the rabbit and ate it.

Moral of the story: To be sitting and doing nothing, you must be sitting very high up


A sales rep, an administration clerk, and the manager are walking to lunch when they find an antique oil lamp. They rub it and a Genie comes out. The Genie says, “I’ll give each of you just one wish” “Me first! Me first!” says the admin. clerk. “I want to be in the Bahamas, driving a speedboat, without a care in the world.” Poof! She’s gone. “Me next! Me next!” says the sales rep. “I want to be in Hawaii,relaxing on the beach with my personal masseuse, an endless supply of Pina Coladas and the love of my life.” Poof! He’s gone. “OK, you’re up,” the Genie says to the manager. The manager says, “I want those two back in the office after lunch.”

Moral of the story: Always let your boss have the first say.

Wednesday, December 22, 2010

Why Goals are Important?

On the best sunny day, the most powerful magnifying glass will not light paper if you keep moving the glass. But if you focus and hold it, the paper will light up. That is the power of concentration.

A man was traveling and stopped at an intersection. He asked an elderly man, "Where does this road take me?" The elderly person asked, "Where do you want to go?" The man replied, "I don't know." The elderly person said, "Then take any road. What difference does it make?"

How true. When we don't know where we are going, any road will take us there.

Suppose you have all the football eleven players, enthusiastically ready to play the game, all charged up, and then someone took the goal post away. What would happen to the game? There is nothing left. How do you keep score? How do you know you have arrived?

Enthusiasm without direction is like wildfire and leads to frustration. Goals give a sense of direction. Would you sit in a train or a plane without knowing where it was going? The obvious answer is no. Then why do people go through life without having any goals?

Monday, December 20, 2010

MP3 Player Innovative Concept

Much like his Fluid Smartphone, Brazilian designer Dinard da Mata has developed another wearable gadget that becomes a fashion accessory to complement the style of next-gen users. Hailed as “MP3 Player Creative,” the portable music player features a flexible OLED screen that other than displaying the playlist also lets the user select the song or control volume with just a touch of a finger. Worn around the wrist like a bracelet, the MP3 concept gives easy access of the functions to the user. In addition, the sleek music player includes wireless headphones to offer clutter-free music on the go.

Mountain Story

"A son and his father were walking on the mountains.
Suddenly, his son falls, hurts himself and screams: "AAAhhhhhhhhhhh!!!"
To his surprise, he hears the voice repeating, somewhere in the mountain: "AAAhhhhhhhhhhh!!!"
Curious, he yells: "Who are you?"
He receives the answer: "Who are you?"
And then he screams to the mountain: "I admire you!"
The voice answers: "I admire you!"
Angered at the response, he screams: "Coward!"
He receives the answer: "Coward!"
He looks to his father and asks: "What's going on?"
The father smiles and says: "My son, pay attention."
Again the man screams: "You are a champion!"
The voice answers: "You are a champion!"
The boy is surprised, but does not understand.
Then the father explains: "People call this ECHO, but really this is LIFE.
It gives you back everything you say or do.
Our life is simply a reflection of our actions.
If you want more love in the world, create more love in your heart.
If you want more competence in your team, improve your competence.
This relationship applies to everything, in all aspects of life;
Life will give you back everything you have given to it." 



Friday, December 17, 2010

Women Brain

One night President Obama and his wife Michelle decided to do something out of routine and go for a casual dinner at a restaurant that wasn't too luxurious.

When they were seated, the owner of the restaurant asked the president's secret service if he could please speak to the First Lady in private. They obliged and Michelle had a conversation with the owner.

Following this conversation President Obama asked Michelle, why was he so interested in talking to you. She mentioned that in her teenage years, he had been madly in love with her.

President Obama then said, "so if you had married him, you would now be the owner of this lovely restaurant" , to which Michelle responded, "no, if I had married him, he would now be the President"

Create Database Manually

Hello all,

This sql script help to  create databse manually.





GROUP 1 ('/disk2/oradata9i/oracle/test/redo01.log') SIZE 100M,

GROUP 2 ('/disk2/oradata9i/oracle/test/redo02.log') SIZE 100M,

GROUP 3 ('/disk2/oradata9i/oracle/test/redo03.log') SIZE 100M








DATAFILE '/disk2/oradata9i/oracle/test/system01.dbf' SIZE 320M REUSE



TEMPFILE '/disk2/oradata9i/oracle/test/temp01.dbf'SIZE 200M REUSE


DATAFILE '/disk2/oradata9i/oracle/test/undotbs01.dbf'

For Remaing process chc  this link.

Wednesday, December 15, 2010

Pay Attention


1st year students of MBBS were attending their 1st anatomy class.
They all gathered around the surgery table with a real dead dog.
The Professor started class by telling two important qualities as a Doctor.

e.g. He inserted his finger in dog's mouth & on drawing back tasted it in his own mouth.

Then he said them to do the same.
The students hesitated for several minutes.
But eventually everyone inserted their fingers in dog's mouth & then tasted it.

When everyone finished, the Professor looked at them and said:
The most important 2nd quality is “OBSERVATION,” I inserted my Middle finger but tasted the Index finger.

Now learn to pay attention.

Life is tough but it’s a lot tougher when you are not paying attention.

Wednesday, December 8, 2010

A Room With A View

Two men, both seriously ill, occupied the same hospital room. One man was allowed to sit up in his bed for an hour each afternoon to help drain the fluid from his lungs. His bed was next to the room's only window. The other man had to spend all his time flat on his back. The men talked for hours on end. They spoke of their wives and families, their homes, their jobs, their involvement in the military service, where they had been on vacation. And every afternoon when the man in the bed by the window could sit up, he would pass the time by describing to his roommate all the things he could see outside the window. The man in the other bed began to live for those one-hour periods where his world would be broadened and enlivened by all the activity and color of the world outside.

The window overlooked a park with a lovely lake. Ducks and swans played on the water while children sailed their model boats. Young lovers walked arm in arm amidst flowers of every color of the rainbow. Grand old trees graced the landscape, and a fine view of the city skyline could be seen in the distance. As the man by the window described all this in exquisite detail, the man on the other side of the room would close his eyes and imagine the picturesque scene.

One warm afternoon the man by the window described a parade passing by. Although the other man couldn't hear the band - he could see it in his mind's eye as the gentleman by the window portrayed it with descriptive words. Days and weeks passed. One morning, the day nurse arrived to bring water for their baths only to find the lifeless body of the man by the window, who had died peacefully in his sleep. She was saddened and called the hospital attendants to take the body away.

As soon as it seemed appropriate, the other man asked if he could be moved next to the window. The nurse was happy to make the switch, and after making sure he was comfortable, she left him alone. Slowly, painfully, he propped himself up on one elbow to take his first look at the world outside. Finally, he would have the joy of seeing it for himself. He strained to slowly turn to look out the window beside the bed. It faced a blank wall.

The man asked the nurse what could have compelled his deceased roommate who had described such wonderful things outside this window. The nurse responded that the man was blind and could not even see the wall. She said, "Perhaps he just wanted to encourage you."


There is tremendous happiness in making others happy, despite our own situations. Shared grief is half the sorrow, but happiness when shared, is doubled. If you want to feel rich, just count all of the things you have that money can't buy.

The Most Important Lesson

During my second month of nursing school, our professor gave us a pop quiz. I was a conscientious student and had breezed through the questions, until I read the last one: "What is the first name of the woman who cleans the school?" Surely, this was some kind of joke.

I had seen the cleaning woman several times. She was tall, dark-haired and in her 50s, but how would I know her name? I handed in my paper, leaving the last question blank.
Just before class ended, one student asked if the last question would count toward our quiz grade. "Absolutely," said the professor. "In your careers, you will meet many people. All are significant. They deserve your attention and care, even if all you do is smile and say 'hello'." "I've never forgotten that lesson. I also learned her name was Dorothy

Make a Difference

A man was walking down a deserted Mexican beach at sunset. As he walked along he began to see another man in the distance.

As he grew nearer he noticed that the local native kept leaning down, picking something up, and throwing it out into the water. Time and again he kept hurling things out into the ocean.
As our friend approached even closer he noticed that the man was picking up starfish that had washed up onto the beach, and one at a time, he was throwing them back into the ocean.
The first man was puzzled. He approached the man and said, "Good Evening Friend, I was wondering what are you doing?" And he replied, "I'm throwing these starfish back into the ocean. You see, it's low tide right now and all these starfish have been washed up onto the shore. If I don't throw them back into the sea, they will die from the lack of oxygen."

"I understand," my friend replied "but there must be thousands of starfish on this beach and you couldn't possibly get to all of them. There are simply too many and don't you realize that this is happening on hundreds of beaches up and down this coast ... can't you see that that you can't possibly make a difference?

The local native smiled, bent down, picked up yet another starfish ... and as he threw it back out into the sea, he replied, "It made a difference to that one!"

You may feel like you cannot make a difference in the world today, but you CAN make a difference in one life at a time.


       Mahatma Gandhi went from city to city, village to village collecting funds for the Charkha Sangh. During one of his tours he addressed a meeting in Orissa. After his speech a poor old woman got up. She was bent with age, her hair was grey and her clothes were in tatters. The volunteers tried to stop her, but she fought her way to the place where Gandhiji was sitting. "I must see him," she insisted and going up to Gandhiji touched his feet. Then from the folds of her sari she brought out a copper coin and placed it at his feet. Gandhiji picked up the copper coin and put it away carefully. The Charkha Sangh funds were under the charge of Jamnalal Bajaj. He asked Gandhiji for the coin but Gandhiji refused. "I keep cheques worth thousands of rupees for the Charkha Sangh," Jamnalal Bajaj said laughingly "yet you won't trust me with a copper coin." "This copper coin is worth much more than those thousands," Gandhiji said. "If a man has several lakhs and he gives away a thousand or two, it doesn't mean much. But this coin was perhaps all that the poor woman possessed. She gave me all she had. That was very generous of her. What a great sacrifice she made. That is why I value this copper coin more than a crore of rupees."


In 1883, a creative engineer named John Roebling was inspired by an idea to build a spectacular bridge connecting New York with the Long Island. However bridge building experts throughout the world thought that this was an impossible feat and told Roebling to forget the idea. It just could not be done. It was not practical. It had never been done before.

Roebling could not ignore the vision he had in his mind of this bridge. He thought about it all the time and he knew deep in his heart that it could be done. He just had to share the dream with someone else. After much discussion and persuasion he managed to convince his son Washington, an up and coming engineer, that the bridge in fact could be built.
Working together for the first time, the father and son developed concepts of how it could be accomplished and how the obstacles could be overcome. With great excitement and inspiration, and the headiness of a wild challenge before them, they hired their crew and began to build their dream bridge.

The project started well, but when it was only a few months underway a tragic accident on the site took the life of John Roebling. Washington was injured and left with a certain amount of brain damage, which resulted in him not being able to walk or talk or even move.
"We told them so."
"Crazy men and their crazy dreams."
"It`s foolish to chase wild visions."

Everyone had a negative comment to make and felt that the project should be scrapped since the Roeblings were the only ones who knew how the bridge could be built. In spite of his handicap Washington was never discouraged and still had a burning desire to complete the bridge and his mind was still as sharp as ever.
He tried to inspire and pass on his enthusiasm to some of his friends, but they were too daunted by the task. As he lay on his bed in his hospital room, with the sunlight streaming through the windows, a gentle breeze blew the flimsy white curtains apart and he was able to see the sky and the tops of the trees outside for just a moment.
It seemed that there was a message for him not to give up. Suddenly an idea hit him. All he could do was move one finger and he decided to make the best use of it. By moving this, he slowly developed a code of communication with his wife.

He touched his wife's arm with that finger, indicating to her that he wanted her to call the engineers again. Then he used the same method of tapping her arm to tell the engineers what to do. It seemed foolish but the project was under way again.

For 13 years Washington tapped out his instructions with his finger on his wife's arm, until the bridge was finally completed. Today the spectacular Brooklyn Bridge stands in all its glory as a tribute to the triumph of one man's indomitable spirit and his determination not to be defeated by circumstances. It is also a tribute to the engineers and their team work, and to their faith in a man who was considered mad by half the world. It stands too as a tangible monument to the love and devotion of his wife who for 13 long years patiently decoded the messages of her husband and told the engineers what to do.

Perhaps this is one of the best examples of a never-say-die attitude that overcomes a terrible physical handicap and achieves an impossible goal.

Often when we face obstacles in our day-to-day life, our hurdles seem very small in comparison to what many others have to face. The Brooklyn Bridge shows us that dreams

that seem impossible can be realised with determination and persistence, no matter what the odds are.

Alexander Fleming

His name was Fleming, and he was a poor Scottish farmer. One day, while trying to eke out a living for his family, he heard a cry for help coming from a nearby bog. He dropped his tools and ran to the bog. There, mired to his waist in black muck, was a terrified boy, screaming and struggling to free himself. Farmer Fleming saved the lad from what could have been a slow
and terrifying death.

The next day, a fancy carriage pulled up to the Scotsman's sparse surroundings. An elegantly dressed nobleman stepped out and introduced himself as the father of the boy Farmer Fleming had saved.

"I want to repay you," said the nobleman. "You saved my son's life."

"No, I can't accept payment for what I did," the Scottish farmer replied, waving off the offer. At that moment, the farmer's own son came to the door of the family hovel.

"Is that your son?" the nobleman asked. "Yes," the farmer replied proudly.

"I'll make you a deal. Let me take him and give him a good education.

If the lad is anything like his father, he'll grow to a man you can be proud of."

And that he did. In time, Farmer Fleming's son graduated from St. Mary's Hospital Medical School in London, and went on to become known throughout the world as the noted Sir Alexander Fleming, the discoverer of Penicillin.

Years afterward, the nobleman's son was stricken with pneumonia.

What saved him? Penicillin.

The name of the nobleman? Lord Randolph Churchill.

His son's name? Sir Winston Churchill.

Thursday, November 25, 2010

Puppies For sale

A farmer had some puppies he needed to sell. He painted a sign advertising the pups and set about Nailing it to a post on the edge of his yard. As he was driving the last nail into the post, he Felt a tug on his overalls. He looked down into the Eyes of a little boy.
Mister," he said, "I want to buy one of your puppies."
"Well," said the farmer, as he rubbed the sweat off the back of his neck, "these puppies come from fine parents and cost a good deal of money."
The boy dropped his head for a moment. Then reaching deep into his pocket, he pulled out a handful of change and held it up to the farmer. "I've got thirty-nine cents. Is that enough to take a look?"
"Sure," said the farmer.
And with that he let out a whistle,"Here,Dolly!" he called.
Out from the doghouse and down the ramp ran Dolly followed by four little balls of fur. The little boy pressed his face against the chain link fence. His eyes danced with delight.

As the dogs made their way to the fence, the little boy noticed something else stirring inside the doghouse. Slowly another little ball appeared; this One noticeably smaller. Down the ramp it slid. Then in a somewhat awkward manner the little pup began hobbling toward the others, doing its best to catch up....
"I want that one," the little boy said, pointing to the runt.
The farmer knelt down at the boy's side and said, "Son, you don't want that puppy. He will never be able to run and play with you like these other dogs would."
With that the little boy stepped back from the fence, reached down, and began rolling up one leg of his trousers. In doing so he revealed a steel brace running down both sides of his leg attaching itself To a specially made shoe. Looking back up at the farmer, he said, "You see sir, I don't run too well myself, and he will need Someone who understands."

The world is full of people who need someone who understands.

Tuesday, November 23, 2010

Funny chating 2

A  woman in a hot air balloon realized she was lost. She reduced altitude and spotted
a man below. She descended a bit more and shouted, "Excuse me sir, can you help me?
I promised a friend I would meet him an hour ago but I don't know where I am."
The man below replied, "You're in a hot air balloon hovering approximately 30 feet above
the ground. You're between 40 and 41 degrees north latitude and between 59 and 60 degrees west longitude."
  ';'You must be an engineer," said the lady balloonist.
"I am", replied the man. 'How did you know?'
';'Well", answered the lady in the balloon, "everything you told me is technically correct, but I've no idea what to make of your information, and the fact is I'm still lost. Frankly,
you've not been much help to me at all. If anything, you've delayed my trip
even more."
  The engineer below responded, "You must be in Top Management."
  ';'I am", replied the lady balloonist, "but, how did you know?''
"Well," said the Engineer, "You don't know where you are, or where you're going. You
made a promise, which you've no idea how to keep, and you expect people beneath you,
to solve your problems."

Monday, November 22, 2010

Funny chating

Women Friends chatting in office.

Woman 1: I had a fine evening, how was yours?

Woman 2: it was a disaster. My husband came home, ate his dinner in three minutes and fell asleep in two minutes. How was yours?

Woman 1: Oh it was amazing! My husband came home and took me out to a romantic dinner. After dinner we walked for an hour. When we came home he lit the candles around the house and afterwards talked for an hour. It was like a fairytale!

At the same time, their husbands are talking at work.

Husband 1: How was your evening?

Husband 2: Great. I came home, dinner was on the table, I ate and fell asleep. It was great! What about you?

Husband 1: It was horrible. I came home, there's no dinner because they cut the electricity because I hadn't paid the bill; so I had to take my wife out to dinner which was so expensive that I didn't have money left for a cab. We had to walk home which took an hour; and when we got home remember there was no electricity so I had to light candles all over the house! After all, I was so aggravated that I couldn't fall asleep and my wife was jabbering away for another hour!

Monday, October 25, 2010

Larsen & Toubro Infotech Ltd

Larsen & Toubro Infotech Ltd (

Larsen & Toubro Infotech Ltd. (L & T Infotech) is a wholly-owned subsidiary of US $ 9.8 billion. Larsen & Toubro, India's leading engineering, manufacturing & financial services organization. It is ranked 7th in DATAQUEST Top 20 Best employers - IT 2010 list.
Freshers Walk-In : BE / B.Tech / MCA : 2010 Passout @ Bangalore
We need Graduate Engineers and MCA for our Development Centres in Chennai, Bangalore, Mysore, Mumbai and Pune

Job Position : Fresher
Job Category : IT / Software
Walk-In Location : Bangalore, Karnataka
Desired Qualification :

• BE / B.Tech / MCA
. Year of Passing: 2010.
• Eligibility: Minimum 60% marks throughout academic career (10th / 12th / Graduation / Post Graduation).
 Not more than 2 backlogs / ATKT / re-attempts during engineering / MCA.
• No ATKT's in the final year of BE / B.Tech / MCA.
• Age Limit: BE / B.Tech 24 years, MCA 25 years as on July, 1 2010.

Desired Experience : 0 Years

Candidates must carry the following documents :

• Updated Resume.

• Photo Identity Proof.

• Photocopies of mark sheets of 10th & 12th, Graduation & Post Graduation. (All Semesters)

• Two passport size photographs.

• A filled copy of the initial screening form.

Note: Eligible candidates can walk in for a written test.

Note: Candidates are requested to carry a filled copy of the initial screening form. The form can be downloaded from the link provided below.

Walk-In Date : On 23rd & 24th October 2010 (Saturday & Sunday)

Time : 9:00 AM to 3:00 PM on both days.

Venue :

Larsen & Toubro Infotech Ltd,

Plot No. 25 - 31,

EPIP 2nd Phase,

KIADB Industrial Area, Whitefield,

Bengaluru - 560 066

Contact Person : Rutuja Bhosle

Wednesday, October 13, 2010


Freshers Walk-In : Microsoft Technologies @ Chennai

Job Position : Software Engineer Trainee / Software Engineer
Job Category : IT / Software
Job Location : Chennai, Tamilnadu
Salary : As per industry standards
Desired Education : BE, MCA, M.Sc (CSC), B.Tech (IT)
Desired Experience : 0 to 1 Years
Mandatory Skills : Windows Forms, VB.NET, Crystal Reports, SQL Server
Other Skills : ASP.Net, C#, Windows Mobile

Note: Candidates without good knowledge in above mentioned technical skills will NOT be allowed.

Note: Eligible candidates can walk-in with their updated resume.

Note: You can mention the reference as 'ChetanaS'.

Walk-In Date : On 12th, 13th & 14th October 2010 : 11:30 AM to 4:00 PM

Venue :

Firestream World Wide Inc,

No:39, Ganesh Enclave Building,

1st Floor, Gopalapuram 1st Street,


Chennai - 86

Contact Person : Deepika Bhaskar (Senior HR - Executive)

Contact Number : +91-44-52035858

Thursday, October 7, 2010


Inviting Engineering and Science Graduates

to Opportunities Beyond Boundaries

Wipro Technologies, a leading global IT services company offers bright young minds exciting careers at locations across India. Discover a world of learning, growth, innovation and equal opportunities with us. We provide young graduates with a strong career path, enabling them to be world-class IT professionals.

To experience a challenging work environment, motivated team and best-in-class technology, you can join us in the programs mentioned below.
Science Graduates of 2010 for WASE

Wipro Academy of Software Excellence (WASE) gives you an unique option of pursuing an MS degree from the well renowned BITS, Pilani and simultaneously earn at Wipro Technologies. Now,
you have the advantage of learning while working as a qualified IT professional at Wipro.
Eligibility Criteria

• B.Sc. (CS/IT/Electronics/Physics/Mathematics/Statistics) / BCA / BCM

• 50% aggregate marks in X & XII

• 60% aggregate marks in Graduation

• Mathematics as one subject in 12th - Mandatory
Students can click here to apply online to the job

Science Graduates of 2011 for WASE

Students graduating in the year 2011 can click here to apply to WASE

Upon registering, you will be called shortly for an interview with us.

Eligibility for WASE 2011 remains the same as above.

Engineering Graduates of 2010
Engineering Graduates of 2010 Wipro's reputation as a pioneering and innovative company in the global

technology landscape makes it a determined choice for the best of talented engineers. We invite you to exciting opportunities with us in the software engineering space.

Eligibility Criteria

• BE, B.Tech, MCA / ME, M.Tech, MS

• Minimum 50% in X & XII

• 60% in Graduation and Post Graduation (if applicable)

Students who have graduated in the year 2010 can click here to apply
Upon registering, you will be called shortly for an interview with us.

Wipro has been recognized for nurturing graduates from all streams and grooming them into world-class IT professionals. If you are interested in being a part of Wipro other than WASE and work on live IT projects.
You can apply online to the job
Upon registering, you will be called shortly for an interview with us.

BE/B.Tech/MCA/M.Tech, MS Graduates can apply online to the job Code 135 on and will be contacted shortly.

Graduates interested in a career at Wipro, other than WASE can also apply online to the job code 119 on and will be contacted shortly.

For More Details:

Wednesday, September 22, 2010

Unibros Technologies,

Unibros Technologies:

(0-2 Years) Walk-In : Web Designers @ Chennai

Job Position : Web Designer (DreamWeaver / PhotoShop)

Job Location : Chennai, Tamilnadu
Desired Qualification : Graduate / Post Graduate with Computer Science Background.

Desired Experience : 0 to 2 Years

Mandatory Skills : Web Designing (DreamWeaver / PhotoShop)

Desired Skills :

• Experienced in PHP, CMS, Paint Shop, Adobe Illustrator or PhotoShop, Dream Weaver.

• Hands on HTML5, XHTML, Flex, DOM, Action Script, CSS, CMS, JavaScript.

• Should have experience in design.

• Should posses problem solving skills.

• Ability to work well within a team.

• Excellent in communication skills.

• Should have experience in Coding & Development.

Note: Freshers who already completed a Web Design Course/Certification are also eligible to apply. They need to show the Certificate at the interview. Otherwise, they will NOT be allowed.

Walk-In Date : From 22nd September 2010 to 10th October 2010 (Monday to Friday) : 10.30 AM to 1.30 PM

Venue :

Unibros Technologies,

No 6, Alagesan Street,

West Tambaram,

Chennai - 45

Landmark: Opp. Lane to Viveks / Girias Showroom

Tuesday, September 21, 2010

Freshers : Web Designers @ Chennai

Job Position : Web Designer

Job Role : Web Designer & Developer

Job Category : IT / Software

Job Location : Chennai, Tamilnadu

Functional Area : Web Design and Development

Desired Qualification :
UG - B.Sc (Computer Science) / BCA / BE (CS/IT)
PG - M.Sc (Computer Science/IT) / MCA)

Desired Experience : Freshers

Mandatory Skills : Web Designing

Desired Skills :
• Knowledge of Photoshop, Dreamweaver CS3, JavaScript, HTML/XHTML, CSS, and Ajax.
• Designs created should be very creative and user friendly.
• Knowledge of Adobe Flash, Wordpress, Joomla, Magento Templates is desirable.
• Able to work independently on a project.
• Able to meet project deadlines.

Job Description :
• Planning, designing, and implementing international Website Layout Design.
• Table / DIV Based Design.
• Knowledge in Photoshop and flash.
• Knowledge in HTML, CSS, XHTML, Dreamweaver, JS, and Web2.0 technology.
• HTML conversion of templates.

Keywords : Web Designer, HTML, JavaScript, CSS, Flash, Adobe suite, Photoshop , Corel Draw, Illustrator.

For Apply:

Wednesday, September 15, 2010


Ideas2IT Technologies (
We are a product based software development company.

Some of the customers for our flagship Radaptive( product are Microsoft, Ebay, Paypal, & Motorola.

We also incubate start up ideas like, and more.

Java Freshers
We are looking for freshers with

- Sound problem solving skills and good fundamentals in Java.
We work on the cutting edge of technology - latest J2EE frameworks, Ruby/Rails, iPhone apps, Facebook application development.

- Great attitude
We are a happy family and have fun working with each other and want to keep it that way.

- Good work ethics
We have a pretty flat hierarchy with very little management. So good ethics is very much valued.

Selection Procedure :
• Screening test ( Aptitude, English, Technical) - 45 Mins
• Technical Interview
• HR Interview.

Qualification :
• B.E/ B.Tech/ M.C.A/ M.Sc Comp.Sc / M.Sc IT - 2010 Batch

Job Location : Chennai

Desired Experience : 0 Years

Tuesday, September 7, 2010


You are given two candles of equal size, which can burn 1 hour each. You have

to measure 90 minutes with these candles. (There is no scale or clock). Also u r

given a lighter.

Ans: 1. First light up the two ends of the 1st candle. When it will burn out light up

one end of the second candle. (30+60=90)

2. Try the similar problem to measure 45 minutes.

Ans: First light-up the two ends of the 1st candle and one end of the 2nd candle.

When the 1st candle will burn out ,then light up the both ends of the 2nd candle


3. You r given a thermometer. What can u do by this without measuring the


Ans: if u put thermometer into a tree it won?t grow anymore, will just die off

4. How it is possible to place four points that are equidistance from each other?


U r a landscape designer and your boss asked u to design a landscape such

that you should place 4 trees equidistance from each other.

(Distance from each tree to the other must be same)

Ans: Only 3 points can be equidistant from each other. But if u place points in the

shape of a pyramid then its possible

5. You are given a cake; one of its corner is broken. How will u cut the rest into

Two equal parts?

Ans: Slice the cake

6. How will you recognize the magnet & magnetic material & non-magnetic material?

Ans: Drag one piece of material over another. There is no attractive force in the

middle portion of the magnet.


Get a piece of thread and tie up with the one bar and check for poles. If it iron bar

then it moves freely and if it is magnetic bar then it fix in one direction according to


7. If one tyre of a car suddenly gets stolen.... and after sometime u find the tyre

without the screws how will u make ur journey complete?

Ans: Open 3 screws, 1 from each tyre and fix the tyre.

8. How can u measure a room height using a thermometer?

Ans: temp varies with height. but its dependent on various other factors like

humidity, wind etc.

9. What is the height of room if after entering the room with a watch ur head

strikes a hanging bulb?

Ans: Oscillate the hanging bulb. Calculate the time period for one complete

oscillation by Simple Harmonic Motion (SHM) of the handing bulb. Put it in the

formula T=2 * 3.14 * (L/G)^1/2

L will be the length of the hanging thread.

Add the L with ur height to get the height of the room.


Ans: Drop it from the room and find the time at which it strikes the floor. Using

physics formula s = (at^2)/2 (IM NOT SURE ABOUT THIS ONE)

10. Color of bear.... if it falls from 1m height in 1s.

Ans: We get 'g' perfect 10 which is only in poles...hence polar bear...color White

11. How will you measure height of building when you are at the top of the building?

And if you have stone with you.

Ans: Drop the stone and find the time taken for the stone to reach the ground. find

height using the formula

s = a + gt ( s = height, a= initial velocity=0, g=9.8m/s, t = time taken)

12. How wud u catch and receive a ball in same direction? (Dropping is from north

And receiving from bottom not accepted, as it is 2 directions)

Ans: ?

13. 25 statements given. Some tell truth, some false and some alternators. Find out

the true statements.

Ans: ?

14. Can u make 120 with 5 zeros?

Ans: Factorial (factorial (0)+factorial (0)+factorial (0)+factorial (0)+factorial (0)) =


15.There are three people A, B, C. Liars are of same type and Truth speaking people

are of same type. Find out who is speaking truth and who is speaking false from the

following statements:

a) A says: B is a liar.

b) B says: A and C are of same type.

Ans: lets assume A is speaking truth. It means B is a liar then it means A and C are

not of same type.

16.5 swimmers A, B, C, E, F and many conditions of their positions like there are

Two b/w A & F, B doesn't win etc the question was to find who was b/w like E & D?

Ans: ?

17. in a race u drove 1st lap with 40kmph and in the second lap at what speed u

must drive so that ur average speed must be 80kmph.

Ans: its impossible! if u drove the first lap in 40 kmph, its impossible that the

average speed of both the laps is 80kmph.

for eg. consider one lap distance = 80km.

time req. to cover 1 lap = 80km/40kmph = 2 hrs.

if the avg. speed is 80kmph, then the total time would have taken =

160kms/80kmph = 2 hrs.

same is the case with any other distance u consider. so the avg to be 80kmph is


18. You have to draw 3 concentric circles with a line passing thru their center

without lifting hand.

Ans: Start the line complete one circle move inside circles along the line and then

draw second circle. Like wise rest.

19. A rectangular paper is there. At a corner a rectangular size paper is taken from

it. Now you have to cut the remaining paper into two equal halves.

Ans: try it on the paper. You must fold the part that has complete paper and select

Half of it and then fold the part that cut and selects half of it and then cut along


20. Value of (x-a)(x-b)???..(x-z)

Ans: 0 as there?s X-X term

21. There are 9 coins. 8 are of 1 gm and 1 is of 2 grams. How will you find out the

heavier coin in minimum number of weighing and how many weighing it will need?

Ans: 2 weighing ( Divide the number of coins into 3 parts at each weighing)

Monday, August 30, 2010

Apps And Logical

1. A man decides to buy a nice horse. He pays $60 for it, and he is very content with the strong animal. After a year, the value of the horse has increased to $70 and he decides to sell the horse. But already a few days later he regrets his decision to sell the beautiful horse, and he buys it again. Unfortunately he has to pay $80 to get it back, so he loses $10. After another year of owning the horse, he finally decides to sell the horse for $90. What is the overall profit the man makes?
2. A bus run at 100 km/hr top speed. It can carry a maximum of 6 persons. If speed of bus decreases in fixed proportion with increase in number of person, find speed when three person are traveling in bus.
3. A man wanted to enter an exclusive club but did not know the password that was required. He waited by the door and listened. A club member knocked on the door and the doorman said, "twelve." The member replied, "six" and was let in. A second member came to the door and the doorman said, "six." The member replied, "three" and was let in. The man thought he had heard enough and walked up to the door. The doorman said, "ten" and the man replied, "five". But he was not let in. What should have he said?
4. There are 20 pieces of bread to divide among 20 people. A man eats 3 pieces, woman eats 2 pieces and a child eats half piece of bread. Tell the correct combination of men, women and children so that they are 20 people in total and everyone gets the bread. Note that a man cannot eat less than 3 or more than 3. A woman cannot eat less than 2 or more than 2 and the child cannot eat less than half or more than half piece of the bread. You have to tell there are how may are men, women and children in those 20 people.
5. A cube of side 4cm is painted with 3 colors red, blue and green in such a way that opposite sides are painted in the same color. This cube is now cut into 64 cubes of equal size.
  1. How many have at least two sides painted in different colors.
  2. How many cubes have only one side painted.
  3. How many cubes have no side painted.
  4. How many have exactly one side not painted.
6. How many squares are there on a normal chessboard?
7. Three people picked 65 apples altogether. At the first tree they each picked the same number of apples. At the second tree they each picked 3 times as many as they picked at the first tree. When they finished at the third tree, the group had 5 times as many apples as they had when they started at that tree. At the fourth tree the group picked just 5 apples. How many apples did each person pick at the first tree?
8. 4 criminals are caught and are to be punished. The Judge allows them to be freed if they can solve a puzzle. If they do not, they will be hung. They agreed. The 4 criminals are lined up on some steps (shown in picture). They are all facing in the same direction. A wall seperates the fourth man from the other three.
Logical Test Puzzle
To Summarise
  • Man 1 can see men 2 and 3.
  • Man 2 can see man 3.
  • Man 3 can see none of the others.
  • Man 4 can see none of the others.
The criminals are wearing hats. They are told that there are two white hats and two black hats. The men initially don't know what colour hat they are wearing. They are told to shout out the colour of the hat that they are wearing as soon as they know for certain what colour it is.
  • They are not allowed to turn round or move.
  • They are not allowed to talk to each other.
  • They are not allowed to take their hats off.
Now the question is "Who is the first person to shout out and why?"
9. At a party, everyone shook hands with everybody else. There were 66 handshakes. How many people were at the party?
10. You have to measure exactly 4 liters of water, but you only have a 3-liter bottle and a 5-liter bottle. How do you do it?
1. Consider the trade-story as if it describes two separate trades, where: In the first trade, the man buys something for $60 and sells it again for $70, so he makes a profit of $10. In the second trade, the man buys something for $80 and sells it again for $90, so he makes again a profit of $10.
Conclusion: The man makes an overall profit of $10 + $10 = $20.
You can also look at the problem as follows:
The total expenses are $60 + $80 = $140 and the total earnings are $70 + $90 = $160. The overall profit is therefore $160 - $140 = $20.
2. 100 Km/hr because that is the top speed of the bus.
3. The man had to reply the number of characters in the word the Doorman was asking. He should have replied "Three" instead of "Five".
4. There are 5 women, 1 man and 14 children.
5. Here are the answers.
  1. Cubes that have at least two sides painted in different colours are 24 + 8 = 32.
  2. Cubes that have only one side painted are 24.
  3. Cubes that have no side painted = 8.
  4. Cubes that have exactly one side not painted = 0.
Chessboard Squares6. There are actually 204 squares on a chessboard. Surprised! Here is the explanation. There are 64 (1x1) squares. There are 49 (2x2) squares. There are 36 (3x3) squares. There are 25 (4x4) squares. There are 16 (5x5) squares. There are 9 (6x6) squares. Then there are 4 (7x7) squares and 1 big 8x8 square. So, there are a total of 204 squares on a normal chessboard.
7. One Apple
8. Man 1 will shout first. If Man1 will not shout then Man 2 surely shouts.
Reason: Man 1 can see the other two criminals? hats. If the hats are same color then he told his hat is opposite color of remaining two hats. So he shouts first. If Man 1 does not shout, it means that the hats of Man 2 and Man 3 are of different color. So Man 2 sees the color of Man 3 hat and he tells that the color of his hat is opposite to the color of Man 3 Hat.
9. With two people, there is one handshake. With three people, there are three handshakes. With four people, there are six handshakes. In general, with n+1 people, the number of handshakes is the sum of the first n consecutive numbers: 1+2+3+...+n. Since this sum is n(n+1)/2, we need to solve the equation n(n+1)/2 = 66. This is the quadratic equation n2+n-132 = 0. Solving for n, we obtain 11 as the answer and deduce that there were 12 people at the party.
10. Fill the 3-litre bottle and pour it into the empty 5-litre bottle. Fill the 3-litre bottle again, and pour enough to fill 5-litre bottle. This leaves exactly 1 litre in the 3-litre bottle. Empty the 5-litre bottle; pour the remaining 1 litre from the 3-litre bottle into the 5-litre bottle. Fill the 3-litre bottle and pour it into the 5-litre bottle. The 5-litre bottle now has exactly 4 litres.

Monday, August 23, 2010

Sonata Software Limited

Sonata Software Limited (

Freshers : Employee Referral : BE / B.Tech / MCA : Openings for 2009 Passout


Request your REFERRAL SUPPORT for our fresher requirements.

Please send across the resumes to :

Eligibility Criteria :
• Engineering Graduates from the 2009 batch
• Graduates from the following disciplines:
Computer Science, Electrical & Electronics, Electronics & Communication, Information Science, Information Technology , Electronics & Telecommunication with 65% aggregate
• MCA’s with 70% aggregate
• Minimum 65% in 10th and 12th examination
• No gaps in academic career
• Execute a bond to serve the company for 2 years from the date of joining

Sonata Software Limited

Saturday, August 14, 2010

Happy Independence Day

Happy Independence day wishes guys.
 Proud to an INDIAN..

Wednesday, August 4, 2010

Free unlimited SMS trick for 1 year

Hi friends,

New aircel SMS (1 year free sms) trick was launched.

To activate
sms TP to 56666

you will charged 3 rupees. It will be activated in 10 minutes
you will get confirmation message.

You will get one year free unlimited messaging.

If you are using EC Recharging SIM please don't use it.
If you have Neeya naana (A-A) sim means don't USE it.

Wednesday, July 28, 2010


Applications are invited upto 5.45 p.m on 20-08-2010 for Direct Recruitment to the post of Village Administrative Officer as detailed below:
Name of the Post / Service Code No.
No. of vacancies
Scale of Pay
Village Administrative Officer in Tamil Nadu Ministerial Service
Service Code.050
(Post Code No.2025)
(Rs.5,200 – 20,200 + Grade Pay Rs. 2,000/- P.M) (PB1)
Village Administrative Officer (Shortfall vacancies for SC/ST)
Service Code.050
1077 *
(Post Code No.2025
(* Reservation for Women, Differently Abled persons and Ex-Servicemen shall not apply for Shortfall Vacancies mentioned at Serial No.2)
Only one application is to be sent by the SC/SC(A)/ST candidates who wish to be considered for the regular and the shortfall vacancies.
The District wise Distribution of vacancies are shown in Annexure to this notification.
Date of Notification
Last date for receipt of applications
5.45 P.M.
Date of Examination
Will be announced later

Friday, July 23, 2010

Short Shots

A Jobless man applied for the position of 'office boy' at Software Co.. The HR manager interviewed him then watched him cleaning the floor as a test.

'You are employed' he said. Give me your e-mail address and I'll send you the application to fill in, as well as date when you may start.

The man replied 'But I don't have a computer, neither an email'.

'I'm sorry', said the HR manager. If you don't have an email, that means you do not exist. And who doesn't exist, cannot have the job.'

The man left with no hope at all. He didn't know what to do, with only $10 in his pocket. He then decided to go to the supermarket and buy a 10Kg tomato crate.
He then sold the tomatoes in a door to door round.. In less than two hours,
he succeeded to double his capital. He repeated the operation three times,
and returned home with $60.

The man realized that he can survive by this way, and started to go everyday earlier, and return late. Thus, his money doubled or tripled everyday.

Shortly, he bought a cart, then a truck, and then he had his own fleet of delivery vehicles.

5 years later, the man is one of the biggest food retailers in the US ....
He started to plan his family's future, and decided to have a life insurance.

He called an insurance broker, and chose a protection plan.
When the conversation was concluded the broker asked him his email.
The man replied,'I don't have an email.'
The broker answered curiously, 'You don't have an email, and yet have succeeded to build an empire. Can you imagine what you could have been if you had an e mail?!!' The man thought for a while and replied, 'Yes, I'd be an office boy at SOFTWARE CO !'

Moral of the story

Moral 1
Internet is not the solution to your life.

Moral 2
If you don't have Internet, and work hard, you can be a millionaire.

Moral 3
If you received this message by email,
you are closer to being a office boy/girl, than a millionaire..........

P.S - Do not forward this email back to me,
I am closing my email account & going to sell tomatoes!!!

Monday, July 19, 2010

Enzen Global Solutions

We are Hiring Fresh Ideas

Enzen Global Solutions ( – Bangalore is planning for fresher’s recruitment in July 2010. We invite CVs of fresh graduates who would like to be a part of the growing Enzen family for taking up challenging assignments.

Qualification Criteria:
1. BE / B Tech / MCA / MSc (IT) - Yr. 2009 or 2010 pass out with minimum 65% aggregate
2. Exposure to IT domain and programming languages during the academic course
Please send the CVs to:
Timeline for sending CVs : Jul 12th to July 24th 2010
Subject line of email should contain the following information in the mentioned format:
“Degree – Year of Pass out”, Eg: MCA – 2009
Short listed candidates will be informed through email
Anyone having attended written test at Enzen during the last SIX months, need not apply

Short Shots

There was a good old barber in Bangalore . One day a florist goes to him
for a haircut. After the cut, he goes to pay the barber and the barber
I am sorry, I cannot accept money from you; I am doing a Community
Florist is happy and leaves the shop.

The next morning when the Barber goes to open his shop, there is a
"Thank You" Card and a dozen roses waiting at his door.

A Confectioner goes for a haircut and he also goes to pay the barber he
again refuses to take the money.
The Confectioner is happy and leaves the shop.

The next morning when the Barber goes to open his shop, there is another
"Thank you" Card and a dozen Cakes waiting at his door.

A Software Engineer goes for a haircut and he also goes to pay the
barber again refuses the money saying that it was a community service.

The next morning when the Barber goes to open his shop, guess what he
finds there......


A Dozen Software engineers waiting for a free haircut... with Printouts
of Forwarded mail mentioning about free hair cut with the google map
showing the shop.

Thursday, July 8, 2010

Care Voyant Technologies Private Ltd (

Care Voyant Technologies Private Ltd (
CareVoyant Technologies Private Ltd, formerly Kaveri CareVoyant Private Ltd., is a dedicated Offshore Product Development Centre for CareVoyant / CareVoyant Inc., - a Chicago-based, U.S. incorporated Health Care Software Development company. The company’s products, developed for multiple vertical healthcare provider segments, are marketing under the brand CareVoyant. Since 1987, the company’s Principals have been in HealthCare Software Domain with over 400 clients across the U.S.

CareVoyant Inc. specializes in the design, development, implementation and support of software applications for the US healthcare provider market, spanning the entire healthcare continuum, consisting of Physicians, Home Care and Long Term Care. CareVoyant Inc. was promoted and managed by Mr. K Pasupathy – an alumnus of College of Engineering, Guindy, Anna University

Freshers : BE / B.Tech / MCA / MSc : 2010 / 2009 Passout @ Chennai
CareVoyant, a US -based Healthcare Software Product Company, is recruiting trainees for its product development centre in Chennai.
Fresh Engineering graduates and MCA, MSc who passed out in 2009 and 2010 are eligible to apply for this recruitment process.

Job Designation : Trainee Software Engineer

Job Category : IT / Software

Job Location : Chennai, Tamilnadu

Desired Qualification :
• All Candidates in Engineering and Technology Streams with consistent academic record (Over 70% of marks), without the history of arrears from school onwards.
• Though preference will be given for CSE, IT and ECE students, others with good aptitude for software are encouraged to apply.
• MCA and MSc Candidates may also appear, but they must have secured a minimum of 70% mark from 10th standard onwards.
• Candidates must be serious about pursuing a career in a software application development environment focused on the U.S. healthcare market.
• Candidates who have passed out during the year 2010 and 2009 are only eligible.

Desired Experience : 0 Years

Desired Skills :
• Must have strong liking and talent in software development.
• Excellent Communication skills and team building capabilities are essential.

Job Description :
• We will conduct a written test to assess the candidate’s aptitude in quantitative, verbal, computer literacy and general mental abilities. The duration of the test will be 60 minutes. We will communicate details regarding date and venue in due course.
• Qualifying candidates will take part in a Group Discussion.
• Interview will be followed by Group Discussion
• Candidates interested in this Process may apply through our website.
• Only Eligible / selected candidates will be called for testing by email invitation.
• Make sure you submit a valid email id.

Compensation :
• Selected candidates will be offered a compensation of Rs.1.8 to Rs.2.4 lacs per annum. (Cost to the Company basis).
• The selected candidates will be trained intensively in Technology, Domain and Project management at the job location in Chennai.
• CareVoyant Offers an excellent working environment and learning opportunities.
• We have a state-of-the-art development facility in Chennai, having total area 35,000 sq.ft at Siruseri IT Park near Chennai.
• Talented Candidates will have opportunity to grow rapidly and the rewards will be commensurate with the contribution

Monday, July 5, 2010

The PostgreSQL Database - Installation and Configuration

The PostgreSQL Database - Installation and Configuration:

Red Hat 7.2 example:

* Install (rpm -ivh package) or check for the following PostgreSQL RPMs (rpm -q package):
o postgresql-7.1.3-2
o postgresql-libs-7.1.3-2
o postgresql-server-7.1.3-2
o postgresql-perl-7.1.3-2
Other packages available:
o postgresql-odbc
o postgresql-jdbc
o postgresql-tcl
o postgresql-tk
o postgresql-python
o postgresql-devel

Install: rpm -ivh postgresql-7.1.3-2.i386.rpm postgresql-libs-7.1.3-2.i386.rpm postgresql-server-7.1.3-2.i386.rpm postgresql-perl-7.1.3-2.i386.rpm

* The user "postgres" should have already been configured by the installation of the RPMs. Info:
o User: postgres
o Home directory: /var/lib/pgsql
o Default shell: /bin/bash
A password will be missing. As root issue the command: passwd postgres to assign a password for user postgres.

* Login as user postgres: su - postgres
This will execute the profile: /var/lib/pgsql/.bash_profile


* Initialize PostgreSQL database server: initdb --pgdata=/var/lib/pgsql/data
This creates a bunch of directories, a template directory and sets up the postgres configuration in the user directory /var/lib/pgsql/. Red Hat start command (service)/script (rc script) will perform this task if it has not already been performed. See next step - Starting the database.

* Starting the database server: As root. (from most to least favorite method)

service postgresql start
(If the database has not already been initialized with initdb, this will be performed by the command)
/etc/rc.d/init.d/postgresql start
(If the database has not already been initialized with initdb, this will be performed by the script)
/usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster -l logfile start &
/usr/bin/postmaster -D /var/lib/pgsql/data &

o Configuration file: /var/lib/pgsql/data/postgresql.conf
By default there is no network access. See the directive tcpip_socket. (Required for ODBC,JDBC) Also see the postmaster directive "-i". Logging and tuning parameters are specified here.
o Host Access file: /var/lib/pgsql/data/pg_hba.conf
o Authentication/Identification file: /var/lib/pgsql/data/pg_ident.conf

* Create a database: createdb bedrock
(As Linux user postgres)

* Connect to the database: psql bedrock
Execute command as Linux user postgres
You will now be at the PostgreSQL command line prompt.

[prompt]$ psql - or "psql bedrock"
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

bedrock=# \c bedrock
You are now connected to database bedrock.
bedrock=# create table employee (Name char(20),Dept char(20),jobTitle char(20));
bedrock=# INSERT INTO employee VALUES ('Fred Flinstone','Quarry Worker','Rock Digger');
INSERT 18733 1
bedrock=# INSERT INTO employee VALUES ('Wilma Flinstone','Finance','Analyst');
bedrock=# INSERT into employee values ('Barney Rubble','Sales','Neighbor');
bedrock=# INSERT INTO employee VALUES ('Betty Rubble','IT','Neighbor');
bedrock=# SELECT * from employee;
name | dept | jobtitle
Fred Flinstone | Quarry Worker | Rock Digger
Wilma Flinstone | Finance | Analyst
Barney Rubble | Sales | Neighbor
Betty Rubble | IT | Neighbor
(4 rows)

bedrock=# \q

* Database discovery / Examine a database (as user postgres: su - postgres):
[postgres]$ psql
o \l :List databases
o \c database-name :List databases
o \d :List tables in database
o \d table-name :Describe table
o select * from table-name :List table contents

* More info:
o Create a user:
+ Command line: [prompt]$ createuser dude
+ SQL: CREATE USER dude WITH PASSWORD 'supersecret';
Change with ALTER USER
o Grant priveliges:
+ SQL: GRANT UPDATE ON table-name to dude
+ SQL: GRANT SELECT ON table-name to dude
+ SQL: GRANT INSERT ON table-name to dude
+ SQL: GRANT DELETE ON table-name to dude
+ SQL: GRANT RULE ON table-name to dude
+ SQL - Do it all: GRANT ALL PRIVILEGES ON table-name to public
o Delete a user:
+ Command line: [prompt]$ dropuser SuperDude
o Delete a database:
+ Command line:
# [prompt]$ destroydb bedrock
# [prompt]$ dropdb bedrock
o Create a database:
+ Command line: [prompt]$ createdb bedrock -U user-name -W
You will be prompted for a password. (or execute as Linux user postgres without -U and -W options)
o Backup a database:
+ [prompt]$ pg_dumpall > outfile
+ [prompt]$ pg_dumpall -Fc dbname > outfile
o Version Upgrades:
+ Dump: [prompt]$ postgresql-dump -t /var/lib/pgsql/backup/db.bak -p /var/lib/pgsql/backup/old -d
+ Restore: [prompt]$ psql -e template1 < /var/lib/pgsql/backup/db.bak
The table template1 is the default administrative database.

If one would like to generate a GUI interface to the database, I would recommend a web form to a Java servlet back-end or use a JAVA GUI program and JDBC. See the YoLinux tutorial on accessing PostgreSQL with JDBC in a Tomcat servlet example.


* PostgreSQL documentation:
o /usr/share/doc/postgresql-7.1.3/html/index.html (local html)
o /usr/share/doc/postgresql-7.1.3/ (local directory)
* Resources: /usr/share/pgsql/

PostgreSQL-Stored Procedures

Stored Procedures

Stored Procedures are subroutines that are stored inside the database. They allow you to select and manipulate data, and, with the use of control structures and loops, perform complex computations and return the calculated result to the client. This saves considerable amounts of client/server communication.

PostgreSQL allows Stored Procedures to be written in several different Procedural Languages, including Perl, Python, TCL, and pgSQL - the PostgreSQL internal procedure language. User-defined Procedural Languages can also be used, and several of these languages are easily downloadable, e.g. PL/Java.

In this article, we will be using PL/pgSQL. PL/pgSQL is very similar to normal SQL, but adds many more features to it, like control structures and user-defined data types and functions.
Example 1: The Basic Stored Procedure

Let's get started with a very basic stored procedure that returns "Hello World!" - not very useful, I know, but it will get us started with the basic syntax of PL/pgSQL. Here's the code:

create or replace function hello() RETURNS text AS $$
hello text;
hello := 'Hello World!';
return hello;
$$ LANGUAGE plpgsql;

Here's what it does:

create or replace function hello() RETURNS text AS $$

Creates the function called hello which receives no parameters and returns text. You must always define what the function returns; use VOID if you don't need to return anything.


Opens the variable declarations block.

hello text;

Declares a variable called "hello" of type "text". To define multiple variables, use ";" as the separator. You can use any of standard types used in tables, like integer and float, and even user-defined types or domains.


Starts the actual function code.

hello := 'Hello World!';

Pupulates the variable "hello" with 'Hello World!'. Note that you have to use single quotes for string/text values.

return hello;

Returns our value.


Ends the function.

$$ LANGUAGE plpgsql;

Defines what language we used - 'plpgsql' in this case. To call that function, you use the following SQL code.

select * from hello();

The output will be a text field called "hello", with the value of "Hello World!".
Example 2: Populating a Table with Test Data

This is another use of a Stored Procedure ('SP' from now on) - generating test data for your tables. Let's use last month's article as an example - we used a SP to generate 500K rows of data for one of our tables. Here's the code:

create or replace function test_data_computer()
RETURNS integer AS $$
count integer;
sql text;
count = 1;
sql = 'insert into computer(computer_id, computer_ram, cpu_id, video_id) values';
sql = sql || '('|| count ||', ' || random()*1024 || ', ' || (random()*49999)+1 || ', ' || (random()*49999)+1 || ')';
count = count + 1;
EXIT WHEN count > 500000;
return count;
$$ LANGUAGE plpgsql;

It starts much like our previous example, but this time we declare 2 variables instead of one. Things become different at line 8, where we introduce the LOOP statement. The loop is a basic repeating structure: it repeats the code inside indefinitely, until it finds a EXIT or EXIT WHEN clause.

Lines 9 and 10 are used to generate the SQL code to include a simple record in our tables. The double pipes ("||") is the concatenation operator. Random() generates a random float number between 0 and 1 (so "random()*49999)+1" will generate a random number between 1 and 50000).

Line 11 executes the SQL code stored inside the sql variable, adding the registry to the table.

Lines 12 and 13 are used to control the flow of the LOOP, and if omitted will make the loop an infinite one. "EXIT WHEN count > 500000;" makes the loop stop when the condition is met (when "count" goes over 500000 in this case.)

Line 14 closes the LOOP block, making the function go back to line 8, executing everything that is inside the loop again (and again, and again).

Line 15 returns the number of added registries (plus one in this case).
Example 3: Calculations and Date/Time Handling

Let's make up a scenario for this one. Imagine that you are building a system for a doctor, and one of the bits of data he wants is exactly how much time he spends with his patients (NOT just idling in the office.) Even more, he wants to be able to select the data for a given date or date interval, and he wants the option of selecting the records of either a single patient or all of them. Complex scenario, right? Well, we can solve it all with a single SP. These are the tables our database will have:

create table patient (
patient_id serial primary key,
patient_name text );

create table visits (
v_id serial primary key,
patient_id integer references patient,
v_date date,
v_time_start time,
v_time_end time );

One for the patients, another one to store the visits, with the date, start, and end time. Let's now populate the tables with some data:

insert into patient (patient_name) values ('Deividson');
insert into patient (patient_name) values ('John');
insert into patient (patient_name) values ('Benjamin');
insert into visits (patient_id, v_date, v_time_start, v_time_end) values (1, '10/04/2008', '08:00', '09:00');
insert into visits (patient_id, v_date, v_time_start, v_time_end) values (1, '14/04/2008', '13:00', '13:45');
insert into visits (patient_id, v_date, v_time_start, v_time_end) values (1, '18/04/2008', '10:00', '10:15');
insert into visits (patient_id, v_date, v_time_start, v_time_end) values (2, '11/04/2008', '14:00', '15:00');
insert into visits (patient_id, v_date, v_time_start, v_time_end) values (2, '12/04/2008', '14:00', '15:45');
insert into visits (patient_id, v_date, v_time_start, v_time_end) values (2, '17/04/2008', '14:00', '15:15');
insert into visits (patient_id, v_date, v_time_start, v_time_end) values (3, '15/04/2008', '08:00', '12:00');

Three patients, seven records - enough to test our SP. Here is the code:

CREATE OR REPLACE FUNCTION total( date1 date, date2 date, patient integer )
RETURNS interval AS $$
total interval;
rec record;
sql text;
total = '00:00:00'::time;
sql = 'select * from visits';

if date1 is not null OR patient is not null then
sql = sql || ' where ';
end if;

if patient is not null then
sql = sql || '(patient_id = ' || patient || ')';
end if;

if date2 is not null AND date1 is not null then
if patient is not null then
sql = sql || ' AND ';
end if;
sql = sql || '(v_date between ''' || date1 || ''' and ''' || date2 || ''')';
if date1 is not null then
if patient is not null then
sql = sql || ' AND ';
end if;
sql = sql || '(v_date = ''' || date1 || ''')';
end if;
end if;

for rec in EXECUTE sql loop
total = total + (rec.v_time_end - rec.v_time_start);
end loop;

return total;
$$ LANGUAGE plpgsql;

Wow! Big one this time, eh? Let's take a look at it. The start of the code is pretty similar to the other examples, but we have 3 variables this time. 'total' will store the total time to return to the client, and 'rec' (of type record) is a variable that will hold the result of the query we will run.

On line 8, we start the variable total with the value of 00:00:00 - the "::" is a typecast - ":: time" means the string we're passing ("00:00:00") needs to be turned into a time.

From line 9 all the way down to line 31, all we are doing is creating the SQL statement that will select the data we want. Here, we use another type of structure - the IF. IFs are basic flow-control structures, and its syntax is (as in most programming languages):

IF (condition) THEN (commands) [ELSE (commands)] END IF;

The condition can be any logical comparison ( <, > , =, IS NULL, or IS NOT NULL), and you can combine multiple conditions using the logical operators (AND, OR, etc). If the condition is true, then the execution will continue with the commands inside the THEN clause, or if it's false, execution will move to the commands in the ELSE (if it exists), or to after the END IF.

It's in those IFs that we create the conditions (single date, date interval, single patient, etc.)

On line 33, we execute the SQL code we generated, looping over each of the records of the result. We then add the duration of each visit in the 'total' variable, and return the result when there are no more records available.

We can call this SP in one of several different ways, each way selecting a different data set and giving us a different result:

# All the records, from all patients
select * from total(NULL, NULL, NULL);

# All the records, from patient #3 only
select * from total(NULL, NULL, 3);

# Records from '14/04/2008', all patients
select * from total('14/04/2008', NULL, NULL);

# Records from '14/04/2008', patient #1 only
select * from total('14/04/2008', NULL, 1);

# Records from '14/04/2008' through '17/04/2008', all patients
select * from total('14/04/2008', '17/04/2008', NULL);

# Records from '14/04/2008' through '17/04/2008', patient #2 only.
select * from total('14/04/2008', '17/04/2008', 2);


Stored Procedures are powerful and flexible, and can be a very good way to help you pre-select and pre-process data, as well as allowing you to manipulate data and run code directly on the server.

PostgreSQL offers a comprehensive manual on their site, including a chapter about PL/pgSQL. You can find it here:

That's it for Stored Procedures - see you next month, when we'll discuss Triggers!

Wednesday, June 30, 2010

Postgresql Interview Questions

1) Explain what is PostgreSQL?
This is regarded as one of the most successful open source database in the world. This is also used to create advanced applications. This relies on Object relational database management system. Familiarity with UNIX and Linux can be an added advantage while using PostgreSQL.

2) State some of the advanced features of PostgreSQL?
These are the following features which are present in PostgreSQL they are
1) Object relational database
2) Extensibility and support for SQL
3) Database validation and flexible API
4) Procedural languages and MVCC
5) Client server and WAL.

3) Explain about Write Ahead logging?
This feature increases the reliability of the database by logging changes before any changes or updations to the data base. This provides log of database incase of a database crash. This helps to start the work from the point it was discontinued.

4) Explain about Multi version concurrency control?
Multi version concurrency control or MVCC is used to avoid unnecessary locking of the database. This removes the time lag for the user to log into his database. This feature or time lag occurs when some one else is on the content. All the transactions are kept as a record.

5) What are the languages which PostgreSQL supports?
Some of the languages which PostgreSQL supports are as follows: -
It supports a language of its own known as PL/pgSQL and it supports internal procedural languages. Pl/pgSQL can be compared to oracle, PL/SQL, etc. Languages such as Perl, Python, TCL can be used as embedded languages.

6) Explain about the command enable debug?
This command is used for enabling compilation of all libraries and applications. This process generally slows down the system and it also increases the binary file size. Debugging symbols are present which can assist developers in noticing bugs and problems associated with their script.

7) Explain about functions in PostgreSQL?
Functions are important because they help the code to be executed on the server. Some of the languages which can program functions for efficient use are PL/pgSQL which is the native language of PostgreSQL. Scripting languages are supported by many languages such as PHP, Perl, Python, etc. PL/R a statistical language can also be used.

8) Explain about indices of PostgreSQL?
There are built in functions such as B-tree, hash table, and GIST indices can be used or users can define their own indices. PostgreSQL can scan the index backwards. Expression index could be created with the result of an expression. Partial index created with addition of WHERE clause.

9) Explain about Triggers?
By SQL query you can trigger an event. Triggers can be activated with the help of INSERT and UPDATE queries. These can be attached to tables. Triggers more than one can be triggered alphabetically. These triggers have the capability to invoke functions from other languages.

10) What are the different data types supported by PostgreSQL?
There are different data types which are supported they are: -
1) Arbitrary precision numeric’s
2) Geometric primitives
3) Arrays
4) XML etc
Users can create their own indexes and make them indexed.

11) Explain about database administration tools?
There are various data administration tools they are
1) Psql
2) Pgadmin
3) Phppgadmin
Most of these tools are front end administration tools and web based interfaces. Out of these phppgadmin is the most popular one.

12) Explain about pgadmin?
Pgadmin forms a graphical front end administration tool. This feature is available under free software released under Artistic License. Pgadmin iii is the new database administration tool released under artistic license.

13) How do you create a data base with postgreSQL?
Creating a database is the primary step in creating a database. A command
$createdb newdatabasedb
This creates a new database and a message displays CREATE DATABASE which indicates that the creation of the database was successful.

14) What are the various enhancements to the straight relational data model by PostgreSQL?
There are various enhancements provided to the straight relational data model by postgre SQl they are support for arrays which includes multiple values, inheritance, functions and extensibility. Jargon differs because of its object oriented nature where tables are called as classes.

15) Explain about tokens?
Tokens are also known to contain several special character symbols. It can be considered as keyword, constant, identifier and quoted identifier. Keywords include pre defined SQL meanings and SQL commands. Variable names such as tables, columns, etc are represented by identifiers.

16) Explain about string constants?
String constant contains a sequence of characters bound by single quotes. This feature is used during insertion of a character or passing character to database objects. PostgreSQL allows the usage of single quotes but embedded by a C style backslash. This feature is important in parsing data.

17) Explain about concurreny with the help of MVCC?
Multi version concurrency control is used to manage concurrency. This feature is very useful because changes made in the database will not be visible to other users until the transaction is completed. This removes the need for read locks. ACID principles are given a further boost by this feature and can be implemented in general.