Early morning around 7 AM I reached platform number 1 of Bangalore City junction on 2nd July 2010. With lots of hope and with unlimited expectations; I entered this silicon city. From last 4 months I was in Hyderabad doing courses on Oracle PL/SQL and Java. Now it was the time to check my knowledge on industry standards. I took an auto rickshaw and reached one of my old friends, Manish Gupta’s flat. I was not much aware of this city. One of my friends was here from last six months. He guided me and told me to join a consultant. The name of the consultant is LuminUs. It is located in Malleswaram near 5th cross. They charged me INR. 560 as their fee and assured me that they will give me chances for many interviews on java and PL/SQL. According to their rule I will have to pay half of my first month salary if I get a job through them.
They gave me first call on Monday 05-July. The name of the company was Xora Technologies. First LuminUs people use to take a written test and those who are selected, are sent to the company for further processes. I was selected by them. They gave me the venue and told me to go there on 8th July. On Monday it self I got a call from another consultant named S V Consultancy. The caller was a lady and introduced herself as Vinutha. She got my resume from some job portal site (monster, Times job or Naukri.com). She confirmed my profile and told me that my profile is looking suitable for one of their client named Tom Bell Softech Ltd. They are looking for PL/SQL developer. She texted me the address of the company. She told me to reach there on Tuesday at 10 AM. That day was the best day because I wanted to make my career in PL/SQL only, and this opening was for PL/SQL and fresher also. I prepared well and reached the venue on time.
There I met Bells Softech HR named Pratibha. She asked about me and my family, she also asked 2 SQL query. She was not aware about the answers of those queries. She asked me “Write a query to get the salary of employee”. I smiled on her question and asked for the structure of the table. She did not understand. I asked her to give the name of the table and column, she unknowingly said “Salary table and salary column”. I wrote “SELECT Salary FROM Salary”, and passed the sheet to Prathibha. I guessed that she was not satisfied with my 4 words answer. I asked you want a SQL query or PL/SQL block. She again did a childish mistake and said “PL/SQL code”. I started my code with DECLARE and ended with END. She was happy now; it was almost all 7-8 lines of code. Then she asked me “If you will be asked to rate yourself in PL/SQL out of 10, what will be your rating about yourself?” I answered quietly “Mam its 9/10 and I can guarantee that no fresher will stand in front of me in PL/SQL". Her mouth was wide open for few seconds on my words and confidence. She said “Oh is it? Good!!” She took me to the GM. The GM was a wonderful person, Mr. Sadanand. He started with the common question as “Mr. Ajit, Tell me something about youself”. I vomited all what I know about myself. Then he asked the same question what Prathibha asked me, “Write a query to get the salary of employees”. I wrote the same 4 word query. Now he extended, “Get the second highest salary from employee table”. It was good question. But this is a common question asked in every interview. I had already practiced this question in 5 different ways. I gave one of the best answers among them. He was happy now and further he did not ask any question. He told me that you are good and you have been selected from my side, but you have to work for one of my client and you have to go there for the further rounds. The name of their client was MetricStream Inc. He said that you will get the confirmation by today evening or by tomorrow along with the venue. I was very happy and returned home. This was my first interview for job and I passed this round. I waited for the confirmation mail that evening.
Next day I got a call from LuminUs for some Core java opening in IPASS software. I went to LuminUs and took the test. I returned back to home. Still there was no confirmation mail or message from Tom Bells for my PL/SQL interview. I called them. They told me to wait for one more day. The interview was on Friday 9th July.
Now it was 8th july. I had to go to Xora. I went to Xora. There was 4 rounds. 1st was aptitude round. We were given 30 question and 30 minutes. I did my best. They evaluated and according to their criteria they called few students name. My name was not there. I thought that I was not selected. But I was sure that I circled 25+ answers right. The called people went to them. They said, “all the best for future and Tata Bye Bye.” I understood that they were not selected and I qualified the first round. We were 12 now out of 25. The second round was technical and programing round. We were given a question paper and few sheets. The time limit was 40 minutes. 8 programs were there. No objective question. 1 was from database, 2 from core java, 5 from J2EE. As I saw the question paper I was confirmed about me. I did the database SQL question correctly which was encapsulating one join, one inline view, 2 sub-queries and few column aliases in it. Then I reached core java question. Actually they had not written in which language I had to write the program. I knew that this was a test for java developer, but I solved those questions in C. I felt easy to write them in C rather than in Core java. And rest J2EE question was not known to me. They collected the answer sheet on time. And told us to wait because it lunch break time. They told us to come back in 1 hour. I went and have my lunch. When we returned they told us that some clients have come so the panel is busy, we will evaluate it tomorrow and inform the shortlisted candidates on phone. I have not got any call even today. I knew this; because I do not know J2EE.
I was checking my mail for MetricStream’s interview confirmation. But there was no mail in my mail box. I was little bit disappointed and went outside to get some fresh air. I went to a nearby park. As I entered the park I started checking my mail once again at the same time I got a call from 080 numbers on my other phone. I wished that it was a call for that PL/SQL interview. At the same time my mail opened and there was a new mail. My eyes were twinkling to see the confirmation and ears were eager to hear the confirmation news. I picked the phone and opened the mail. The lady was Vinutha and the mail was from Prathibha. She asked me whether I got the mail or not. I replied positively and assured that I will reach the venue at exact time. The venue was 1 hours away from that place. And I had to reach there in the morning at 8:30 AM. As I saw the address, I realized that I have heard the name somewhere. Then I remembered that Sachin a friend of my friend live in that area only. I called him and asked about the place. He told that it’s at walking distance from his flat. I said that, “I am coming right now; I have an interview tomorrow early morning”. He said “Ok! Come then”. I packed all my basic goods and took a bus. I reached there at around 9 PM. I revised the whole PL/SQL and basic of java also. Because Vinutha told me that there will be java also. I was on time, there were 18 people waiting for the same from Tom Bell Softtech. We were told that there will be a written objective type test. Those who will qualify will be called for the next round. There were 12 general science and general Knowledge question, 12 from oracle PL/SQL, 10 from java and 10 from Aptitude. The qualifying marks were 5-7-5-5 respectively. No negative marking was there. The HR person was Maya. She distributed the question paper and an answer sheet and 30 minutes were given. My target was to first get the cut-off marks. I struggled most in first section because I am weak in general Knowledge. But I did somehow and time was up. I was happy because I thought I did well in rest 3 sections. I was little bit confused about the first section. As we were told by Tom Bells all the rounds was going to be completed on the same day. And joining date was Monday 12th-July. But Maya told us “the panel is busy with some clients so we will inform the shortlisted candidate of phone today itself and next round will be scheduled on Monday”. I came back little bit sad, because I wanted to be part of company as soon as possible.
I was in the way to home and I got message from LuminUs that I have been sortlisted for IPASS. So I have to report LuminUs to collect the hall ticket. Actually every time LuminUs people use to take a signature on a bond paper that If I will be shortlisted I will give them the half of my first month salary. I took a bus and went to LuminUs. It was almost 2 hours journey due to traffic. I went there signed on the bond and they put a stamp of LuminUs on the top of my resume which was my hall ticket for further rounds in IPASS which was going to be scheduled on Monday 12th july . I thought that it will be better if I will stay with Sachin. Because it was nearer to MetricStram. I took all my goods from Manish’s house and returned back to Maruthinagar (Sachin’s flat). But the tension was that, it was going to be 9 PM and I did not get any call from MetricStream. I was very tired and little bit tensed and sad. I took my dinner and went to bed early.
In the morning I called Vinutha. I asked about my result. I told her that Maya told us that we will get our result yesterday itself and I did not get any call. I told her to confirm whether I have been shortlisted or not. She clarified that the result has not been announced yet. You will get your result on Monday and on a short notice you have to go to attend the interview on the same day. I was in dilemma; I was having two Interviews on the same day. IPASS interview was at 3 PM on Monday. And I was sure that they will call me around 10 and tell me to attend the interview around 2 pm. I described the situation to my LuminUs HR. I told her to reschedule my interview. She told me to inform the situation on Monday, she will try to reschedule the interview at IPASS. Sunday was very confusing day for me. Every alternate day or even regularly LuminUs was calling me which was a 2 hours bus journey from Sachin’s room. And I was still hoping that I will be selected in MetricStream. I was confused and I went to Malleswaram for a room of my own. I wanted to be settled. I thought that I will take a room and then I will search for job. I went with one of my friends named Ladan. He is having Passion Plus. So it was easy to go on bike. It was less time consuming. I saw a room. I told the landlord that I will confirm him on Monday about the room. I wanted to wait one more day for MetricSream.
It was Monday. Early morning I got a message that my Interview for IPASS has been rescheduled on Tuesday at the same time. I was planning to go to one more consultant for registration. I was ready and about to leave. At around 10:30 I got a call from 080 series number. I remembered God and picked the phone. Surprisingly it was Prathibha. I took a long breath of relief. She told me that I have been shortlisted for the next round at MetricStream. She gave me two options 2:30 or 3 PM that day itself for interview. I said 3. She confirmed again and I said “Done”. The phone was disconnected now. I canceled all my programs and took the book and started reading PL/SQL again. After all my preparation I reached MetricStream at 2:50 PM. Two more guys were there. A guy whose interview time was 2:30 PM was still waiting for the interviewer. We all started discussing the topics. At 3:30 a young unmarried lady came and asked, “Who is Jainendra?” That was 2:30 guy. She took him and went. Now we two were left. We were discussing the topic and waiting for our turn. The minute hand of the clock moved 180 degree but there was no news of that 2:30 gentleman. When it was about 270 degree, the guard sent us on the third floor. We went there and still waiting. The minute hand completed 360, but no news. 10 more minutes passed and the chamber opened. The guy came out. I asked what was going on for so many hours. He said that she started from sorting searching algorithm and discussed almost all data structure, she also discussed on the project from half an hour. She was giving some situations for which she was asking to write code sometimes in java, sometimes in PL/SQL. I finalized that after him it’s my turn to be ******. I waited for another 15 minutes but no one called my name for interview. After few more minutes Maya came. She told “it’s late today, so those who have not been interviewed today will be given slots tomorrow and I will call and give you slots”. She said sorry and bye bye. I was happy that I was not interviewed by that lady. I was just praying from God that please give me some other interviewer. In the evening around 7 PM I got a call from Maya. She told me that you time slot is 9:30 and interviewer name is (I kept my hand on my hearts because if she was going to take the name of any lady it may lead to a heart attack) Mr. Abdul Raw. I said ok! Done! And bye. I revised the whole PL/SQL once again at night.
Next day in the morning I woke up at 5 AM and revised my project and JAVA also. I left my room at 9 AM. Took my breakfast and reached MetricStream. Abdul Raw was not there. Maya came after half an hour. She told me that Abdul left the company at 3 AM last night so he will be little bit late, sorry for in convenience. She asked me for coffee or tea. I denied. I opened my PL/SQL book and started reading once again. The minute hand of the watch made a couple of revolution but there was no trace of Abdul Raw. Now it was 1 PM, the guard sent me to second floor. I waited for next 10-15 minutes. A young guy came and introduced himself as Abdul Raw and asked who is Ajit. I stood up, shook hand. He showed me the way to come along with him. Now I was thinking that the next few minutes are going to be very important for me. All the cabins were engaged. He managed one and started with the as usual question “Mr. Ajit tell me something about yourself”. Actually he was having two resumes in his hand, he was talking to me and watching the resume of the other guy. In vomiting about myself I said I am 2010 pass out. He said “Here its 2009 in your resume”. I pointed my resume and said “Sir, this is my resume”. Then he said sorry and started reading my resume. When I completed my boasting about myself, he was on the second page of my resume which is my projects detail page. And he fired his first question from project.
They gave me first call on Monday 05-July. The name of the company was Xora Technologies. First LuminUs people use to take a written test and those who are selected, are sent to the company for further processes. I was selected by them. They gave me the venue and told me to go there on 8th July. On Monday it self I got a call from another consultant named S V Consultancy. The caller was a lady and introduced herself as Vinutha. She got my resume from some job portal site (monster, Times job or Naukri.com). She confirmed my profile and told me that my profile is looking suitable for one of their client named Tom Bell Softech Ltd. They are looking for PL/SQL developer. She texted me the address of the company. She told me to reach there on Tuesday at 10 AM. That day was the best day because I wanted to make my career in PL/SQL only, and this opening was for PL/SQL and fresher also. I prepared well and reached the venue on time.
There I met Bells Softech HR named Pratibha. She asked about me and my family, she also asked 2 SQL query. She was not aware about the answers of those queries. She asked me “Write a query to get the salary of employee”. I smiled on her question and asked for the structure of the table. She did not understand. I asked her to give the name of the table and column, she unknowingly said “Salary table and salary column”. I wrote “SELECT Salary FROM Salary”, and passed the sheet to Prathibha. I guessed that she was not satisfied with my 4 words answer. I asked you want a SQL query or PL/SQL block. She again did a childish mistake and said “PL/SQL code”. I started my code with DECLARE and ended with END. She was happy now; it was almost all 7-8 lines of code. Then she asked me “If you will be asked to rate yourself in PL/SQL out of 10, what will be your rating about yourself?” I answered quietly “Mam its 9/10 and I can guarantee that no fresher will stand in front of me in PL/SQL". Her mouth was wide open for few seconds on my words and confidence. She said “Oh is it? Good!!” She took me to the GM. The GM was a wonderful person, Mr. Sadanand. He started with the common question as “Mr. Ajit, Tell me something about youself”. I vomited all what I know about myself. Then he asked the same question what Prathibha asked me, “Write a query to get the salary of employees”. I wrote the same 4 word query. Now he extended, “Get the second highest salary from employee table”. It was good question. But this is a common question asked in every interview. I had already practiced this question in 5 different ways. I gave one of the best answers among them. He was happy now and further he did not ask any question. He told me that you are good and you have been selected from my side, but you have to work for one of my client and you have to go there for the further rounds. The name of their client was MetricStream Inc. He said that you will get the confirmation by today evening or by tomorrow along with the venue. I was very happy and returned home. This was my first interview for job and I passed this round. I waited for the confirmation mail that evening.
Next day I got a call from LuminUs for some Core java opening in IPASS software. I went to LuminUs and took the test. I returned back to home. Still there was no confirmation mail or message from Tom Bells for my PL/SQL interview. I called them. They told me to wait for one more day. The interview was on Friday 9th July.
Now it was 8th july. I had to go to Xora. I went to Xora. There was 4 rounds. 1st was aptitude round. We were given 30 question and 30 minutes. I did my best. They evaluated and according to their criteria they called few students name. My name was not there. I thought that I was not selected. But I was sure that I circled 25+ answers right. The called people went to them. They said, “all the best for future and Tata Bye Bye.” I understood that they were not selected and I qualified the first round. We were 12 now out of 25. The second round was technical and programing round. We were given a question paper and few sheets. The time limit was 40 minutes. 8 programs were there. No objective question. 1 was from database, 2 from core java, 5 from J2EE. As I saw the question paper I was confirmed about me. I did the database SQL question correctly which was encapsulating one join, one inline view, 2 sub-queries and few column aliases in it. Then I reached core java question. Actually they had not written in which language I had to write the program. I knew that this was a test for java developer, but I solved those questions in C. I felt easy to write them in C rather than in Core java. And rest J2EE question was not known to me. They collected the answer sheet on time. And told us to wait because it lunch break time. They told us to come back in 1 hour. I went and have my lunch. When we returned they told us that some clients have come so the panel is busy, we will evaluate it tomorrow and inform the shortlisted candidates on phone. I have not got any call even today. I knew this; because I do not know J2EE.
I was checking my mail for MetricStream’s interview confirmation. But there was no mail in my mail box. I was little bit disappointed and went outside to get some fresh air. I went to a nearby park. As I entered the park I started checking my mail once again at the same time I got a call from 080 numbers on my other phone. I wished that it was a call for that PL/SQL interview. At the same time my mail opened and there was a new mail. My eyes were twinkling to see the confirmation and ears were eager to hear the confirmation news. I picked the phone and opened the mail. The lady was Vinutha and the mail was from Prathibha. She asked me whether I got the mail or not. I replied positively and assured that I will reach the venue at exact time. The venue was 1 hours away from that place. And I had to reach there in the morning at 8:30 AM. As I saw the address, I realized that I have heard the name somewhere. Then I remembered that Sachin a friend of my friend live in that area only. I called him and asked about the place. He told that it’s at walking distance from his flat. I said that, “I am coming right now; I have an interview tomorrow early morning”. He said “Ok! Come then”. I packed all my basic goods and took a bus. I reached there at around 9 PM. I revised the whole PL/SQL and basic of java also. Because Vinutha told me that there will be java also. I was on time, there were 18 people waiting for the same from Tom Bell Softtech. We were told that there will be a written objective type test. Those who will qualify will be called for the next round. There were 12 general science and general Knowledge question, 12 from oracle PL/SQL, 10 from java and 10 from Aptitude. The qualifying marks were 5-7-5-5 respectively. No negative marking was there. The HR person was Maya. She distributed the question paper and an answer sheet and 30 minutes were given. My target was to first get the cut-off marks. I struggled most in first section because I am weak in general Knowledge. But I did somehow and time was up. I was happy because I thought I did well in rest 3 sections. I was little bit confused about the first section. As we were told by Tom Bells all the rounds was going to be completed on the same day. And joining date was Monday 12th-July. But Maya told us “the panel is busy with some clients so we will inform the shortlisted candidate of phone today itself and next round will be scheduled on Monday”. I came back little bit sad, because I wanted to be part of company as soon as possible.
I was in the way to home and I got message from LuminUs that I have been sortlisted for IPASS. So I have to report LuminUs to collect the hall ticket. Actually every time LuminUs people use to take a signature on a bond paper that If I will be shortlisted I will give them the half of my first month salary. I took a bus and went to LuminUs. It was almost 2 hours journey due to traffic. I went there signed on the bond and they put a stamp of LuminUs on the top of my resume which was my hall ticket for further rounds in IPASS which was going to be scheduled on Monday 12th july . I thought that it will be better if I will stay with Sachin. Because it was nearer to MetricStram. I took all my goods from Manish’s house and returned back to Maruthinagar (Sachin’s flat). But the tension was that, it was going to be 9 PM and I did not get any call from MetricStream. I was very tired and little bit tensed and sad. I took my dinner and went to bed early.
In the morning I called Vinutha. I asked about my result. I told her that Maya told us that we will get our result yesterday itself and I did not get any call. I told her to confirm whether I have been shortlisted or not. She clarified that the result has not been announced yet. You will get your result on Monday and on a short notice you have to go to attend the interview on the same day. I was in dilemma; I was having two Interviews on the same day. IPASS interview was at 3 PM on Monday. And I was sure that they will call me around 10 and tell me to attend the interview around 2 pm. I described the situation to my LuminUs HR. I told her to reschedule my interview. She told me to inform the situation on Monday, she will try to reschedule the interview at IPASS. Sunday was very confusing day for me. Every alternate day or even regularly LuminUs was calling me which was a 2 hours bus journey from Sachin’s room. And I was still hoping that I will be selected in MetricStream. I was confused and I went to Malleswaram for a room of my own. I wanted to be settled. I thought that I will take a room and then I will search for job. I went with one of my friends named Ladan. He is having Passion Plus. So it was easy to go on bike. It was less time consuming. I saw a room. I told the landlord that I will confirm him on Monday about the room. I wanted to wait one more day for MetricSream.
It was Monday. Early morning I got a message that my Interview for IPASS has been rescheduled on Tuesday at the same time. I was planning to go to one more consultant for registration. I was ready and about to leave. At around 10:30 I got a call from 080 series number. I remembered God and picked the phone. Surprisingly it was Prathibha. I took a long breath of relief. She told me that I have been shortlisted for the next round at MetricStream. She gave me two options 2:30 or 3 PM that day itself for interview. I said 3. She confirmed again and I said “Done”. The phone was disconnected now. I canceled all my programs and took the book and started reading PL/SQL again. After all my preparation I reached MetricStream at 2:50 PM. Two more guys were there. A guy whose interview time was 2:30 PM was still waiting for the interviewer. We all started discussing the topics. At 3:30 a young unmarried lady came and asked, “Who is Jainendra?” That was 2:30 guy. She took him and went. Now we two were left. We were discussing the topic and waiting for our turn. The minute hand of the clock moved 180 degree but there was no news of that 2:30 gentleman. When it was about 270 degree, the guard sent us on the third floor. We went there and still waiting. The minute hand completed 360, but no news. 10 more minutes passed and the chamber opened. The guy came out. I asked what was going on for so many hours. He said that she started from sorting searching algorithm and discussed almost all data structure, she also discussed on the project from half an hour. She was giving some situations for which she was asking to write code sometimes in java, sometimes in PL/SQL. I finalized that after him it’s my turn to be ******. I waited for another 15 minutes but no one called my name for interview. After few more minutes Maya came. She told “it’s late today, so those who have not been interviewed today will be given slots tomorrow and I will call and give you slots”. She said sorry and bye bye. I was happy that I was not interviewed by that lady. I was just praying from God that please give me some other interviewer. In the evening around 7 PM I got a call from Maya. She told me that you time slot is 9:30 and interviewer name is (I kept my hand on my hearts because if she was going to take the name of any lady it may lead to a heart attack) Mr. Abdul Raw. I said ok! Done! And bye. I revised the whole PL/SQL once again at night.
Next day in the morning I woke up at 5 AM and revised my project and JAVA also. I left my room at 9 AM. Took my breakfast and reached MetricStream. Abdul Raw was not there. Maya came after half an hour. She told me that Abdul left the company at 3 AM last night so he will be little bit late, sorry for in convenience. She asked me for coffee or tea. I denied. I opened my PL/SQL book and started reading once again. The minute hand of the watch made a couple of revolution but there was no trace of Abdul Raw. Now it was 1 PM, the guard sent me to second floor. I waited for next 10-15 minutes. A young guy came and introduced himself as Abdul Raw and asked who is Ajit. I stood up, shook hand. He showed me the way to come along with him. Now I was thinking that the next few minutes are going to be very important for me. All the cabins were engaged. He managed one and started with the as usual question “Mr. Ajit tell me something about yourself”. Actually he was having two resumes in his hand, he was talking to me and watching the resume of the other guy. In vomiting about myself I said I am 2010 pass out. He said “Here its 2009 in your resume”. I pointed my resume and said “Sir, this is my resume”. Then he said sorry and started reading my resume. When I completed my boasting about myself, he was on the second page of my resume which is my projects detail page. And he fired his first question from project.
Qu 1. Tell few tables from your project.
I had gone through the table name in the morning so I gave him almost all the name of table from my project. I know that if he will fire more questions from project then I am not having project proof jacket with me. Fortunately he went to the last page and instructed me to sign and write the current date. Then he asked
Qu 2. What are Codd’s rules?
Fortunately few days ago I copied all the Codd’s rule from Wikipedia.org and by hearted it. I started with first Codd’s rule and I don’t know how many I gave, I used ‘next’ keyword in place of 'numberings’. I started with one two three then converted it into next next. At last I gave the 0th Codd rule also, referencing Wikipedia.
Qu 3. What makes difference between DBMS and RDBMS.
I answered with the reference of Codd’s rules only. He said to describe. I was not fully aware but I described the last 6 Codd’s rules saying that a DBMS supports 4 Codd’s rules. If it is supporting more than that it will be called as RDBMS.
Qu 4.He asked me the set operators in oracle.
It was a googly ball for me and I smashed it out of the boundary.
Qu 5. Write one example which uses set operator, one which uses sub query, one uses alieses, one to display today’s date, one to display 2 months later date, one to display 2 months earlier day?
He gave these questions and left the room. In his opinion these was a Yorker but I made these as over-pitch and smashed 6 sixes. For sub query example I used Level pseudo column, for aliases I used Dense_Rank() analytic function and simple selected Sysdate from dual. I had written this much only, he entered the room and took my sheet. I said I have to write 2 more answers. He said,”No problem”. He checked my queries very minutely but he was not able to get any thing missing. He asked “How to get 2 months later date and 2 months earlier date?” I said using ADD_MONTH() function. He was satisfied.
Qu 6: What are procedures and how they are different from function? When should we go for function and when to go with procedures? What are the modes of parameter and how and what operation we can perform with these parameters.
These questions were not in one go. He asked in a sequence. I answered them very perfectly, with almost 6-7 differences between procedure and function.
Qu 7: What is the significance of copy keyword in parameters?
I said sorry sir I don’t know. This was the first bouncer from his side.
Qu 8: What are triggers? What are instead of triggers? What is correlation identifier? How many types of triggers are there? When you should go for statement level triggers and row level triggers? What we cannot do with statement level trigger?
These questions were also in a sequence on after another. Again he gave me few easy over throw runs. He confused me little bit in the use of statement level trigger. But I passed that also.
Qu 9: What are cursors? What are different types of cursors? What is a ref cursor?
This was the question I was waiting for. Actually he asked cursor only. Before he will ask the next level of cursor, I vomit all the theory of cursors along with the cursor attributes and its usage.
Qu 10: Tell me about dual table?
I described starting from system schema object to its data type of the column and the value stored in the column. I forgot the column name that time. He asked “what is the column name?” I don’t know how I forgot the name of the column which is DUMMY. I was trying to recall but time was up and he asked the last question.
Qu 11: What is a transaction and how to complete a transaction?
It was again an easy one for me but I did a mistake. He asked, “What are TCL?” I said Transaction control language and I said Grant and revoke are TCL. Before he interrupts I said sorry and said Commit, Rollback and Save point. Then he asked what we call to Grant and Revoke. And again I tried a lot but was not able to remember DCL.
Finally he stood up and I felt relaxed that at least my interview is over now. It was almost all 1 hour. He shook his hand again and said that please wait on first floor, HR will meet you. I was happy with my performance. I thought that I will be selected. I waited for 10 minutes. Now I could see Maya coming towards me. She opened the glass door and with a smile she said those words; which I was dying to hear. She Said, “Congratulations Ajit! You have been selected, just give me five minutes; I will ask the director whether you have to talk to him or I will directly issue the OFFER LETTER”. I said “Thank you Mam. I am waiting”. She came and said “Director is on phone, and he will not be free for next few hours; so its 100% confirm, I will call you in the evening and tell you when to collect the offer letter”. I said “Ok Mam, Thank you”. And I left the company.
In the evening I called her. She said that you have been offered and you can come and collect your offer letter tomorrow. I said “Ok and disconnected the phone”. ##****## (Why I kept these hash & stars, I will explain it later). Next day I went to MetricStream and Maya told me that they have some conversation with Bell Softech (my consultancy) and Bell Softech is going to give me the offer letter. I asked Prathibha ( Bell Softech’s HR). She said,” You will get the offer letter by tomorrow or day after tomorrow (i.e. on 15th or 16th July)”. I was bit confused like what is happening. I had already left few final round interviews on Java hoping that I got this one and these people were doing ‘tamasha’.
In the evening I called her. She said that you have been offered and you can come and collect your offer letter tomorrow. I said “Ok and disconnected the phone”. ##****## (Why I kept these hash & stars, I will explain it later). Next day I went to MetricStream and Maya told me that they have some conversation with Bell Softech (my consultancy) and Bell Softech is going to give me the offer letter. I asked Prathibha ( Bell Softech’s HR). She said,” You will get the offer letter by tomorrow or day after tomorrow (i.e. on 15th or 16th July)”. I was bit confused like what is happening. I had already left few final round interviews on Java hoping that I got this one and these people were doing ‘tamasha’.
On 15th july no call on my cellphone from Bell Softech, my confusion increased. On 16th till evening no call again, confusion went to its peak and finally I decided to call Prathibha. Actually Maya had already told me that I have to join by Monday i.e. 19th july but I was not having any document regarding joining. And 17th was Saturday and 18th was Sunday. Finally I called Prathibha and she said that I will get the offer on Monday morning and I have to join the same day.
And on Thursday 15th July itself I was writing this blog. You noticed those “##****##”. That was the time when I felt uncomfortable. And I left writing it. In an hour I was having little bit fever. I took some medicine at night. But I felt no relief. Next day in the evening I went to doctor, she also gave some other medicine, but no relief again. On Saturday I went to the doctor and described her the situation like I have to join on Monday and I want to be fit and fine by that time. She advised me that through medicines it will take time. If you want to recover soon we have to rely upon injections. She also advised me to admit there. I was admitted and a needle was pinched and they started keeping me on glucose water. It was the first time in my life I have been injected glucose water. They gave many IV(in vain) injections and few IM also. Fever came down but they suspected of Dengue Fever, because my platelets count were decreasing. Sunday evening I was bit fine because no fever was there. So I told them that I have to collect the offer letter and join from tomorrow. They were not ready to discharge me. But on my own risk they finally discharged me. I went to the room. Took some milk and slept. Actually I was still unable to eat any solid thing. Whenever I was trying to eat, I was vomiting. Monday morning I wake up, took bath and decided to leave for my offer letter. I have some Dosha in the morning. I took an auto rickshaw, reached Bellsoftech. Prathibha was late. When I reached there my situation was worse. I vomited there many times and now all I wanted was a bed to sleep. I was not having power to walk. Somehow I managed and Prathibha came. She saw me and understood that I am not well. She gave me the offer letter and said that first go and have good treatment. I left with Jainendra one of my colleague, who was also there to collect the offer letter. I returned and directly went to hospital. I was hospitalized again. My platelets count reached 37000. Normal human beings have these platelet counts in blood ranging between 1.5L to 4.5L. It was confirmed that I was having Dengue Fever. Till Tuesday morning platelets counts was between 25000-30000. They said that once it goes below 20000 then only the will transfuse platelets in my blood. And in afternoon it became 23000. Now doctor told that we need to bring platelets. Then she called Blood Banks. All known blood banks were having shortage of platelets. No one was ready to give platelets for me. Finally she referred me to Sagar Hospital Banaratt road. She said that they are having platelets and they will give to their own patients. I understood, it serious now. My friends took me to Sagar Hospital. When we reached there, we saw no one there was satisfied with their treatments, and also they were charging heavily. I told my friend to take me to Applo Hospital. We went there. The doctor in the emergency said, “It’s too serious and you will be kept in ICU, Just wait I will check the status of ICU”. After five minutes he said that we are not having any vacant seat in ICU. I told him to keep me in any ward till a seat is vacant. He denied. I asked him to advice that where we should go. He named a few, the nearest was Fortis Hospital. We went there. The doctor in the emergency took me very lightly. He said you will be kept in general ward. I told the Applo Doctor’s words. He said no, ICU is not required. He also told me to wait. After five minutes he said that we are not having any seat vacant in general ward. These word horrified me. And I thought that I am living my last moments on this planet. Because Blood Banks were not having platelets and those who were having, they have lack of beds. I requested that please keep me anywhere. Keep me in ICU or emergency itself, but please don’t send me anywhere else. He took few more minutes and Thank god he gave me a bed in the emergency. He started his treatment. Sudha Menon was my doctor there. She was brilliant. In the evening I was allotted a bed in a general ward room. That hospital is great. Food is good; treatments are good, much cleaned and well furnished rooms. I stayed there for 3 days and without transfusing platelets, my body generated those platelets by itself. I left the hospital when the graph of platelet count were increasing and was 67000. I came back home on Friday. My father and my maternal uncle reached that day only. In the next two days my platelet count reached 1.8L. I was fully fine. This is my new life. I can say that I have seen death from few meters away; it was a very close save. Thanks God for this new life. Special thanks to my friend Ladan, who was always ready to donate blood for me, actually his blood group is also B -ve like me. He was always with me those days. Also thanks to my two juniors Ankit and Abhishek, who came from Hyderabad to help me and look after me all the time, also thanks to all those friends and people who were with me either physically or mentally those days. This blog title was decided as “My first interview as my last interview” earlier. But now it has changed. On Monday 26th July I got the appointment letter and on the same day I joined MetricStream.
And on Thursday 15th July itself I was writing this blog. You noticed those “##****##”. That was the time when I felt uncomfortable. And I left writing it. In an hour I was having little bit fever. I took some medicine at night. But I felt no relief. Next day in the evening I went to doctor, she also gave some other medicine, but no relief again. On Saturday I went to the doctor and described her the situation like I have to join on Monday and I want to be fit and fine by that time. She advised me that through medicines it will take time. If you want to recover soon we have to rely upon injections. She also advised me to admit there. I was admitted and a needle was pinched and they started keeping me on glucose water. It was the first time in my life I have been injected glucose water. They gave many IV(in vain) injections and few IM also. Fever came down but they suspected of Dengue Fever, because my platelets count were decreasing. Sunday evening I was bit fine because no fever was there. So I told them that I have to collect the offer letter and join from tomorrow. They were not ready to discharge me. But on my own risk they finally discharged me. I went to the room. Took some milk and slept. Actually I was still unable to eat any solid thing. Whenever I was trying to eat, I was vomiting. Monday morning I wake up, took bath and decided to leave for my offer letter. I have some Dosha in the morning. I took an auto rickshaw, reached Bellsoftech. Prathibha was late. When I reached there my situation was worse. I vomited there many times and now all I wanted was a bed to sleep. I was not having power to walk. Somehow I managed and Prathibha came. She saw me and understood that I am not well. She gave me the offer letter and said that first go and have good treatment. I left with Jainendra one of my colleague, who was also there to collect the offer letter. I returned and directly went to hospital. I was hospitalized again. My platelets count reached 37000. Normal human beings have these platelet counts in blood ranging between 1.5L to 4.5L. It was confirmed that I was having Dengue Fever. Till Tuesday morning platelets counts was between 25000-30000. They said that once it goes below 20000 then only the will transfuse platelets in my blood. And in afternoon it became 23000. Now doctor told that we need to bring platelets. Then she called Blood Banks. All known blood banks were having shortage of platelets. No one was ready to give platelets for me. Finally she referred me to Sagar Hospital Banaratt road. She said that they are having platelets and they will give to their own patients. I understood, it serious now. My friends took me to Sagar Hospital. When we reached there, we saw no one there was satisfied with their treatments, and also they were charging heavily. I told my friend to take me to Applo Hospital. We went there. The doctor in the emergency said, “It’s too serious and you will be kept in ICU, Just wait I will check the status of ICU”. After five minutes he said that we are not having any vacant seat in ICU. I told him to keep me in any ward till a seat is vacant. He denied. I asked him to advice that where we should go. He named a few, the nearest was Fortis Hospital. We went there. The doctor in the emergency took me very lightly. He said you will be kept in general ward. I told the Applo Doctor’s words. He said no, ICU is not required. He also told me to wait. After five minutes he said that we are not having any seat vacant in general ward. These word horrified me. And I thought that I am living my last moments on this planet. Because Blood Banks were not having platelets and those who were having, they have lack of beds. I requested that please keep me anywhere. Keep me in ICU or emergency itself, but please don’t send me anywhere else. He took few more minutes and Thank god he gave me a bed in the emergency. He started his treatment. Sudha Menon was my doctor there. She was brilliant. In the evening I was allotted a bed in a general ward room. That hospital is great. Food is good; treatments are good, much cleaned and well furnished rooms. I stayed there for 3 days and without transfusing platelets, my body generated those platelets by itself. I left the hospital when the graph of platelet count were increasing and was 67000. I came back home on Friday. My father and my maternal uncle reached that day only. In the next two days my platelet count reached 1.8L. I was fully fine. This is my new life. I can say that I have seen death from few meters away; it was a very close save. Thanks God for this new life. Special thanks to my friend Ladan, who was always ready to donate blood for me, actually his blood group is also B -ve like me. He was always with me those days. Also thanks to my two juniors Ankit and Abhishek, who came from Hyderabad to help me and look after me all the time, also thanks to all those friends and people who were with me either physically or mentally those days. This blog title was decided as “
add to del.icio.us
saved by 0 users
0 comments:
Post a Comment