Friday, December 18, 2009

Example for Interface and Abstract class

Example for Interface :
Code:
public interface IVehicle
{
void Start();
void Drive();
void Park();
void ChangeGear(int gear);
void SwitchOff();
}
public class Vehicle : IVehicle
{
public void Start()
{
Console.WriteLine("The vehicle has been started");
}

public void Drive()
{
Console.WriteLine("The vehicle is being driven");
}

public void Park()
{
Console.WriteLine("The vehicle is being parked");
}

public void ChangeGear(int gear)
{
Console.WriteLine("Gear changed to " + gear.ToString());
}

public void SwitchOff()
{
Console.WriteLine("The vehicle has been switched off");
}
}

Example for Abstract class :
Code:
public abstract class Vehicle
{
public void Start()
{
Console.WriteLine("The vehicle has been started");
}

public abstract void Drive();
public abstract void Park();
public abstract void ChangeGear(int gear);

public void SwitchOff()
{
Console.WriteLine("The vehicle has been switched off");
}
}

public class Car : Vehicle
{
public Car()
{
}

public override void Drive()
{
Console.WriteLine("The car is being driven");
}

public override void Park()
{
Console.WriteLine("The car is being parked");
}

public override void ChangeGear(int gear)
{
Console.WriteLine("The car changed gear changed to " + gear.ToString());
}
}

Monday, December 14, 2009

இஞ்சினியர்கள் மேனேஜரிடம் கேட்க விரும்பும் பத்து கேள்விகள்.

இஞ்சினியர்கள் மேனேஜரிடம் கேட்க விரும்பும் பத்து கேள்விகள்.


1. ராத்திரி 10 மணிக்கு கூட எங்களுக்கு பர்சனல் ஒர்க் வரக்கூடாதுனு எதிர்பார்க்கறீங்க... ஆனா சாயந்திரம் 5 மணி ஆனவுடனே உங்களுக்கு மட்டும் எப்படி பர்சனல் ஒர்க் வந்துடுது...?

2. அது எப்படி நாங்க சொல்லி உங்களுக்கு ஏதாவது புரியலைனா Dont make it too complicatedனு சொல்றீங்க... ஆனா நீங்க சொல்லி எங்களுக்கு புரியலைனா He is Dumbனு சொல்றீங்க..?

3. அது எப்படி Week end எங்களுக்கு வேலை கொடுத்துட்டு சனிக்கிழமை நீங்க வீட்டுக்கு கிளம்பும் போது Happy Weekend னு கூச்சப்படாம சொல்லிட்டு போக முடியுது..?

4. அது எப்படி உங்களுக்கு ஒரு அப்ளிகேஷன் சரியா வேலை செய்யலைனா,அப்ளிகேஷன்ல பிரச்சனைனு சொல்றீங்க... அதே எங்களுக்கு வேலை செய்யலைனா, உனக்கு அப்ளிகேஷன் தெரியலைனு சொல்றீங்க..?

5. ஏதாவது நல்ல நாள் வந்தா ஏதோ உங்க வீட்ல மட்டும் விசேஷம் மாதிரி எல்லா வேலையையும் எங்க தலைல கட்றீங்களே. ஏன் எங்க வீட்லயும் விசேஷம் இருக்கும்னு உங்களுக்கு தெரிய மாட்டீங்குது..? நாங்க என்ன டெஸ்ட் ட்யூப் பேபியா...

6.. உங்களுக்கு ஊதிய உயர்வு வரலைனா மட்டும் கம்பெனி ரொம்ப மோசமாகுதுனு சொல்ற நீங்க, எங்களுக்காக மட்டும் பேச மாட்றீங்க...?

7. ஏதாவது ஒரு முக்கியமான மெயில் அனுப்ப நீங்க மறந்தா மட்டும், I was very busy in some other issueனு சொல்றீங்க. அதே நாங்க மறந்தா, you should concentrate on workனு சொல்றீங்க...?

8. ஆபிஸ் நேரத்துல நீங்க ஃபோன் பேசிட்டு இருந்தா மட்டும், அது ஏதோ தலை போற விஷயம் மாதிரி எடுத்துக்கறீங்க, அதே நாங்க பண்ணா வேலையை சரியா செய்ய மாட்றானு சொல்றீங்க...?

