One of my Best Interviews at Tech Mahindra part3

TR: Do you know testing concepts?

Me : no sir, but I’ll try.

TR : Did you filled reservation form of Train?

Me : Yes sir, but in online.

TR : no problem, I am giving a form, how can u test this form if you are a testing engineer?

Me : I tried my best but unable to give the answer.

TR : kk, leave it. How can you see yourself after 10 years?

Me : I want to be a software developer after fresher period or 2 yrs, 5 yrs or 10yrs.

TR : If you are a project manager, In your team there are 2  members. One is serious towards work but not quick logic developer another is quick logic developer but not serious. Whom do you select?

Me : after 1 min, I choose Serious one sir

TR : Reason plz?

Me : sure sir, Serious one don’t knew the logic, but he knew how to finish the work in time, so he might ask his co-workers to complete his work.

TR : Not satisfied with yours. But somewhat right. Did you attend any drives before?

Me : Yes sir, attended CTS, Accenture, IBM … etc so on.

TR : kk, leave it., Any questions?

Me : How is the life in TechMahindra?

TR : Said about 10 minutes., Anymore?

Me : can I’ve my feedback?

TR : 50-50 chances, Judge yourself?

Me : I think, my view in the Object orientation problem is excellent.

TR : true.

Me : Form concept is bad.

TR : true

Me : way of presentation is good.

TR : true, if I reject u in this round, what can you do?

Me : No sir, I done well. So there is no chance to rejecting me.

TR : no, I rejected you, what can u do?

Me : no problem sir, I’ll attend after 6 months, if it is not happened then I’ll be here with 3+ experience.

TR : good, then do it like that.

Me : no answer with simple smile.

TR : K, I am giving last chance to you, please test the reservation form

Me :

1 : If the train num is 70693 then it goes to 70100 itz a problem sir.

2: If the entered train doesn’t goes in the source station , if it k, then no problem.

3 : If we applied for the lower berth it gives the upper berth, then itz a problem.

So on . . . .

TR : Very good. Why didn’t u think last time? Even u’ve 50-50 chances. I miss you really. Sorry. Please leave now.

Me : I left the interview hall.

After 5 min, I am going outside with my stick file, then he stopped me and said, I was just joked, stay here for the next round. I wish you very all the best for the next round, hope you’ll be here.

Me: Thank you so much sir.

This total discussion done in 90 minutes.

<<<Previous

Also read: 50 Common Interview Questions & Answers

Read More »

One of my Best Interviews at Tech Mahindra part2

TR : Some what correct, k, leave it, I’ll give some words, arrange them in super class and sub class manner.

Apple juice,  Restaurant, Pizza, Eatables, Individual house, drinks, apartment, burger, Residential unit, Sprite.

Me : I arranged in order and shown him.

TR : Explain the relation in technical manner.

Me : Explained nearly about 10min by using object orientation concepts.

TR : good answer., tell me about your project?

Me: Explained.

TR: Why you people preferred wireless in Your project?

Me: Now whole world is moving towards comfort and easiness, so we preferred wireless.

TR : What is your role in your project?

Me : Involved in every module sir, but mainly concentrated on resource management and coding.

TR : How many modules are there in project?

Me : explained.

TR: Do You know about database concepts.

Me : Little bit.

TR : Okay, Draw the NAND gate?

Me : Drawn

TR : Different types of Flip Flops?

Me : RS flipflops, JK flipflops, D flipflops . .etc

TR : usage of Flipflops . .

Me : used to store the 1 byte data.

TR : It can stote the data, but not used to store, Level trigger operation?

Me : I am unable to recollect all those concepts which I studied in my engineering  life. Sorry sir.

TR : You addicted to software, am I right?

Me : Yes sir . . .. . . .

TR : But it’s not good to forget basic core concepts.

Me : I didn’t remembered sir but not forget.  We designed our project on our own ideas, we developed our code with the help of my lecturers. It is not possible without knowing basics of core subjects.

TR : I got it., hobbies?

Me : Dancing, Photo Editing

TR : Dancing ??

Me : yes sir

TR : favourite dancer?

Me : Jr.NTR

TR : He is great actor, but not dancer  . .

Me : I like his dance sir

TR : don’t u like Prbhudeva dance?

