Top 100 C#/ .NET/ Web API/ SQL Interview Questions

[@daneshkumarsathyanarayanan4111]

This is really one of the best video for interview preparation, which covers all the aspects which is expected a .NET Technical Interview.. Hats off to the efforts for explaining the concepts more crisp and clear. Please continue your journey in creating such valuable videos.

[@interviewhappy]

Thanks Danesh. Never got such appreciation even from my managers in past :). Deeply elated by it.

[@shrikantpandey9738]

Bruh hats off it’s a developer Power Nap superbbbbbbbbbb❤

[@RahulKumar-si1fz]

Please create java interview questions series

[@kotireddychilakala]

Is it use for 2 years of experience?

[@SoftwareDeveloperAspNet]

​@@interviewhappyhi want to connect to you.

[@interviewhappy]

This channel mission is to help developers in getting BETTER JOBS. If my content helped you in achieving this, then do COMMENT on the video. This will MOTIVATE me to help others.

[@hhhhhchan]

Hi Happy. Spent a week to watch all your video for .NET interview. I got 2 offers in 2 interviews, a 100% successful rate. Thanks a lot for your help. Recommend for all the developers.

[@itsmylife2158]

Hii....can you do suggest me any other videos have you watched and please share your interview experience aswell....

[@bhagyashreenawale3578]

Hey having experience or as fresher it helped you

[@Shalaby2002]

@@bhagyashreenawale3578 i'm a fresh grad and YEAH it helps & got an offer!

[@UttamLove]

29:00 - By Default access modifier of Class is 'Internal'. & 'Private' for Data Member n Member Function of Class. Internal is the default if no access modifier is specified.

[@akashdeepsharma1148]

Yes correct

[@gravitydrummer]

I almost wrote a comment about this, but you were quicker :) actually 10 months quicker

[@shubhamtaluja9770]

Thank you so much Sir for the valuable Interview questions. After struggling for 5 months, I finally secured a job. There were no questions which were asked that I felt was out of your video. To the point, crisp, and valuable. I recommend to everyone just make this guy popular because he's working so hard for us. Blessed.

[@dipalinikam5847]

really your work is amazing

[@interviewhappy]

There is one questions in video - What is the default access specifier of a class? The correct answer is internal.

[@rkfactsstories]

Means if we don't declare any access specifier then it is the default internal 🤔

[@techfullstack8777]

At 29:02 okay

[@souleimane8428]

Exactly

[@Shubham-ic2rl]

How you made this mistake

[@rkfactsstories]

@@Shubham-ic2rl everyone do mistakes ✍️

[@srivanipatibanda]

Thank you for answering ‘ why to use’ rather than just the concept. Helpful course . I also bought 500 questions that was also useful!

[@amanik2196]

I got the Job, i am only prepared this question s only..... Thank u Very Much Excellent Video....❤️

[@interviewhappy]

Congrats Amani... That's what my main purpose is. All the best for your career.

[@amanik2196]

@@interviewhappy Thank you Very Much But now i want Angular and React js please Suggest On that also....🥰

[@MamathaCh-gh6xu]

@@amanik2196 I’m also preparing for job. Can you tell what other videos you followed for cracking interviews? This video is only for C#. Can you suggest other videos for other technologies like sql, api etc

[@reshmaofficial9994]

Really true

[@MamathaCh-gh6xu]

@@reshmaofficial9994 hey reshma you got the job?

[@souleimane8428]

A very complete .Net interview preparation I have ever watch on KZbin. Thanks so much.

[@interviewhappy]

Thanks Me Myself. Hope you will achieve what you are desiring.

[@kimicheng5611]

Super Super helpful. Selected questions are popular in the interviews and your answers are concise, on point and ez to understand. Thank you so much.

[@interviewhappy]

Thanks Kimi. Loved your comment and wish you all the best for your interviews.

[@Funwithchhote]

