Sql server interview questions shivprasad koirala pdf

Date published 
  1. .NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala
  3. Shivprasad Koirala's Interviews Questions
  4. SQL Server interview questions

Download as PDF, TXT or read online from Scribd Ask for interview question books only by Shivprasad Koirala from BPB publications. NET Interview questions -- SQL Server Interview questions -- Java Interview questions -- C# and ASP. Shivprasad koirala s sql server: interview questions presents a solution for those programmers who want to get a job in software industry. It is a known fact that a. SQL Server Interview sourphocingcardmi.gq sourphocingcardmi.gq and c# interview questions and Training visit sourphocingcardmi.gq

Language:English, Spanish, French
Published (Last):20.08.2016
Distribution:Free* [*Sign up for free]
Uploaded by: YUNG

57159 downloads 159498 Views 34.49MB PDF Size Report

Sql Server Interview Questions Shivprasad Koirala Pdf

PDF's, how about a self owned hard copy. If you want to Some other books by Shivprasad Koirala. C# and sourphocingcardmi.gq projects. SQL Server Interview Questions. PDF's, how about a self owned hard copy. If you want to sourphocingcardmi.gq uk/NET-Interview-Questions-Shivprasad- SQL Server Interview Questions. An article listing SQL Server Interview Questions. Shivprasad koirala, 10 Jan (DB) What is SQL Server Workload Governor?.

Note: Just to clarify what is client server and file server I will make a quick description of widely accepted architectures. In Main Frame architecture, all the processing happens on central host server. User interacts through a dumb terminal that only sends keystrokes and information to the host. All the main processing happens on the central host server. So the advantage in such type of architecture is that you need least configuration clients. But the disadvantage is that you need a robust central host server like Main Frames.

Pure DBAs have normally around 6 and above years of experience in that particular database product. That means one or two guys work fulfilling maintenance tickets. So now judge where you stand where you want to go Resume Preparation Guidelines First impression the last impression Before even the interviewer meets you he will first meet your resume. I was always a bad guy when it comes to resume preparation. But when I looked at my friends resume they where gorgeous.

Now that I am writing series of book on interviews I thought this will be a good point to put in. You can happily skip it if you are confident about your resume. There is no hard and fast rule that you have to follow the same pattern but just see if these all check list are attended. Use plain text when you are sending resumes through email.

For instance you sent your resume using Microsoft word and what if the interviewer is using Linux he will never be able to read your resume.

You can not be sure both wise , you sent your resume in Word and the guy has Word 97uuhhh. Attach a covering letter it really impresses and makes you look traditionally formal. Yes even if you are sending your CV through email send a covering letter. Start with an objective or summary, for instance, Working as a Senior Database administrator for more than 4 years.

Implemented quality web based application. Followed the industrys best practices and adhered and implemented processes, which enhanced the quality of technical delivery. Pledged to deliver the best technical solutions to the industry. Specify your Core strengths at the start of the resume by which the interviewer can make a quick decision are you eligible for the position.

For example : Looked after data mining and data warehousing department independently. Played a major role in query optimization. Worked extensively in database design and ER diagram implementation.

Well versed with CMMI process and followed it extensively in projects. This is also a good position to specify your objective or position which makes it clear to the interviewer that should he call you for an interview. For instance if you are looking for senior position specify it explicitly looking for this job profile.

Once you have specified briefly your goals and what you have done its time to specify what type of technology you have worked with. This will give an overview to the interviewer what type of companies you have associated your self. Now its time to mention all your projects you have worked till now. Best is to start in descending order that is from your current project and go backwards.

Number of team members. Time span of the project. Brief summary of the project. Senior people who have huge experience will tend to increase there CV with putting in summary for all project. Best for them is to just put description of the first three projects in descending manner and rest they can say verbally during interview.

I have seen CV above 15 pages I doubt who can read it. Finally comes your education and personal details. Trying for onsite, do not forget to mention your passport number. Some guys tend to make there CV large and huge. I think an optimal size should be not more than 4 to 5 pages. You can talk about it during interview with HR or the interviewer.

When you are writing your summary for project make it effective by using verbs like managed a team of 5 members, architected the project from start to finish etc. It brings huge weight. This is essential very essential take 4 to 5 Xerox copies of your resume you will need it now and then. Just in case take at least 2 passport photos with you. You can escape it but many times you will need it.

Carry youre all current office documents specially your salary slips and joining letter. Salary Negotiation Ok thats what we all do it for money not every one right. This is probably the weakest area for techno savvy guys. They are not good negotiators. So here are some points: Do a study of whats the salary trend?

For instance have some kind of baseline. For example whats the salary trend on number of year of experience? Discuss this with your friends out. Do not mention your expected salary on the resume? Let the employer first make the salary offer. Try to delay the salary discussion till the end. If they say what you expect?

Remember never say negotiable on something which you have aimed, HR guys will always bring it down. The normal trend is that they look at your current salary and add a little it so that they can pull you in. Do your home work my salary is this much and I expect this much so whatever it is now I will not come below this. Do not be harsh during salary negotiations. Its good to aim high. Many of the companies add extra performance compensation in your basic which can be surprising at times.

