Interview Tips

We know many people struggle with interviews though they are the most experienced and best qualified for the job.
When you are invited to an interview it means that the hiring manager believes you may be a good match for the job opening, and he or she wants to know for sure. The interview is used to determine whether you are qualified for the position. Also one important thing as the job seeker is, you should make use of the interview to determine whether you can be successful in the available position.
A candidate who can answer questions in a way which is acceptable, but not necessarily right, to the interviewer, someone who knows something about their potential employers business and the post they hope to fill. These are really the basic components of any candidate who 'interviews well'. There are undoubtedly other aspects employers may look for in relation to specific posts - having their own ideas, thinking on their feet, aspects which will be related to the job and to the company's preference in employees.
Job interview tips gives you information about how to face the interview.
The job interview tips covered most job interview tips and also covered lots of things which we have to avoid during interview.
Now a day, employers use telephone interviews as a way of identifying and recruiting candidates for employment. This site providesphone interview tips, which contains the information about how to face the telephonic interview. You never know when a recruiter call and ask if you have a few minutes to talk.
After the first interview next step is second interview. When employers complete their initial interviews for a job opening, they ask the top candidates back for a second interview before making a final decision. This site provides the information about second interview tips.
Here are some Do's and Don'ts while interview.

 

Do's

Some job interview tips are given below, please go through it, that will help you a lot.

Preparation and confidence are very important tips. Good preparation always creates confidence. So the important thing to an interview is to be well prepared. In this you have to consider two things:

  1. Checklist

While going to interview you must consider the following things:

  1. Be on time!

Public transport may be useless if the traffic is heavy. Always keep in mind that you never get a second chance to make a first impression. So be on time at the particular location of interview.
Also if you are there so early, you can wait nearby cafe of shop. And if you are going to be late, then best option is call them.

  1. Be Prepared!

Preparation means not only preparation of your syllabus etc. but also look at the company's website and learn something about the company before you attend your interview.

  1. Write down and practice possible questions!

If you collect the job interview sample questions and practice for it then it will make easy to remember when you get to the interview. Use the third person when talking about the job. Avoid sounding as though you assume the job is yours.
It is fine to ask about the package on offer and accommodation - living in and living out are particularly relevant. Do not forget to find out if the company will guarantee a resort or chalet - many will only allocate you a country. You could also try a fewer more testing questions such as how they differentiate themselves from their competitors or what they think the toughest/hardest part of the job is.

  1. You never get a second chance to make a first impression!

First keep in mind that you never the second chance to make a first impression so be careful.
Some points are here to remember:

  1. Do not talk too much!

Always remember that communication is two-way things so give them a chance. Also don't interrupt to interviewer when he/she is talking. Give him/her full chance to talk.
One common mistake candidates make when interviewing is talking too much. It is important to listen to the question asked and answer that question. Keep your answers to two to three minutes at the most. When you limit your time, you tend to stay more focused. It is very easy to stray off the subject and ramble about things irrelevant to the job if your answer is too long.

During interview always enthusiastic. Do not say bad points for the previous employers. Focus on positive achievements and views.

  1. Check in During Interviews

Your initial interview answers should be brief. But some of your best stories may take time to detail, then after two minutes ask for permission to go on. You may say something like, "Now I have described about my project, would you like to hear about my role in detail?"

  1. Answer Briefly

The best interviews have a give and take atmosphere. To do this, you need to ask questions and try to draw out your interviewer rather than talking about yourself nonstop. When it comes to talking during an interview, sometimes less is more. A general rule is you should speak one-third of the time and definitely no more than half of the time. When it is your turn to speak, do not hesitate to talk about yourself.

  1. First Comes the Phone

Now a days telephone screening is becoming very common. So you need to be prepared for the phone to ring at any time. These screenings may be for 10 to 15 minutes, depending on your answers and fit for the job. it is helpful if you have thought about questions likely to be asked during the screening and prepared your answers.

  1. Take a spare photo and CV with you!

It may happen that the interviewer wants your resume and photo. Your interviewer won't be expecting it so you will impress them. It also helps them remember you after the interview. So always keep a spare photo and resume with you while going to interview.

  1. Look Them in the Eyes

Eye contact is showing your confidence. Eye contact is one of the most important aspects of nonverbal communication and can make a significant difference in how you present yourself. If you look away when speaking to someone, you are viewed as lacking confidence or interest. So always answer the question with eye contact to interviewer.

  1. Look Better, Feel Better