Thanks Sir for sharing these type of interview questions, last saturday i attended a interview in Cognizant and they asked Almost all the questions which are available in this video, even I refered your SQL interview questions, there also I got multiple question, like Triggers, Index, Difference between SP, Function and many more. 😊😊😊🙏🙏

[@interviewhappy]

Great Dheeraj, I am glad to hear that it is helping candidates. Might be interviewers are also watching this video for asking questions 😃

[@Funwithchhote]

@@interviewhappy Yes Sir. 😊😊😀Seems they are also referring your videos 😀.

[@dingdingding8697]

you applied as a fresher or experienced??

[@FunAndCreativeCorner]

Excellent video. I can see the hard work. The way document is prepared and each topic is explained. Kudos to you sir.

[@goutamiponnada7580]

Thank you Happy sir! I have purchased 500 questions from Udemy on 8th April and gone thru the video for 1 time and 2 times pdf and 12th was interview and job confirmed on 13th. This videos is more than enough for anyone. I am joining after 4yrs career break. You made me happy. I explained Solid principles with examples for 2mins. You made everyone Happy. I also purchased Angular videos just before interview but couldn’t complete it. Thank you so much. Great efforts. 👍

[@Harish-kb3ul]

Hi

[@srishti1203]

Great content sir, very helpful for interviews. Just one correction, "internal" is default access modifier for class and "private" is default access modifier for class members.

[@ankityadav-lw4rf]

ya you are correct i also here for comment same mistake

[@dr.jalpeshsolanki7198]

I m very impressed with this video. Used very easy language with simple diagram. Good explanation. Keep it up with new videos

[@interviewhappy]

Thanks Jalpesh. Appreciate you liked it.

[@VaasirVibes]

Please post 500 interview questions and answers in .Net. Your explanation is too good

[@leetcodewithalishasharma]

Wow. This is a great material for the .NET interview prep. Appreciate your efforts for explaining each and every concepts in a short and concise way.

[@interviewhappy]

Glad it was helpful! @leetcodewithalishasharma

[@ashokfunbee]

In SQL, add few more as below I faced. 1.pivot table 2.dens rank 3.how to schedule a job in sql server 4.database optimize techniques 5.how to insert 1 lacks records. What are the scenario's you will follow. Can you please make video on these questions.. Thanks in advance

[@ZebaZamir]

Which company they asked

[@NikhilD87]

Nice explanation.. Can you share all 500 questions which in description below. So everyone benefits. Thanks again

[@colorfullworld13]

It's Really Helpful for me to Creak the interview with Wipro , TCS , Cognizant and Capgemini

[@interviewhappy]

Thanks Pooja. I want to help all interview takers so that they can answer questions confidently.

[@bhagyashree7321]

What are the questions asked in Capgemini?

[@damon-yi2mi]

annot put into words the amount of appreciation i hold for this videos' teacher ...god really bless u sir ..just once suggestion sir ..nowadays ppl are asking implement based questions more like how did u consume web api even for 2 yrs exp.kindly make a video like that too sir

[@thatsaquib]

The never give up advice is too OP. Almost 15 interviews and still didn't land a job, was almost on the verge of quitting but this video was of great help and the small advice in the end was a booster. Thankyou

[@interviewhappy]

Keep going... And when you reach your destination, you will feel proud of your never-give-up attitude and all the struggles you overcame. All these rejections will be very small for you then.

[@vasiliskarvelas5488]

All good with Interview questions, but a lot of times day to day practical programming is very different from "best practices". 3 things so far: 1. in Interfaces you can declare methods, properties, events, and indexers not only methods. 2. You cannot have abstract keyword in an Interface. I get it its a copy paste thing but.... 3. Public keyword in an Interface "is not aloud/is redundant" everything in an Interface is public. To be clear, is a very helpful video Overall :D

[@interviewhappy]

Thanks Vasilis for bringing this things up. I will include them in the next version of this.