So have a detail break down. Best is to discuss on hand salary rather than NET. Talk with the employer in what frequency does the hike happen.

Take everything in writing , go back to your house and have a look once with a cool head is the offer worth it of what your current employer is giving. Do not forget once you have job in hand you can come back to your current employer for negotiation so keep that thing in mind. Remember the worst part is cribbing after joining the company that your colleague is getting this much.

So be careful while interview negotiations or be sportive to be a good negotiator in the next interview. One very important thing the best negotiation ground is not the new company where you are going but the old company which you are leaving. So once you have offer on hand get back to your old employee and show them the offer and then make your next move.

Its my experience that negotiating with the old employer is easy than with the new one. Frankly if approached properly rarely any one will say no. Just do not be aggressive or egoistic that you have an offer on hand.

.NET interview questions 6th edition (Sixth edition) - By Shivprasad Koirala

I think its worth more than money. Points to remember One of the first questions asked during interview is Can you say something about yourself? Can you describe about your self and what you have achieved till now? Why you want to leave the current company? Where do you see yourself after three years? What are your positive and negative points? How much do you rate yourself in. Be careful do not show your desperation of abroad journeys Why have you changed so many jobs?

Prepare a decent answer do not blame companies and individuals for your frequent change. Never talk for more than 1 minute straight during interview. Have you worked with previous version of SQL Server? Would you be interested in a full time Database administrator job? Do not mention client names in resume.

If asked say that its confidential which brings ahead qualities like honesty When you make your resume keep your recent projects at the top. Find out what the employer is looking for by asking him questions at the start of interview and best is before going to interview. Can you give brief about your family background?

As you are fresher do you think you can really do this job?

Have you heard about our company? Say five points about our company?


Just read at least once what company you are going for? Can you describe your best project you have worked with? Do you work on Saturday and Sunday? Which is the biggest team size you have worked with?

Shivprasad Koirala's Interviews Questions

Can you describe your current project you have worked with? How much time will you need to join our organization? Whats notice period for your current company? What certifications have you cleared? Do you have pass port size photos, last year mark sheet, previous companies employment letter, last months salary slip, pass port and other necessary documents.

Whats the most important thing that motivates you? Why you want to leave the previous organization?

SQL Server interview questions

What is the type of environment you are looking for? Do you have experience in project management?

Do you like to work as a team or as individual? Describe your best project manager you have worked with? Why should I hire you? Have you been ever fired or forced to resign? Can you explain some important points that you have learnt from your past project experiences? Have you gone through some unsuccessful projects, if yes can you explain why did the project fail? Will you be comfortable with location shift? If you have personal problems say no right at the first stage Do you work during late nights?

Best answer if there is project deadline yes.

Do not show that its your culture to work during nights. Any special achievements in your life till now Any plans of opening your own software company Beware do not start pouring your bill gates dream to him Twist: - Whats the difference between file and database? Can files qualify as a database? But from freshers point of view it can be a difference between getting a job and to be jobless. Database provides a systematic and organized way of storing, managing and retrieving from collection of logically related information.

Secondly the information has to be persistent, that means even after the application is closed the information should be persisted. Finally it should provide an independent way of accessing data and should not be dependent on the application to access the information.

Ok let me spend a few sentence more on explaining the third aspect. Below is a simple figure of a text file which has personal detail information. The first column of the information is Name, Second address and finally the phone number. This is a simple text file which was designed by a programmer for a specific application.

Figure 1. Now some years down the line a third party application has to be integrated with this file , so in order the third party application integrates properly it has the following options : Use interface of the original application. Understand the complete detail of how the text file is organized, example the first column is Name, then address and finally phone number.

After analyzing write a code which can read the file, parse it etc. Hmm lot of work right. Thats what the main difference between a simple file and database; database has independent way SQL of accessing information while simple files do not That answers my twisted question defined above.

File meets the storing, managing and retrieving part of a database but not the independent way of accessing data. Note: - Many experienced programmers think that the main difference is that file can not provide multi-user capabilities which a DBMS provides. But if you look at some old COBOL and C programs where file where the only means of storing data, you can see functionalities like locking, multi-user etc provided very efficiently. So its a matter of debate if some interviewers think this as a main difference between files and database accept it going in to debate is probably loosing a job.

This time I have added some more important questions around serialization, new. NET 4. Also I have updated some answers with more precision. OOP This chapter I have really reworked it. I admit my previous editions did not have answers up to mark. So I have made some big changes in this chapter. As well I have added some more situation based questions around abstract classes and interfaces. A complete chapter I have dedicated to ADO.

This time I have really made the images clean, nice and sharp. Also I have reworked on the answers to make it to the point. This chapter I have not altered too much in this edition as new kid in the block, MVC has arrived. But I have still reworked on some answers and diagrams which where confusing in the previous edition.

This is a major thing in sixth edition , a complete new chapter dedicated to MVC. I have added around 30 situational based questions in this chapter to do full justice for this chapter.

This is one chapter I always thought I should work one. But for now I have kept the same questions and updated some answers which were not looking proper.

Added some questions around WCF 4. Updated lot of questions around WPF. Not much changed in this and chapter as such but added some few more architectures and patterns like MVVM and repository pattern.