Top MNC Interview Questions- Full Stack Developer

-
Common Questions:

  • What is Reflection?
  • What is data integrity In SQL Server?
  • Different types of relationships in SQL Server?
  • Different b/w Union, Union All, Minus, Intersect?
  • When we use the method overloading concept in c#?
  • Real-time example for oops concepts?
  • Why we go for Interfaces when we have abstract Classes? (Note: Provide Reason other than multiple inheritances, and abstraction concept).
  • What is the Bundling and Minification Concept?
  • What are the different options available in google chrome developer tools?
  • Can we call the same request again from the network tab in the google chrome developer tab?
  • What are ACID properties in SQL Server?
  • What is CTE? Where we can use it and why?
  • What are the components of ado.net?
  • Types of Cookies in MVC and how the memory allocated?
  • Diff. b/w array.clone() and array.copyto()?
  • Why we need relations in SQL?
  • Diff. b/w Task and Thread?
  • How do you implement dependency injection in MVC .net standard f/w?
  • Async and Await?
  • Task and Task<T>?
  • Different types of properties in ajax call?
  • What is the success function and error function in ajax?
  • Diff. ways to access Html control values?
  • diff b/w ID and Class in Jquery?
  • How you can get all the form field values in one line using jquery?
  • How Session is maintained in MVC and .net core?
  • What happens if we define the same methods in partial classes with the same method name?
  • Why we use middle-wares in .net core?
  • What is app. run() in configure method of startup class in .net core?
  • How to avoid concurrency?
  • Different ways to handle exceptions in web API?
  • how to use exception filters and how to implement them with real-time examples?
  • If used logging in the application, how u save details and how do save object?
  • Every command in .net core CLI stats with?
  • Where we configure the middlewares in .net core?
  • Versions of MVC latest, .net core latest, .net framework, asp.net?
  • why var is used?
  • can we pass as a parameter and what is the use of dynamic in c#?
  • in which version dynamic came into use?
  • if I have 100 conditions to check which is better if-else or switch and performance-wise which is faster?
-------------------------- Asked all other common questions --------------------------
Cognizant Questions:
  • How to swap the same columns in two different tables in SQL?
  • How to update the same column values in different tables in SQL?
  • Program to find the duplicate characters in a string and also display the count of each character?
  • In SQL which is faster NOT IN or EXIST and why?
  • Diff b/w IsEqualto() and ==?
  • What are stack and heap?
  • How memory is allocated in stack and heap?
--------------------------------------------------------------------------------------------

NTTData Questions:
  • What is attribute and property in jquery?
  • How do we handle errors in web API?
  • How do you implement authentication and authorization in web API?
  • How do you restrict the web API to get called only from a particular port no?
  • how authentication works in web API?
--------------------------------------------------------------------------------------------

MindTree Questions:
  • why and where we should use var and dynamic?
  • solid principles in c#?(*)
  • Which sorting method is faster?
  • Explain about bubble sort?
  • composite primary key syntax in SQL? 
  • solid principles in SQL?
  • indexes in SQL?
  • what is cors?
  • how do we create a token in postman?
--------------------------------------------------------------------------------------------
CraftAny Questions:
  • Ex: string str="james@123#key@123#asdf@123"; Write the key-value pairs from the given string?
  • write the code to get the selected text from the dropdown in jquery?
  • write the ajax syntax?
  • how the DB connection object is created and maintained?
  • What are events and delegates? explain with examples?
  • why and where we should use static classes?
  • Indexing in SQL? why we need to do an index on the table?
--------------------------------------------------------------------------------------------

Other Company Questions:

  • How garbage collector works?
  • will GC collect the unmanaged code resources?
  • why we use dispose method and where do we use it? 
  • Ex: int[] _arr={1,2,3,4,5,6,7,8,9,0}; and u have index position ex: int indexposition=3; so, now rearrange the array based on index position as this: o/p:{4,5,6,7,8,9,0,1,2,3}. Write c# code for this?
  • SQL query to get the dept name and no of employees in dept?
  • How data is stored in SQL? Explain the internal process?
  • What is CTE in SQL?
  • What is View in SQL?
  • What is Temp Table in SQL?
  • If a stored procedure have have 1000 lines how you reduce the no.of.lines means what is the optimization technique to achieve this?(https://www.c-sharpcorner.com/blogs/optimizing-stored-procedures-in-sql-server)
  • Why we can't have more than one pk and clustered index in a table?
  • Why can we have more than one non-clustered index in a table?
  • in an ArrayList of type int can we store other type values?
  • View vs Temptable?
  • Post vs Put vs Get?
  • Diff b/w render and render partial








--------------------------------------------------------------------------------------------


Comments

Post a Comment

Popular posts from this blog

Interview Questions-2

-
 output of following program and if any errors what should be the correct syntax class baseclass {​​​​​​​​​      public void func1() {​​​​​​​​ Console.WriteLine ("Base Fun1()")​}​​​​​​​​​      public virtual void func2() {​​​​​​​​ Console.WriteLine ("Base Fun2()")​}​​​​​​​​​      public virtual  void func3() {​​​​​​​​​ Console.WriteLine ("Base Fun3()")}​​​​​​​​​ }​​​​​​​​​ class derivedclass :baseclass {​​​​​​​​​      new public void func1() {​​​​​​​​ Console.WriteLine ("derived Fun1()")​}​​​​​​​​​      public override void func2() {​​​​​​​​ Console.WriteLine ("derived Fun2()")​}​​​​​​​​​      public new void func3() {​​​​​​​​ Console.WriteLine ("derived Fun3()")​}​​​​​​​​​ }​​​​​​​​​ class Program {​​​​​​​​​      static void Main(string[] args)      {​...
Read more

How to get the user details, user current level, next level, Rank in sql server

-
 ALTER PROCEDURE [dbo].[SP_GETUSERPROFILE] @UserId int AS BEGIN --checks whether user reported any tweet or not IF EXISTS(SELECT * FROM OnGoingReports WHERE UserId=@UserId) BEGIN --if user already reported tweets then gets the user details and rank select UserId,UserName,Name,UserReportedTweetCount,Rank      from  (select UserId,UserName,Name,UserReportedTweetCount,ROW_NUMBER() OVER(ORDER BY UserReportedTweetCount desc) AS Rank  from      (select ogr.UserId,uc.UserName,Name,Count(*) UserReportedTweetCount from UserCredentials uc       inner join OnGoingReports ogr       on       ogr.UserId=uc.UserId        GROUP BY ogr.UserId,uc.Name,uc.UserName) as TopList ) as UserRank      where UserId=@UserId END ELSE BEGIN --if user not reported any tweets then it get the default value as 0 and rank based on tweets reported select UserId,UserName,Nam...
Read more