[@hafizmuhammadrizwan9841]

Mashaa Allah Excellent effort Unique video

[@vinaychauhan5486]

I really happy and appreciate you 💞 I cracked 6 interview out of 10 in Dot net technology.. it's because of you Sir ❤ ..thank u so much sir ..🎉

[@interviewhappy]

Wow congratulations.. Thanks for sharing and appreciating my work . All the very best my friend . @vinaychauhan5486

[@pandidurai098]

Sir, salute. Your videos are simply superb and yesterday purchased it. When I read ur tutorial I'm getting hope i will clear the interview. Thanks!!!

[@interviewhappy]

Thanks Pandi, yes sure. Cover important concepts first and try practice if time allows. All the best for your career and interviews.

[@pandidurai098]

@@interviewhappy thank u sir!

[@anurahan2627]

Excellent... Its really helpful and iam searching to learn this important contents but i did'nt get any full package like this... But when i watch this video... my mind was fullfilled with the lots of hope and really satisfied by this. Thank you so much Sir

[@interviewhappy]

Thanks Anooja, glad you liked it. I wish you all the best for your career.

[@mahindatennakoon7968]

"internal" is the default access modifier of the class not the "private" (go to time line 29:05)

[@yashvakharia7045]

Agree with you

[@AnkitPrajapatiOfficial]

Yes

[@junaidkhanvibes-jkv7214]

Thank you so much Happy Bhai, finally I got a job offer from a company in Pakistan, I really recommend everyone to watch your videos before giving an interview. I have learned a lot of things from your videos.

[@interviewhappy]

Best of luck

[@junaidkhanvibes-jkv7214]

@@interviewhappy ♥️

[@himanshugoel3948]

[29:06] Default modifier for a class is Internal, NOT private

[@kidsstorywithfun4090]

All interview question and answer covering in this video. This video is help for us which is do preparation for interview. Thank you so much sir🙏. Only one problem here we can not seen proper example in mobile screen.

[@interviewhappy]

Yes, examples might not be properly visible in mobile screens. I will take of this from next time.

[@kidsstorywithfun4090]

@@interviewhappy In Laptop Screen, All are properly visible.

[@sandhyabhovi477]

This is one of the best interview preparation video. Thank you so much for making this video

[@interviewhappy]

wc Sandhya and all the best for your career.

[@poojatundalwar2706]

Thanks for making an amazing video.. It has covered all the questions..with Best Example.. Great work..✨👍🏻

[@interviewhappy]

Thanks Pooja.. I wish you all the best for your interview preparation.

[@nishanthmohan]

At 2:05:50, its NOT Content-Type header, its Accept header. Accept header is used by HTTP clients to tell the server which type of content they expect/prefer as response.

[@vishnumaya1930]

Thanks a lot sir. Am preparing for interview it is very helpfull.You are explaining very clearly and GREAT

[@interviewhappy]

wc Vishnu. I wish you all the best for your interviews.

[@vishnumaya1930]

@@interviewhappy Thankyou Sir

[@smitagupta4196]

Thank you for this video.. It's very helpful for me..and ur way to describe is very good..🙏

[@interviewhappy]

Thanks and all the best.

[@keerthanabalaji4955]

Thank you so much. This is what i need. Amazing collection of questions with great explanation.thanks again😊

[@interviewhappy]

wc Balaji

[@alokraj6212]

Sir, In Question 15 (29:00 minutes), Internal is the default access modifier of a class as classes can have only Internal and Public access modifier.

[@SHIVASHANKERBATTU]

One of the best video i have seen explained each answer very clearly, thank you so much for your hard work ❤❤❤

[@interviewhappy]

Thanks Shiva. All the best for your career.

[@anushthababerwal5904]

Hello sir, firstly thank you for all videos !! Please provide some interview questions on Xunit testing, how to explain logging and how to implement caching, Also commonly asked SQL & LINQ queries, some basic frequently asked C# codes like reverse a string and Fibonacci and more . Thank you again !