9. சாயந்திரம் 5 மணிக்கு நீங்க வீட்டுக்கு போறது தப்பில்லை, ஆனா அப்ப நாங்க ஒரு டீ குடிச்சிட்டு வர போனா மட்டும் ஏதோ கொலை குத்தம் செய்யற மாதிரி பாக்கறீங்க...?

10. காலைல வந்ததுல இருந்து ICICI Direct,gmail ,Geogit, Sharekhanனு செக் பண்ணிட்டு இருக்கீங்க. அதே நாங்க மதியம் சாப்பிட்டு வந்து மெயில் செக் பண்ணா மட்டும் Don't use company resources for your personal workனு சொல்றீங்க...?

ஏன் சார் ஏன்....இத்த தான்...திருக்குறள்ள

யாதெனின் யாதெனின் நீங்கியான் நோதல்
அதனின் அதனின் இலன்...

ஆப்பீசுக்கு போனா ஆணிபுடுங்காம சும்மா இருப்பதே சுகம்னு வள்ளுவர் எப்பவோ எழுதிவச்சுட்டாரு.
இந்த மேஜர்களுக்குத்தான் இது தெரிய மாட்டேங்குது..

நாங்களும் இன்ஜினியரிங் படிச்சிட்டு தான் வந்திருக்கோம்.

Sunday, December 13, 2009

Left Outer join with Having in SQL Server




select p.[ProductName],count(po.ProductID)
from Products as p Left Outer join
Productorder po on p.ProductID=po.productID
GROUP By p.[ProductName],po.ProductID
HAVING (count(po.ProductID) > 0)

Tuesday, December 8, 2009

Personal Interview Questions

"Tell me a little about yourself."

When responding to this request, you should focus on both your personal and professional values. Always be honest, but talk about your best traits only, especially those that relate to the position for which you are applying. Highlight experiences and accomplishments you are most proud of. Here's an example:

"I'm an experienced communications specialist with extensive knowledge of public information tools and techniques. I've developed comprehensive communication plans for major public events, written dozens of articles accepted by worldwide publications, and created specialized educational programs for adults and students. I am always eager to learn new methods and procedures, and have implemented continuous improvement techniques in my past positions that saved money and increased productivity. I like working with people and enjoy group projects, but am also a self-starter who doesn't mind working on my own. I'm a volunteer with the local chapter of Special Olympics and enjoy participating in community events. My goals are to complete my Master's Degree and broaden my experiences with community relations."

Remember to tailor your response to the specific job. By studying the job announcement, you'll get a good idea of the skills and experience being sought. Work those into your response.

Consider this your own personal commercial. If the interview consisted of only this ONE chance to sell yourself, what would you say?

"What do you feel has been your greatest work-related accomplishment?"

Choose one example from your past that was important to you and helped the company you worked for. Give specific details about what you did, how you did it, and what the results were. Try to pick an accomplishment that relates to the position for which you are applying. Employers like to hear about accomplishments that reduced expenses, raised revenues, solved problems or enhanced a company's reputation

"What is your greatest strength?"

This is a great chance to highlight your best skills. Don't pick just one, focus on your top three or four. Some examples are: leadership skills, team-building skills, and organizational skills. Determine which strengths would fit best with the position for which you are applying. For example, if the job announcement stresses the ability to handle multiple tasks, you could say: "I'm good at organizational skills, prioritization and time management. But my greatest strength is my ability to effectively handle multiple projects and deadlines.

"What is your greatest weakness?"

Be careful with this one. Most interview guides will tell you to answer it with a positive trait disguised as a weakness. For example, "I tend to expect others to work as hard as I do," or "I'm a bit of a perfectionist." Interviewers have heard these "canned" answers over and over again. To stand out, be more original and state a true weakness, but then emphasize what you've done to overcome it. For example: "I've had trouble delegating duties to others because I felt I could do things better myself. This has sometimes backfired because I'd end up with more than I could handle and the quality of my work would suffer. But I've taken courses in time management and learned effective delegation techniques, and I feel I've overcome this weakness."

IMPORTANT: Be sure the weakness you talk about is NOT a key element of the position!

"How do you handle stressful situations?"