Me : I love prabhu sir dance, but I can’t do because I don’t have springs in my body.

TR : Escaping Intelligently

Me : Simple Smile.

TR : have u mischief anything using photoshop?

Me : no sir, I edit only my photos and child.

TR : What are the diff types of dances in india?

Me : kathakali, bharatahanatyam, kuchipudi so on .. .

TR : in which dance, dancers use most facial make up?

Me : I think in the kathakali sir.

<<<Previous         Continue>>>

Also read: 50 Common Interview Questions & Answers

Read More »

50 Common Interview Questions & Answers part3

Part1    Part2    Part3

31. Tell me about your ability to work under pressure.

You may say that you thrive under certain types of pressure. Give an example that relates to the type of position applied for.

32. Do your skills match this job or another job more closely?

Probably this one. Do not give fuel to the suspicion that you may want another job more

than this one.

33. What motivates you to do your best on the job?

This is a personal trait that only you can say, but good examples are:

Challenge, Achievement, Recognition

34. Are you willing to work overtime? Nights? Weekends?

This is up to you. Be totally honest.

35. How would you know you were successful on this job?

Several ways are good measures:

You set high standards for yourself and meet them. Your outcomes are a success.Your boss tell you that you are successful

36. Would you be willing to relocate if required?

You should be clear on this with your family prior to the interview if you think there is a

chance it may come up. Do not say yes just to get the job if the real answer is no. This can create a lot of problems later on in your career. Be honest at this point and save yourself future grief.

37. Are you willing to put the interests of the organization ahead of your own?

This is a straight loyalty and dedication question. Do not worry about the deep ethical and philosophical implications. Just say yes.

38. Describe your management style.

Try to avoid labels. Some of the more common labels, like progressive, salesman or

consensus, can have several meanings or descriptions depending on which management

expert you listen to. The situational style is safe, because it says you will manage according to the situation, instead of one size fits all.

39. What have you learned from mistakes on the job?

Here you have to come up with something or you strain credibility. Make it small, well

intentioned mistake with a positive lesson learned. An example would be working too far

ahead of colleagues on a project and thus throwing coordination off.

40. Do you have any blind spots?

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

41. If you were hiring a person for this job, what would you look for?

Be careful to mention traits that are needed and that you have.

42. Do you think you are overqualified for this position?

Regardless of your qualifications, state that you are very well qualified for the position.

43. How do you propose to compensate for your lack of experience?

First, if you have experience that the interviewer does not know about, bring that up: Then, point out (if true) that you are a hard working quick learner.

44. What qualities do you look for in a boss?

Be generic and positive. Safe qualities are knowledgeable, a sense of humor, fair, loyal to subordinates and holder of high standards. All bosses think they have these traits.

45. Tell me about a time when you helped resolve a dispute between others.

Pick a specific incident. Concentrate on your problem solving technique and not the dispute you settled.

46. What position do you prefer on a team working on a project?

Be honest. If you are comfortable in different roles, point that out.

47. Describe your work ethic.

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

48. What has been your biggest professional disappointment?

Be sure that you refer to something that was beyond your control. Show acceptance and no negative feelings.

49. Tell me about the most fun you have had on the job.

Talk about having fun by accomplishing something for the organization.

50. Do you have any questions for me?

Always have some questions prepared. Questions prepared where you will be an asset to

the organization are good. How soon will I be able to be productive? and What type of

projects will I be able to assist on? are examples.

Part1    Part2    Part3

Read More »

50 Common Interview Questions & Answers part 2

Part1    Part2    Part3

16. If you had enough money to retire right now, would you?

Answer yes if you would. But since you need to work, this is the type of work you prefer. Do not say yes if you do not mean it.

17. Have you ever been asked to leave a position?

If you have not, say no. If you have, be honest, brief and avoid saying negative things

about the people or organization involved.

18. Explain how you would be an asset to this organization

You should be anxious for this question. It gives you a chance to highlight your best points as they relate to the position being discussed. Give a little advance thought to this

relationship.

19. Why should we hire you?

Point out how your assets meet what the organization needs. Do not mention any other

candidates to make a comparison.

20. Tell me about a suggestion you have made

Have a good one ready. Be sure and use a suggestion that was accepted and was then