[@nikhillimbachiya7094]

very very good sir... 100% useful for the interview... thank you sir

[@interviewhappy]

Most welcome Nikhil

[@ravikirankethe]

In the Interface & Abstract, you have mentioned an abstract method in interface at 18:18, can we really have an abstract method in interface. I thought all the methods declared in an interface are by default abstract methods and we shouldn’t be using abstract keyword.

[@techielovekid6121]

28:59 Default access modifier for class is "internal" not "private"

[@SatinderSingh-cp6hn]

Very nice collection of interview question and very well explained. Thanks for creating this video. Keep doing the good work.

[@interviewhappy]

Thanks Satinder

[@radhikavegesna2702]

your content is really good..helped me in cracking job with MNC.keep doing such videos which are really helpfull for all..Thank you

[@ManishKumar-wn2gn]

Sir Jee... All in One bana diya Aap neee.... Thanks

[@khalidtnwr]

Effort was gr8 , only concern is Audio issue...

[@neelayshivsharan2018]

Hi Happy Interview, Thank you for this video; it is very helpful for our interview preparation. It covers all the important questions, each of which is commonly asked in many interviews. With the help of this video, I was able to brush up on my basic knowledge very easily and quickly. If possible, could we have a video on interview questions for product-based companies?

[@tksvel1]

You are really a genius. It is a great guide for the job seekers.

[@foodieinsaan7]

📌Correction Access Specifier :- Default Access specifier for Class is Internal , For data members and method the default access specifier is Private

[@interviewhappy]

you are right

[@yaslinbasakgreecy5547]

Thank you soooooo muchhhh for informative questions and answer you taught smoothly nice and got understanding all things easily please make more videos for helping ppl ...thanks alot dear sir

[@interviewhappy]

Thanks for your words Yaslin. I will keep posting things which help candidates in clearing interviews.

[@poojatundalwar2706]

Thanks a lot .. It has covered all my doubts.. Every time when there is Interview I only watch this video.. Best contain for Dot Net Developer Interview.. Thank you so much..😊✨

[@interviewhappy]

It's my pleasure

[@jeyanthip6511]

I prepared these questions for my interview and I did very well. Fingures crossed for the results. Thank you so much.

[@interviewhappy]

Good luck!

[@Priyanka-cy3zw]

Please make a video on scenario-based questions like if load time is more what to do like that. Thank you for great explanations.

[@KritikaYadav-t5k]

I recently prepared for my interview watching your videos. I want to thank you for your insightful content. I got the job.

[@interviewhappy]

Wonderful!

[@aditijain70]

Great Explanation! I gave an interview just a few days back and all the questions were explained here except for one or two. Thank you!

[@interviewhappy]

Thanks Aditi, keep giving interviews and I wish you all the very best. You will get your dream job.

[@karthiksrivatsa8243]

13:25 now interface can have method definition. That classic answer for diff b/w interface and abstract class is no more valid.

[@interviewhappy]

Good catch. Theoretically right, but I have never created any interface with body and I afraid how interface will be different then. They should be obsolete.

[@karthiksrivatsa8243]

@@interviewhappy Right, this is antipattern. Even I haven't used it anytime.

[@VikramN-t7n]

Q 3 about Inheritance: The interface should use keyword of Interface (and not Class), right?

[@himanshujain115]

Sir bhut hi accha explains kiya hai aapka.please Asp.net mvc and core series also

[@interviewhappy]

Thanks Himanshu

[@VinodReddyBaddam]

Thanks for the Video🙏 This is one to Many video. 1 video many concepts. You’ve covered most of the real-time interview questions among all Dot net technologies. The way you explained with different examples and the visuals are very good and easily understandable. Will will get 80% of the questions from this Video. “Strongly suggesting, go through this video before Interview, you will lot of Confidence”

[@interviewhappy]