Give some examples of stressful situations you've dealt with in the past. Tell how you use time management, problem-solving or decision-making skills to reduce stress. For example, tell them that making a "to-do" list helps. Site stress-reducing techniques such as stretching and taking a break. Don't be afaid to admit that you will ask for assistance if you are feeling overwhelmed.

If it's true, say you actually work better under pressure.

"What is the toughest problem you've had to face, and how did you overcome it?"

Try to make this about a problem that faced your company and not just you or your particular work group. The bigger the problem, the better. Give specific examples of the skills and techniques you used to resolve this problem. Emphasize the successful results. Be generous in sharing credit if it was a team effort, but be sure to highlight your specific role.

"Have you ever had to discipline a problem employee? If so, how did you handle it?"

This is a likely question if the position for which you are applying requires supervisory duties. Explain how you used problem-solving skills, listening skills, and coaching skills to help the employee. If those techniques turned the employee around, be sure to say so. If those techniques failed, tell how you followed the company's policies and what the end result was.

"Why do you want this position?"

Here's where your research about the company will help you stand out among the other candidates. Explain how you've always wanted the opportunity to work with a company that... provides a vital public service, leads the industry in innovative products, whatever... find something specific about that company that you can tie in with your answer. Explain how your qualifications and goals complement the company's mission, vision and values (use specific examples). If you are applying for a position in a company for which you already work, explain how you'll be able to apply and expand on the knowledge and experience you've gained from your current position, and will be able to increase your contributions and value to the company through your new responsibilities.

"Why are you the best person for this job?"

As with all other questions, be confident and enthusiastic when you answer this. Don't try to say you are the best qualified person, because you don't know the qualifications of the other applicants. Instead, emphasize several reasons why you should be hired. For example: "I've got extensive experience in [name the appropriate field] and have the specific skills you are looking for. I'm a fast learner who adapts quickly to change and will hit the ground running. I'm dedicated and enthusiastic about helping your company meet its goals, and will provide top-quality results with minimal oversite. I'm an outstanding performer who takes pride in my work. You won't have any regrets when you hire me."

QUESTIONS YOU SHOULD ASK

Often the interviewer's last question is, "Do you have any questions for me?" Candidates who do not have questions show a lack of initiative and give the impression that they have minimal interest in the position. Stand out from those lazy job seekers by asking questions!

Have your questions ready in advance. Relate them to the company or its accomplishments/challenges (your research of the company will show and further impress the interviewer). Don't ask any question that shows that you have not done your research about the company.

Do not ask questions related to you, such as "When will I be eligible for my first raise?" or "How often will I be subjected to a performance review?" Don't bring up money. (You can do that after you are offered the job.)

In addition to specific questions you develop based on what the company does, here are some sample generic questions:

What do you enjoy most about working here?

Be sure the person you ask actually works for the company. Some organizations, especially public agencies, have interview panels in which employees from other agencies participate.

Is there anything I've mentioned that makes you think I'm not the best candidate for this job?

If they do mention something that's bothering them about you, such as lack of specific experience, this gives you a last-ditch effort to change their opinion about you. If you've thought about your possible weaknesses in advance, you should have a prepared answer to those weaknesses. For example, "I know I have limited experience in this field, but what I lack in specific experience I make up for in enthusiasm and desire to excel. I'm a fast learner and I'll work harder than anyone else to be a top producer on your team."

When do you expect to make your final decision?

Be sure to ask that! Failure to do so may give the impression that you're not that interested, and you need to know when to follow up.

ALL THE BEST dONT Worry Be-HaPPY





Monday, December 7, 2009

Readonly vs const

Within a class, const, static and readonly members are special in comparison to the other modifiers.

const vs. readonly

const and readonly perform a similar function on data members, but they have a few important differences.

const

A constant member is defined at compile time and cannot be changed at runtime. Constants are declared as a field, using the const keyword and must be initialized as they are declared. For example;

public class MyClass
{
  public const double PI = 3.14159;
}

PI cannot be changed in the application anywhere else in the code as this will cause a compiler error.

Constants must be of an integral type (sbyte, byte, short, ushort, int, uint, long, ulong, char, float, double, decimal, bool, or string), an enumeration, or a reference to null.

Since classes or structures are initialized at run time with the new keyword, and not at compile time, you can't set a constant to a class or structure.

Constants can be marked as public, private, protected, internal, or protected internal.