If you want to spruce up your appearance for the interview but can not afford new clothes, consider altering an outfit you already have by pairing it with a different shirt, tie, blouse or accessory. Even on a tight budget, you can find some real bargains out there. Think about what you need before you go out shopping. Outlet stores and resale shops offer some great treasures. For better or worse, looks can make a difference.

  1. Talk about specific achievements!

Interviewers like to know how you felt about a particular success. Some will ask for specific examples of things you have done that you are particularly proud of; how you solved problems; how you learned - and improved - from difficult situations.

  1. Think of an Interview as a First Date

Instead of the Inquisition, think of a job interview as a first date: you are both trying to figure out if there is a match. This mindset proffers many advantages. You come off as curious, not desperate, you do not assume that too-formal, phony-appearing job-seeker persona, you talk about what you want to talk about instead of just passively getting bombarded with the employer's probes and you are more likely to ask questions during the interview. Those questions will help you assess if you really want the job. Treat the interview as a first date, and you will both be better informed when deciding whether you should hook up.

  1. Bring Up a Weakness

In an interview, bring up a weakness before you are asked for one. For example, "I really need to work on my leadership skills. I am a good worker and totally competent, but sometimes I lack the confidence to stand up and take a leadership position."
This will help you a lot as you want to improve yourself.

  1. Get the Info

Informational interviews are a great way to get leads and information regarding company. It is important that the person you contact understands you are seeking information not a job. Be prepared when you ask for an appointment to say what you are looking for and why you want to talk to this person. At the informational interview, have a prepared list of questions. At the end, ask if the person has any recommendations of others you could speak with.

  1. Virtual Thanks

You can send follow-up letters through email if this is the way you and the potential employer have been communicating all along.

  1. Attitude Adjustment

It is difficult to remain upbeat in a tough job market. Isolating you and waiting for the phone to ring is the worst way to handle negative thoughts. When you start feeling down, take steps to turn your thinking around. Go for a walk, or do something fun. It may be just what you need to feel relaxed and at ease. Getting together with friends and having a support system will help you to laugh and keep going.

  1. Explain Why You Left

Follow these guidelines when interviewers ask, "Why did you leave your company?" Carefully describe the reason for your departure, and do not go into details unless asked. Provide references to support your reasons for leaving and job performance. Stay with the facts of what happened, what you did, how you felt and what you learned. Then describe how you will handle things differently in the future.

  1. Your References

For your reference list, you want three to five people and their contact information. Do not forget to get permission to use your references' names, and while you are at it, ask how they prefer to be contacted. You should also send them a copy of your resume so they will be aware of what you are saying about yourself.

  1. The World's Toughest Job Interview Question

Great questions to ask early in a job interview: "What are you most hoping to find in the person you hire?" and "What would be my first priorities on the job?" The earlier you can ask these questions, the sooner you can start tailoring your answers to the employer's priorities. At the end of the interview, ask, "Based on what we've talked about today, I feel good about the position. Do you have any concerns about my ability to do the job?" Often, that gives you a chance to counter any objections.

  1. Know What You Offer

Prepare answers for open-ended questions, like, "Tell me about yourself," by making a list of your skills and traits that match the employer's requirements. The closer your skills and traits are to the job description, the better chance you have of landing the job. You should leave the interviewer with a clear picture of what you have to offer.

  1. Prove What You Could Do

Always put a positive spin on your answers to difficult questions. If you lack a particular skill or do not know a certain computer program, be sure to emphasize how quickly you learn. Give an example of a time when you were able to get up to speed in a similar situation. Companies are interested in people who can hit the ground running.

  1. Sell Yourself

Interviewing is about selling yourself. The product you are selling is you. Give them reasons to buy. Tell them what you can do for them. Emphasize what you can bring to the company, department and position. Convince them that your product is better than the competition's

  1. Talking Salary

Timing is everything in the interview. Let them bring up the subject of money. If you are asked what your salary expectations are too early in the process, just say you would rather postpone that discussion until you have more information about the position.

  1. Ask your way into a better job

You can not really tell how good a job is from a want ad. There's often a gap between the exciting opportunity portrayed in the ad and the actual job.
You can often get the straight scoop about a job by asking the right questions. For example, in the job interview, ask, "What attributes are most needed to succeed in this job?"
After you are offered a job but before accepting it, ask a few more questions or even ask permission to talk with your future coworkers.