wc Vinod. Thanks for recommending it. My best wishes are with you for your career and interviews.

[@manishamakade776]

Awesome video to quick help for interview preparation at last moment

[@interviewhappy]

Thanks Manisha, glad you liked it

[@rameshshukla7966]

I love your all video and prepare well and clear all .net interview ,This is really one of the best video for interview preparation, which covers all the aspects which is expected a .NET Technical Interview.. Hats off to the efforts for explaining the concepts more crisp and clear. Please continue your journey in creating such valuable videos.

[@interviewhappy]

You are most welcome

[@rohitrajofficial06]

very useful video but Internal is the default if no access modifier is specified. (Time Span:-29:05)

[@sushilbhat9431]

Default accessspecifire for the class is internal not private

[@cbrschool]

Thanks for the video. Any pointers to learn and master design patterns ? Thanks

[@interviewhappy]

Thanks and all the best for your career.

[@suriyaparvendhan8166]

Best study content I have ever seen.Thanks much..

[@interviewhappy]

Welcome Suriya! And this is one of the best comments I have seen. Many Thanks for this. And best of luck for your interviews.

[@waqasmumtaz6109]

You are happy and makes other happy as well from ur knowledge and efforts. when we preapre from your vedio and crack interview and got raised in salery we become also happy hehhe

[@D3K018]

This is so wonderful! Thank you so much for this effort, this is probably the most complete video guide for C# I've ever seen, extremely helpful and well explained!

[@interviewhappy]

Thank you Benderman .

[@user-qh7er8fp2o]

Good attempt..... Thank you.....You spread your knowledge............... thanks alot......

[@interviewhappy]

Thanks Mr. A

[@user-qh7er8fp2o]

@@interviewhappy i am not Mr....... i am Mrs.....

[@interviewhappy]

@@user-qh7er8fp2o Oh my bad.. Sorry

[@shreyatam2999]

So helpful thank you so much .. can you also create one video for programing coding interview question asked in c# .net interview

[@interviewhappy]

wc Shreya, coding questions are common but I will try to include them... wish you all the best.

[@akankshagupta3980]

It's really really very helpful ..... ThankQ soo muchh sir for this wonderful video

[@interviewhappy]

Thanks Akanksha... I wish you all the best if you are preparing for videos.

[@Manithan123]

Extremely useful video. Thanks for uploading it!

[@interviewhappy]

Thanks Nadarajan. Wish you all the best for your career.

[@Shubham-ic2rl]

This is the best video of youtube

[@interviewhappy]

Thanks a lot Shubham

[@ravindrashingole926]

Exllent video sir

[@komalichamarthi1120]

Thank you so much for sharing this video . This is one of the best interview prep video. Can I please ask you to explain SSO ?

[@interviewhappy]

Welcome and Thanks Komali. Wish you all the best for your career. SSO is Single Sign On like you login in gmail in google, then you need not to login in other google apps - youtube/ drive etc... that is SSO. In .NET it is related to authentication and access tokens. I will soon try to make an video on it.

[@manimegalaig2916]

Very nice video with crystal clear explanation..I am preparing this video questions only..Hope I will get selected.

[@meghamodi2854]

Its really useful video for interview. Thanks for making this. Requesting you kindly make for design patterns also..

[@interviewhappy]

As soon as possible @meghamodi2852

[@pradeepkp4982]

Really thank you.. I also got offer referring this video😊

[@bhartichaudhary5638]

I have been searching for this kind of explained video from long..it is truly very very helpful video as it covers all the important questions that is being asked actually...thanks a lot sir for making this video.. I m going to save it for me for my upcoming interviews.. btw it not only covers the interview qsn but also it clearing some of my concepts.. thanks a lot for making such video.. also request u to make a video on dot net core.

[@interviewhappy]

Thanks Bharti for your words. These kind of words motivate us to create more and more valuable content. I am glad you liked it. I wish you all the best for your career.

