Thursday, December 8, 2011

MySQL Interview Questions List


How to Delete multiple duplicated rows


How to Self Join in MySQL ?


What is Stored procedures ?


How to write MySQL Database Triggers ?


How to do the table Indexes ?


How to write MySQL Connection ?


What is Select Command in MySQL ?


How to Delete table in MySQL ?


How to truncate table in MySQL ?

Wednesday, December 7, 2011

PHP Interview Questions


What is the use of “Final class” and can a final class be an abstract?


Explain abstract class and its behaviour?


Write a small function to calculate n to the power of n?


Explain drupal flow of information among 5 main layers?


Mention two useful shorcut functions available globally in cake php?


What are the two new error levels introduced in PHP5.3?


WHAT IS Late static binding php5?

Tuesday, December 6, 2011

Asp Interview Questions



What is a "Virtual Directory"?


How to include Active x controls in ASP code?


How long is a SessionID guaranteed to be unique?


What is the Order of precedence for ARITHMETIC Operators. ^, -(negation), *or /, , mod, + or ?


What is Global.asa file?


How to handle Error in ASP


What is the difference between Querystring collection and Form collection?


How can you disable the browser to view the code?



What is the difference between Server.Transfer and response.redirect ? 

Sunday, December 4, 2011

Advise for Face-to-face Interview


How to Prepare for Face-to-face Interview?


Here is the advise when you are going for faced-2-face interview:


1) Be confident  


2) Mental Preparation


3) Dress Code is Important


4) Posture and Carriage


5) Go back to the books


6) No guessing games


7) Be clear 


8) Know your own worth 



9) Get the Information about the organization, its directors, turnover, share capital and other relevant information which are available in its annual report, is expected of candidates by public limited companies. A candidate must know as much as possible about the prospective employer company.




10 Interview Tips for Success


1. Plan to arrive 10 minutes early. This will give you ample time to catch your breath, gather your thoughts and make a quick trip to the washroom to give your appearance one final check. To avoid unnecessary stress, choose your interview attire the night before.

2. Greet the interviewer by his or her last name. If you are unsure of the pronunciation, do ask the employer to repeat it. Or better still, check it with the front desk personnel or receptionist before walking into the interview room.

3. Let the interviewer lead the conversation but try to get him/her to describe the position and duties to you early in the interview. This will allow you to apply your background, skills and achievements to the position.

4. When asked: "Tell me about yourself?", focus your answers on your background and a few professional and personal accomplishments.

5. Stress on your achievements. For example: your sales records, the processes you have developed or systems installed, projects that you initiated, etc.

6. Show enthusiasm. This can be demonstrated through verbal and non-verbal cues (for example, appropriate body language like nodding can be used to support your interest). Enthusiastic feedback can enhance your chances of being further considered.

7. Answer questions by speaking in terms of the position. Emphasise what you can do for the company. Mention specific accomplishments that show your abilities and determination to succeed in this job. Your answers describe the position and duties to you early in the interview. This will allow you to apply your background, skills and achievements to the position. should tell the employer why you would be an asset to the company and not why you need a job.

8. Bring an extra copy of your resume.

9. Explain whenever possible; don't answer with a simple "yes" or "no." 

10. Not but Least, always be confident! this is the main key for success.

How to face an Interview Confidently!


Please always mind 1 equation, if you prepared yourself then you will be always confident to face any kind of Interview. so preparation is key to success of Interviews.

Always be prepared for common questions answers, some of the common interview  questions are as follows: 

* Tell me about yourself. 

* Tell me about your background and accomplishments. 

* What are your strengths? Weaknesses? 

* How would you describe your most recent job performance? 

* What interests you about our company? 

Also, I think you should  ask questions to Interviewer such as: 

* What would I be expected to accomplish in this position? 

* What are the greatest challenges in this position? 

* How do you think I fit the position? 


How to Face Personal Interview

Let's start with the basicsof Personal Interview 


Ware a Professional Dress : Wear clean nicely pressed (ironed) formal clothes with matching shocks and polished shoe and of course belt. You can also wear a Tie but it is not a mandatory. Though most organizations do not have a dress code but when it comes to interview, most of them still prefer a person who is professionally dressed. 


Make up is required ? : - Well what is this, make up for interview, give me a break, are you out of your mind, I am going to appear for interview and not shooting for a movie. 


Relax be calm and cool : I know this, just try to imagine you are the interviewer and you get the option to select one of the two, who are having equally good potentials. 


The only difference is that one is unshaved, with untrimmed and uncombed hair. The other one is nicely shaved with businessmen's haircut and has taken time to comb his hair neatly.

Monday, November 28, 2011

Interview Question Answers Link Exchange


For Link Exchange with my site, Please paste below link on your blog / website 



Description : Free Link Exchange Service for all websites and Link Exchange Partners

URL : http://interviewquestionanswers1.blogspot.com/

It should appear as as the following:

Interview Question Answers Free Link Exchange Service for all websites and Link Exchange Partners

After putting above link on your site, please email me to IndianBrain(at)live.com with your site URL and description or leave your comment with your site details.

===========|| Link Partners ||==========
Link2Me Directory for SEO Link Exchange
Quality directory of webmasters actively seeking link exchange. Improve your search engine rankings and link popularity the easy way. Work clever not hard.