Constants are accessed as if they were static fields, although they cannot use the static keyword.

To use a constant outside of the class that it is declared in, you must fully qualify it using the class name.

readonly

A read only member is like a constant in that it represents an unchanging value. The difference is that a readonly member can be initialized at runtime, in a constructor as well being able to be initialized as they are declared. For example:

public class MyClass
{
  public readonly double PI = 3.14159;
}

or

public class MyClass
{
  public readonly double PI;
 
  public MyClass()
  {
    PI = 3.14159;
  }
}

Because a readonly field can be initialized either at the declaration or in a constructor, readonly fields can have different values depending on the constructor used. A readonly field can also be used for runtime constants as in the following example:

public static readonly uint l1 = (uint)DateTime.Now.Ticks;

Notes

  • readonly members are not implicitly static, and therefore the static keyword can be applied to a readonly field explicitly if required.
  • A readonly member can hold a complex object by using the new keyword at initialization.
  • readonly members cannot hold enumerations.

static

Use of the static modifier to declare a static member, means that the member is no longer tied to a specific object. This means that the member can be accessed without creating an instance of the class. Only one copy of static fields and events exists, and static methods and properties can only access static fields and static events. For example:

public class Car
{
  public static int NumberOfWheels = 4;
}

The static modifier can be used with classes, fields, methods, properties, operators, events and constructors, but cannot be used with indexers, destructors, or types other than classes.

static members are initialized before the static member is accessed for the first time, and before the static constructor, if any is called. To access a static class member, use the name of the class instead of a variable name to specify the location of the member. For example:

int i = Car.NumberOfWheels;

Thursday, December 3, 2009

General Interview Question

Project interview questions

1. Project skills interview questions

• Tell us about a successful project in which you participated and how you contributed to the success of that project.

• You are given the assignment of project manager and the team members have already been identified. To increase the effectiveness of your project team, what steps will you take?

• Do you understand milestones, interdependencies? Resource allocation?

• Do you know what Project Software the new company uses and is there training for it?

• What is EVM? how will you use it in managing projects?

• What is a project? and what is program?

• What are project selection methods?

• When you are assigned a project, what steps do you take to complete the project?

• As you begin your assignment as a project manager, you quickly realize that the corporate sponsor for the project no longer supports the project. What will you do?

• Your three month project is about to exceed the projected budget after the first month. What steps will you take to address the potential cost overrun?

• Companies have historically looked at technical skills, but more and more business managers are realizing that not have “people” skills tend to cripple projects.

• How many projects you handled in the past? Deadlines met? On time/ within budget? Obstacles you had to overcome?

• Which document will you refer for future decisions?

• How will you define scope?

• Do you inspect or plan for quality ?

• What is the output of scope definition process?

• What is quality management?

• What did you like about the project and dislike about the project?

• What did you learn from the project?

• What are two common but major obstacles for a project like this? What would you do in the face of these obstacles to keep your team on schedule?

• What is project charter? What are the elements in a project charter?

• What experience have you had in project management?

• Name five signs that indicate your project may fail.

• Tell us about a project in which you participated and your role in that project.

• Describe what you did in a difficult project environment to get the job done on time and on budget.

• What actions are required for successful executive sponsorship of a project?

• How did you get your last project?

• What were your specific responsibilities?

• In this field (the field you are interviewing for), what are three critically important things you must do well as a project manager in order for the project to succeed?

• What metrics would you expect to use to determine the on-going success of your project?

• What distinguishes a project from routine operations?

• What are the three constraints on a project?

• What are the five control components of a project?

• What qualifications are required to be an effective project manager?

• Your project is beginning to exceed budget and to fall behind schedule due to almost daily user change orders and increasing conflicts in user requirements. How will you address the user issues?

• You’ve encountered a delay on an early phase of your project. What actions can you take to counter the delay? Which actions will have the most effect on the result?

• What are the necessary steps to successful project management?

• How do you plan for a project?

• What is important to consider when planning a (your type of project)?

• What are things that you have found to be low priority when planning for (your type of project)?
• You have been assigned as the project manager for a team comprised of new employees just out of college and “entry-level” consulting staff. What steps can you take to insure that the project is completed against a very tight time deadline?

• What is a “project milestone”?

• What is “project float”?