Listening is one of the most underused interview skills. Most candidates are so nervous about answering interview questions correctly that they forget to listen. Follow these tips:

 

  1. Ask the power questions

In the earlier you can ask these questions:

  1. it is OK to be nervous

Not only is it OK to be nervous about an interview, but it is essential for you to accept how you feel. Telling yourself you should feel differently than you do is unrealistic and just makes you feel bad about yourself. What's the worst that can happen at an interview? For many, it would be not getting an offer. Did you ever think that maybe the job wasn't right for you? Try to look at the process as a learning experience.

  1. Put up with rejection?

If you are rejected from the company, you may feel hurt, angry or fed up. Instead of being stuck in feeling rejected, take back the power by staying proactive. If you really wanted to work for that particular company, sit down and write a letter. Remind them of all the positive points you could bring to the organization. Let them know you are still interested in working for the company if something should change or open up.

  1. Face the feedback

If you ask for feedback from an interviewer, be prepared to hear things that could be upsetting. You should listen carefully, and take notes to refer to and react to. Do not argue or defend yourself. At last do not forget to thank the interviewer. Then, take the advice and think about changing some techniques to improve on your next interview.

  1. Follow the interviewer

During the interview, your interviewer is giving you information that can guide you on how to behave during the meeting. Observe your interviewer's style. Listen very carefully, and let him/her know that you have been listening by asking good questions and making good comments. Answer questions by providing the information asked for.

  1. Emotional preparation

Preparing emotionally for the interview is also important. The right mood helps you perform at your best. Try out following points for preparing emotionally:

  1. Preparing to meet the employer

The interview is not the time to get to know about the post or the employers business. It is a chance for you and the employer to get to know one another.
Gather information about your employer before you are interviewed like what are their current projects, what other interests do they have? etc.
You should know job description, or ask someone in a similar post. Otherwise ring the company to clarify.
Keep in mind that the employer is interested in you as a person, your experiences and your opinions do take the time to sit down and think about you, who you are and what you have achieved.
Remember the one thing that your CV must be with you and make notes about your work record and what you have achieved. Make notes and prepare and rehearse sound bites about yourself.

  1. Ask Questions

There is always the opportunity to ask them questions at the end of the interview, remember the interview is a two-way process, you need to be sure you want to join them. Try to concentrate on issues, which are both important to you and combine an apparent interest in the company. Write your questions down prior to the interview and take them with you.

  1. Be honest!

Be honest with every question. No need to lying about your background and/or skills. If you get caught then you will definitely out. Job interviews are about matching needs, if there is not a good match, then there is no chance of job.

  1. Check your CV for possible gaps!

If there is any gap between your academic then make sure you know how you are going to explain time gaps on your CV.

  1. Presentation

Dressing is also important aspect at the time of interview. Dressing should be appropriate for the post and the company. Try to get information about what the company would expect from employees. What would be appropriate for a building company is very different for a public relations agency. Be well-groomed and clean and above all try to look confident.

  1. Thank-You Salutations

While writing an interview thank-you note, problem may arise like whether to use a formal or informal salutation? If the hiring manager is in a high position of authority, use a formal salutation. But if the hiring manager suggests using her first name. When in doubt, use a formal salutation.

  1. Get to Work!

If you are Unemployed? Then your job right now is to find a job. Do not blame to yourself. Think of this as going to work. Research companies, industries and positions. Take this as good experience to succeed in future interviews.

 

Don'ts

As we have to consider the positive things while interview, also we have to consider the worst interview blunders.
Following are the points which we have to avoid during the interview:

Keep in mind that preparation always increases confidence. So do not face the interview without preparation. You cannot communicate without pre-interview research.

  1. Showing up late or too early:

One of the first lessons in job-search is to show up on time for interviews. Many job seekers do not realize that showing up too early often creates a poor first impression. Arriving more than 10 minutes early for an interview shows that the job seeker has too much time on his or her hands. Always remember that your time is as valuable as the interviewer's. Always arrive on time, but never more than 10 minutes early.

  1. Poor handshake:

In every place handshaking matters a lot. With the help of handshaking anyone can judge your personality. The shake hand starts the interview and that is your first opportunity to create a great impression. If you have delivered a poor handshake, it is impossible for you to recover it. Here are some examples:

Your handshake may be telling more about you than you know. Ask about your handshaking to your friends who are not afraid to tell you the truth.

  1. Treating the receptionist rudely:

The first person you meet on an interview is a receptionist. The receptionist has the power to say about your positive or negative points before you even set eyes on the interviewer. The interviewer may also solicit the receptionist's opinion of you after you leave.

  1. Talking too much:

Talking too much always creates a problem. To avoid over-talking, practice answering questions in a direct manner. Avoid nervous talking by preparing for your interview with role-play.

  1. Talking negatively about current or past employers/managers:

The fastest way to talk yourself out of a new job is to say negative things. Even if your last boss was not good, never state your ill feelings about him/her. No matter how reasonable your complaints, you will come out the loser if you show that you disrespect your boss because the interviewer will assume that you would similarly trash him or her. When faced with the challenge of talking about former employers, make sure you are prepared with a positive spin on your experiences.

Do not ask about the benefits, vacation time or salary during the first interview. Wait until you have won the employer over before beginning that discussion.

  1. Verbal ticks:

The first signs of nervousness are verbal ticks. We all have them from time to time "umm," "like," "you know." You can also sometimes avoid verbal ticks by pausing for a few seconds to gather your thoughts before each response.
To reduce the verbal ticks practice for sharing your best success stories ahead of time, and you will feel more relaxed during the real interview.

  1. Not enough/too much eye contact:

Eye contact shows your confidence but it may happen that it creates a negative effect also. Avoid eye contact and you will seem shifty, untruthful, or disinterested. If you sometimes have trouble with eye-contact balance, work this issue out ahead of time in an interview practice session with a friend.

  1. Failure to match communication styles:

It is almost impossible to make a good first impression if you can not communicate effectively with an interviewer. But you can easily change that situation. Following points will help to you.

Allowing the interviewer to set the tone of conversation can vastly improve your chances of making a favorable impression.

  1. Final Thoughts

Just as a strong resume wins you an opportunity to interview, strong interview skills will win you consideration for the job. You already know that you won't earn an interview unless your resume sets you apart as a candidate of choice. Start your job search with a resume that creates a stellar first impression.

 


http://www.careerone.com.au/jobs/job-search/get-that-job/interview-tips
Being as prepared as possible is the key to success in the interview.

Research


Visit the prospective employer's website and browse through the "About Us," "Employment," "Careers," "Our People," and "Media" or "News" sections. The Library and other large reference libraries will be able to provide newspaper clippings on a given company so it might be worth a visit. An annual report can also be a great source of information and can be picked up from the reception desk of the company you are interviewing with. Again, Libraries keep the annual reports of government organisations as well as a number of publicly listed companies. If you are going through a recruitment firm, your consultant should be only too happy and impressed to help you do your homework.

Rehearse


Rehearsing with a friend or family member is a great way to reduce pre-interview nerves. It will not only build confidence and communication skills but will also help you get your thoughts straight. Your rehearsal partner can tell you if you're speaking too quickly, if your sentences are too long or your answers hard to follow. Rehearse again and again until you feel your answers are flowing. Oh, and don't get mad at your rehearsal partner when they raise improvement points.

Use the "behavioural interviewing" technique


This is where the question requires the interviewee to provide an actual example from their work or life experience. Questions will start with words such as "Tell me about a time when..." or "Give me an example of ...". The technique is built on the theory that best predictor of future performance is past performance.

Pre-interview check


Before the interview, find out the name and title of each and every person you will be meeting with. Memorise the names. Again, your recruitment consultant should provide these. If you are dealing directly with the company, it's perfectly acceptable to ask its HR department to provide these details.

Appearance


Take extra care with your appearance. Ensure your clothes are clean and well ironed. Check for stains, stray threads and loose buttons. Avoid visual distractions such as loud ties, chipped nail polish, heavy make up, sheer fabrics, heavy ear rings, jewellry that jangles, overpowering fragrances and unwashed hair or hair that flops into your eyes or needs constant pushing back.

Feeling good


On the morning of the interview, go for a walk or spend some time doing stretches. You will breathe deeply, which will help you relax, have better posture and therefore look the part of the successful candidate. On the way to the interview, walk tall and smile. Strangers will smile back at you and the receptionist at the interview firm will be nice to you. By the time you hit the interview, you'll feel good. Remember, some butterflies in the stomach are okay. Fear and excitement both cause butterflies so tell yourself those flutters are excitement.

During the interview


Don't say anything negative about a past employer.

Don't interrupt anyone.

Keep your answers relatively short and to the point. If the interviewer wants more information, he or she will ask for it. By the same token, try to avoid answering with just a "yes" or "no".