considered successful. One related to the type of work applied for is a real plus.

21. What irritates you about co-workers?

This is a trap question. Think real hard but fail to come up with anything that irritates you. A short statement that you seem to get along with folks is great.

22. What is your greatest strength?

Numerous answers are good, just stay positive. A few good examples:

Your ability to prioritize, Your problem-solving skills, Your ability to work under pressure,

Your ability to focus on projects, Your professional expertise, Your leadership skills, Your

positive attitude .

23. Tell me about your dream job.

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

24. Why do you think you would do well at this job?

Give several reasons and include skills, experience and interest.

25. What are you looking for in a job?

See answer # 23

26. What kind of person would you refuse to work with?

Do not be trivial. It would take disloyalty to the organization, violence or lawbreaking to get you to object. Minor objections will label you as a whiner.

27. What is more important to you: the money or the work?

Money is always important, but the work is the most important. There is no better answer.

28. What would your previous supervisor say your strongest point is?

There are numerous good possibilities:

Loyalty, Energy, Positive attitude, Leadership, Team player, Expertise, Initiative, Patience, Hard work, Creativity, Problem solver

29. Tell me about a problem you had with a supervisor

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

30. What has disappointed you about a job?

Don't get trivial or negative. Safe areas are few but can include:

Not enough of a challenge. You were laid off in a reduction Company did not win a contract, which would have given you more responsibility.

Part1    Part2    Part3

Read More »

50 Common Interview Questions & Answers part1

Part1    Part2    Part3

1. Tell me about yourself:

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

2. Why did you leave your last job?

Stay positive regardless of the circumstances. Never refer to a major problem with

management and never speak ill of supervisors, co-workers or the organization. If you do, you will be the one looking bad. Keep smiling and talk about leaving for a positive reason such as an opportunity, a chance to do something special or other forward-looking reasons.

3. What experience do you have in this field?

Speak about specifics that relate to the position you are applying for. If you do not have

specific experience, get as close as you can.

4. Do you consider yourself successful?

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

5. What do co-workers say about you?

Be prepared with a quote or two from co-workers. Either a specific statement or a

paraphrase will work. Jill Clark, a co-worker at Smith Company, always said I was the

hardest workers she had ever known. It is as powerful as Jill having said it at the interview herself.

6. What do you know about this organization?

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

7. What have you done to improve your knowledge in the last year?

Try to include improvement activities that relate to the job. A wide variety of activities can be mentioned as positive self-improvement. Have some good ones handy to mention.

8. Are you applying for other jobs?

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

9. Why do you want to work for this organization?

This may take some thought and certainly, should be based on the research you have done on the organization. Sincerity is extremely important here and will easily be sensed. Relate it to your long-term career goals.

10. Do you know anyone who works for us?

Be aware of the policy on relatives working for the organization. This can affect your answer even though they asked about friends not relatives. Be careful to mention a friend only if they are well thought of.

11. What kind of salary do you need?

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

12. Are you a team player?

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

13. How long would you expect to work for us if hired?

Specifics here are not good. Something like this should work: I'd like it to be a long time. Or As long as we both feel I'm doing a good job.

14. Have you ever had to fire anyone? How did you feel about that?

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

15. What is your philosophy towards work?

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

Part1    Part2    Part3

Read More »

One of my Best Interviews at Tech Mahindra

This is one of my best interviews. This great one was happened with Tech Mahindra.  Cleared written Test with sectional cut off marks out of 170 bits in 70 min.

Technical Round :

TR : Mr. Hareesh

Me : Yes sir

TR :  Take your seat and by the way so nice name

Me : Thank You sir

TR : How are you hareesh? How was ur journey?

Me : Fine, So cool from morning sir. What about you sir?

TR : good man, shall we start?

Me : sure sir

TR : you are from the electronics background, how are you  fit for IT?

Me : I committed to software development and more than I done Oracle certification in java. I learned HTML, CSS, JavaScript, adobe Photoshop CS6, Database concepts. I developed and designed two blogs. So . . .

TR: Why you turned IT side? Can you give me an example?

Me : When I click on the submit button of an application or anything like that, I scared to know how the result is coming. I am very enthusiastic to know about that. That interest turned me to this IT side.

TR : kk, any reason to join us?