[@007ankitshrivastava]

Nice explanation.. Can you share all 500 questions which in description below. So everyone benefits. Thanks again

[@sarwarbly]

Really Helping video...It's Wonderful ...Thank You Sir

[@interviewhappy]

Welcome Sarwar. Appreciate your desire for learning.

[@ponraam]

How we can connect from c# to database? can you please provide possible answers for this questions it is asked in many interviews

[@interviewhappy]

Hi Ponram, 3 approaches - use ado.net or entity framework or linq to sql are used to connect C# to database. You can explain any one of them.

[@zlozlozlo]

At 29:00 you say that private is the default access modifier of a class. That's wrong. The default access modifier for a class is internal. The default access modifier for its *members* is private. Also you are missing the *private protected* modifier from your table.

[@interviewhappy]

Yes zlo, I accepted it and highlighted in my comments.

[@pratikhanwate]

Default access modifier for class is 'internal' and for class members it's 'private'.

[@avipshasatpathy5382]

it is best video for .net interview.believe me

[@interviewhappy]

Thanks Avipsha. All the best for your interviews.

[@ysunil2012]

Dear Sir, you have mentioned that default access modifier of a class is private but in C# default access modifier of a class is Internal. We can only specify Internal and public access modifiers for class and for the class members we can specify all 5 access modifiers.

[@interviewhappy]

Thanks for the feedback. Yes, you are right. I will correct it soon.

[@poojanaik5853]

This is the best best video. Thanks a lot🙏

[@interviewhappy]

Thanks Pooja. Best of luck for your interviews.

[@gvasu4u]

Awesome presentation seriously our life is very happy if we go with the stuff great work sir keep it up and any plans for Azure!

[@interviewhappy]

Thanks Vasu. Yes Azure, Angular, React are in my plan.

[@mr.rahimosaab2693]

I got job offer today after preparing for interview thurugh this video I have given more then 10 to 13 interview and got offered today Sir you are right We should never give up

[@Humayel-i4l]

👍

[@ammarhaider221]

Amazing Brother! Keep up the good work! You are getting people jobs! Hope I get that one tomorrow too lol 😀

[@interviewhappy]

That is my objective. Learn but with goal. I wish you all the best buddy. Give your best.

[@bhagwatshahi7244]

Nice explanation. Interface can contains declaration of methods, properties and events.

[@interviewhappy]

Thanks Bhagwat for your comment

[@codingislife6387]

17:21 Sir you not giving Interview Question. But Also Helping us to Understand basic concepts thanks 🚨 🚨

[@interviewhappy]

Thanks man

[@lovetoexplore7176]

Awesome video sir, thanks for all your efforts 👍🙂.. expecting more content from you. Thanks

[@interviewhappy]

Thanks and all the best for your career

[@aloksharma2985]

Suppose we are passing one class object as a parameter in the method What is the difference if we pass with ref keyword like ref classname and and without ref keyword as class itself a reference type

[@saurabhpatil6604]

Sir This is too helpful to me😀😀😍

[@interviewhappy]

Great Saurabh... All the best

[@chetanmp03]

Can you please explain Multi threading ,Asynchronous calls and parallel calls?

[@sandeep89ms]

C# 8.0 had introduced a feature called "default interface methods," which allows interfaces to contain method implementations. This feature enables you to add new methods to an interface without breaking existing implementations.

[@pallavipawankar9705]

What are design patterns in c#? Could you please ping the video link if you know which will help me to understand the concept clearly?

[@sudeshnachanda3747]

Amazing content! Your efforts are clearly visible in the video. Keep up the good work! Thanks for helping all of us aspirants who are preparing for interview 😊😊

[@interviewhappy]

Thanks Sudeshna for the kind words. Wish you all the best for your career.

[@masqueradeee]

Thank you sir, really helpful !!

[@interviewhappy]

wc Masquerade, wish you all the best