Maintain good eye contact. If there is more than one person at the interview, talk to both or all of them - no matter how junior or seemingly incidental.

Prepare something for when you are invited to ask questions. Two to three questions is enough. Sound questions could include who you will be reporting to, questions about the team you would be joining, career path options, projects you could be working on. Salary and benefit questions are best saved up until you have ultimate bargaining power - at the very least, second interview stage. The point of ultimate power is the time between being offered the job and accepting it.

Think carefully before accepting a drink. You might find yourself in a chair without arms and out of reach of a table balancing a coffee, tea or glass of water throughout the interview.

Smile - whenever appropriate of course.

 

 

 

 

 

 

SQL

 

  1. What is a Clustered Index?
  2. What is a Non-Clustered Index?
  3. What is a Fill Factor?
  4. What is Lock Escalation?
  5. What are the various locking options available with SELECT…..?
  6. What is the maximum number of parameters in a stored procedure?
  7. What is the difference between a Batch and a Script?
  8. How data is stored in a view?
  9. How to distinguish a table in a self join?
    1. Alias
    2. Defaults
    3. Columns
    4. Table
  1. There is a table called cust_order existing. At the end of every month the sum of order qty will be added into a table called cust_summary. So what is the relationship between cust_order and cust_summary?
    1. One-tomany
    2. One-to-one
    3. Many-to-many
    4. Many-to-one

 

  1. Display the name, price of the item, if price of item is null, then 0.00 has to be displayed
    1. SELECT name, ISNULL(price,$0.00)
    2. SELECT name, IIF(price,$0.00)
    3. SELECT name, COALESCE(price,$0.00)
    4. SELECT name, IF(price,$0.00)

 

 

 

 

  1. There as 2 tables cust_summary and cust_info. The cust_info table contains columns like cust_id, amount, name etc., The group total of amount for each customer is calculated and updated in the total_amount of the cust_summary table. It should be seen that the cust_summary table is not updated when these updation are taking place

 

BEGIN TRAN
SELECT cust_id, total=SUM(amount)
INTO #cust1
FROM cust_info
GROUP BY cust_id HOLD LOCK
UPDATE cust_summary
SET a.total_amount = b.total
FROM cust_summary a, #cust1 b
WHERE a.cust_id=b.cust_id
COMMIT TRAN
END TRAN

    1. Will meet the requirements and is an outstanding solution
    2. Will meet the requirements and is an adequate solution
    3. Will meet the requirements but is not a desirable solution
    4. Will not meet the requirements and will not work.

 

  1. To list all the books starting with ‘Computers’

SELECT * FROM titles WHERE name = %computer%

    1. Will meet the requirements and is an outstanding solution
    2. Will meet the requirements and is an adequate solution
    3. Will meet the requirements but is not a desirable solution
    4. Will not meet the requirements and will not work.
  1. Which of the following restrictions apply to the ALTER TABLE statement?
    1. You cannot use ALETR TABLE to remove a column from a table
    2. You cannot use ALETR TABLE to add a PRIMARY KEY constraint to a table.
    3. You cannot use ALETR TABLE to add a NULL column to a table with existing data
    4. When adding a constraint to an existing table with the ALTER TABLE statement, existing data will not be checked against the new constraint.

 

  1. What is the difference between a primary key and a unique key?
  2. What are constraints? Explain different types of constraints
  3. What is a join and explain different types of joins?

 

  1. Which of the following SELECT statements will return the number of unique values for the title_id column in the sales table?
    1. SELECT COUNT DISTICT title_id FROM sales
    2. SELECT COUNT (DISTICT title_id()) FROM sales
    3. SELECT DISTICT COUNT title_id FROM sales
    4. SELECT DISTICT COUNT (title_id) FROM sales

 

  1. Which of the following statements are true of unique indexes?
    1. A unique index cannot be created on a column with duplicate values.
    2. A unique index is usually better for enforcing primary keys than is using a PRIMARY KEY constraint.
    3. The most often queried column should be placed last in a unique index.
    4. Unique indexes almost always perform better than nonclustered indexes
  1. Which of the following Transact-SQL statements causes the @@ERROR global variable to be set to a value of 51000?
    1. RAISERROR (51000, 16,’error 51000’)
    2. RAISERROR (’error 51000’)
    3. Sp_addmessage 51000, 16, ‘error 51000’

RAISERROR (51000, 16, -1)

    1. Sp_addmessage (51000, 16, ‘error 51000’)

                        RAISERROR (51000, 16, -1)