Me : When I was in intermediate , it is  my dream to be a part of Satyam Computers. I don’t know the exact reason till now, but most of my friends said that, it is  a good company which will give good life.

TR : oh, really!!

Me : yes sir,

TR : Tell me the compiler usage?

Me : For checking the syntactical errors

TR : I think it is not only the reason

Me : The compilation code is not understandable to the users.

TR : You are around the jackpot but note exact.

Me : To achieve the platform in-dependency by creating .class file.

Continue>>>

Also read: 50 Common Interview Questions & Answers

Read More »

Database Structures FAQ's

Database Structures FAQ's

1. What are the components of physical database structure of Oracle database?
Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.

2. What are the components of logical database structure of Oracle database?
There are tablespaces and database's schema objects.

3. What is a tablespace?
A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together.

4. What is SYSTEM tablespace and when is it created?
Every Oracle database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

5. Explain the relationship among database, tablespace and data file.
Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace.

6. What is schema?
A schema is collection of database objects of a user.

7. What are Schema Objects?
Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links.

8. Can objects of the same schema reside in different table spaces?
Yes.

9. Can a tablespace hold objects from different schemes?Yes.

10. What is Oracle table?
A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

11. What is an Oracle view?
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)

12. Do a view contain data?
Views do not contain or store data.

13. Can a view based on another view?
Yes.

14. What are the advantages of views?
- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.

15. What is an Oracle sequence?
A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

16. What is a synonym?
A synonym is an alias for a table, view, sequence or program unit.

17. What are the types of synonyms?
There are two types of synonyms private and public.

18. What is a private synonym?Only its owner can access a private synonym.

19. What is a public synonym?
Any database user can access a public synonym.

20. What are synonyms used for?
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

21. What is an Oracle index?
An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

22. How are the index updates?Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.

23. What are clusters?Clusters are groups of one or more tables physically stores together to share common columns and are often used together.

24. What is cluster key?
The related columns of the tables in a cluster are called the cluster key.

25. What is index cluster?
A cluster with an index on the cluster key.

26. What is hash cluster?A row is stored in a hash cluster based on the result of applying a hash function to the row's cluster key value. All rows with the same hash key value are stores together on disk.

27. When can hash cluster used?
Hash clusters are better choice when a table is often queried with equality queries. For such queries the specified cluster key value is hashed. The resulting hash key value points directly to the area on disk that stores the specified rows.

28. What is database link?A database link is a named object that describes a "path" from one database to another.

29. What are the types of database links? 
Private database link, public database link & network database link.

30. What is private database link?
Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

31. What is public database link?
Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.

32. What is network database link?Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.

33. What is data block?
Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

34. How to define data block size?
A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.

35. What is row chaining?In circumstances, all of the data for a row in a table may not be able to fit in the same data block. When this occurs, the data for the row is stored in a chain of data block (one or more) reserved for that segment.

36. What is an extent?An extent is a specific number of contiguous data blocks, obtained in a single allocation and used to store a specific type of information.

37. What is a segment?
A segment is a set of extents allocated for a certain logical structure.

38. What are the different types of segments?
Data segment, index segment, rollback segment and temporary segment.

39. What is a data segment?
Each non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

40. What is an index segment?
Each index has an index segment that stores all of its data.

41. What is rollback segment?
A database contains one or more rollback segments to temporarily store "undo" information.

42. What are the uses of rollback segment?
To generate read-consistent database information during database recovery and to rollback uncommitted transactions by the users.

43. What is a temporary segment?
Temporary segments are created by Oracle when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.

44. What is a datafile?
Every Oracle database has one or more physical data files. A database's data files contain all the database data. The data of logical database structures such as tables and indexes is physically stored in the data files allocated for a database.

45. What are the characteristics of data files?
A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.

46. What is a redo log?
The set of redo log files for a database is collectively known as the database redo log.

47. What is the function of redo log?The primary function of the redo log is to record all changes made to data.

48. What is the use of redo log information?The information in a redo log file is used only to recover the database from a system or media failure prevents database data from being written to a database's data files.

49. What does a control file contains?
- Database name
- Names and locations of a database's files and redolog files.
- Time stamp of database creation.

50. What is the use of control file?
When an instance of an Oracle database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

Read More »