• What methods have you used for estimation?

• How would you start a project?

• If you were to deliver a project to a customer, and timely delivery depended upon a sub-supplier, how would you manage the supplier? What contractual agreements would you put in place?

• Which tool would you use to define, manage and control projects?

• What is risk management and how will you plan risk response?

• What are outputs of project closure?

• What are the methods used for project estimation?

2. Leadership interview questions

• Tell me how you would react to a situation where there was more than one way to accomplish the same task, and there were very strong feelings by others on each position.

• Consider that you are in a diverse environment, out of your comfort zone. How would you rate your situational leadership style?

• Give me an example of your leadership involvement where teamwork played an important role.

• How do you handle non-productive team members?

• How do you motivate team members who are burned out, or bored?

• How do you handle team members who come to you with their personal problems?

• What are your career goals? How do you see this job affecting your goals?

• Explain how you operate interdepartmentally.

3. Judgment interview questions

• What would you do if you found out that a contractor was in a conflict of interest situation?

• If I were to contact your former employee, what would he say about your decision-making abilities?

• Give me an example of a win-win situation you have negotiated.
• Tell me about your verbal and written communication ability. How well do you represent yourself to others? What makes you think so?

• Give me an example of a stressful situation you have been in. How well did you handle it? If you had to do it over again, would you do it differently? How do you deal with stress, pressure, and unreasonable demands?

• Tell me about a tough decision you had to make?

4. Experience interview questions

• Describe what you did at your work place yesterday.

• How would you solve the following technical problem? (Describe a typical scenario that could occur in the new position.)

• What strengths did you bring to your last position?

• Describe how those contributions impacted results?

5. Competency interview questions

• Tell me about special projects or training you have had that would be relevant to this job.

• What are some things that you would not like your job to include?

• What are your current work plans? Why are you thinking about leaving your present job?

• Describe an ideal job for you.

• Why are you interested in this position?

• Describe what you think it would be like to do this job every day.

• What do you believe qualifies you for this position?

Project interview questions can be used for project management interview questions, project manager interview questions

Tuesday, December 1, 2009

Five Tips To Remove Stomach Fat You Can Use Today

5 Tips To Remove Stomach Fat You Can Use Today

Getting rid of belly fat isn't something that you can do overnight, but there are methods that you can put in place today that will greatly reduce the appearance of your stomach fat and get you started on the road to a healthy body. The trick is patience. Getting in shape takes time and it is important to tone your whole body. If you just focus on your stomach, your stomach fat will simply reappear somewhere else on your body. That said, here are 5 tips to remove stomach fat you can use today:

1. Start an abdominal workout routine immediately. It is important to exercise your whole body but there is no rule that says you can't focus on one part of your body more than others. Instead of simply lounging in the evening, do crunches or squats while you watch television or listen to music. You don't have to do hundreds of them either to see results.

2. Talk with your doctor about drastically cutting your calorie intake for a few days. By cutting your calorie intake your body will start to burn its fat stores in an attempt to keep your body functioning at its usual energy level. It is imperative, however, that you start to increase your calorie intake over time. Remember, the goal is to be healthy!

3. Cut all of the processed foods out of your diet. Instead of choosing snacks from the snack aisle, stock up on fresh fruits and vegetables to snack on when you are between meals. At mealtimes opt for as many raw foods as you can as raw foods are far healthier than cooked foods.

4. Start sitting up straight. Proper posture, especially when you aren't used to it, can reduce the appearance of stomach fat (slouching can double the amount of flab that falls over your waistline). What's more, it takes energy to hold yourself upright all day long--energy that burns calories! It's a low burning energy, but it burns calories nonetheless!

5. Drink enough water! Instead of quenching your thirst with juice, soda, coffee or teas--opt for water. Water is essential to keeping your body healthy and your organs functioning properly. Water will help you sweat out your toxins instead of storing them as fat. What's more, water has zero calories so by cutting out the other beverages and replacing them with water, you'll be cutting your calorie intake by hundreds of calories a day!

These are just five tips that you can use to remove stomach fat today. By doing some research and talking to your doctor you will easily be able to come up with even more ways to get your body in shape, be healthy and reduce your "flab." Make sure you run any decisions about your body by your primary care physician. Together the two of you can put together a complete plan to keep the body fat at bay.