Interview Questions

-

MS.NET:

  1. Oops A to Z
    2. •  How to implement two interfaces when they have a method with the same signature? •  Explain the scenario where you will use Abstract class, Interface? And explain the differences?
  2. Differences between stored proc and a function
  3. Is sqlconnection managed or unmanaged code? Explain the reasons?
  4. Explain about Garbage collection? How will you call explicitly garbage collection?
  5. How will you handle unmanaged code with the help of Garbage collection?
  6. What namespaces are used in ADO.NET
  7. What is the difference between delete() and remove() methods of Datagrid row?
  8. How to use unmanaged code in a .net application?
  9. Explain about design patterns?
  10. What are application blocks?
  11. Difference between [Proctected Internal] and Internal?
  12. Difference between data reader and dataset?
  13. Optimization techniques
    14. •  Application level •  Database level •  how to find out the performance bottlenecks in deployed application and what are their solutions?
  14. What are collections and generic collections?
    15. •  Difference between Arraylist and List? •  What is Hybrid dictionary?
  15. Explain Asp.net Page life cycle?
  16. What are Assemblies? How to create and implement a Shared Assembly in a application?
  17. What is difference between user control and custom control?
  18. Difference between Server.transfer and Response.redirect?
  19. What are events and delegates?

 

Sql Server:

  1. Explain about Indexes?
  2. How to design a database for a given application?
  3. Difference between Truncate and Delete?
  4. Write a query to delete duplicate rows in a table?
  5. Find nth max salary of an employee?
  6. What are triggers? What are new features added in 2.0?
  7. Differences between 2000 and 2005
  8. Explain about Joins?

Note: Will be updated soon! If you have any thing to add please comment below or mail to rknuthakki@gmail.com :-)

Comments

Post a Comment

Popular posts from this blog

SharePoint 2019 New Features

-
  SharePoint 2019 Majorly brought modern experience available in Online Communication sites: Communication sites are a place to share news, showcase a story, or broadcast a message to other people Create fast sites Fast site creation in SharePoint Server 2019 allows users create new sites in a few seconds ·        OneDrive personal site [SPSPERS#10] ·        Team site (modern only) [STS#3] ·        Communication site [SITEPAGEPUBLISHING#0] Modern Experience SharePoint Server 2019 contains the modern experiences for lists and libraries in Team sites. 1.      Lists and Libraries 2.      Modern WebPart 3.      Site Page 4.      Modern Search Experience 5.      Team Sites Integration with Power Apps, Power BI and Power Automate From the SharePoint home page, you can create sites in different web applications Sync files with the new OneDrive sync app Improved Hybrid Experience    
Read more

Move the list items from one list to another list using PowerShell - SharePoint 2010

-
Using below script one can move items from one list to another(including CreatedBy/ModifiedBy which are configured in a list(source,target,item age). #*************************************************************************** # Moves list/library items from one location to another location for archiving. Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue $srcListSiteUrl = http://testsite $ConfigListName = "ArchivalConfiguration" $IDFieldName = "OldItemID"  $date = Get-Date -format y $ldate = Get-Date $LogDate = $date -replace " ", "_" $path = "C:\Jobs\ArchivalLog\" If(!(test-path $path)) {     New-Item -ItemType Directory -Force -Path $path } $Logfile = "$($path)\$($LogDate).log" Add-content $Logfile -value "******************************************************************************" Add-cont
Read more

Email Validation for SharePoint list column

-
Image
Please use the below formula in [Column validation] of the list column edit section. Please replace the [Email] with your column name. Formula: --------------------------------------------------------------------- =AND(     ISERROR(FIND(" ", [Email],1)),     IF(ISERROR(FIND("@", [Email],2)),         FALSE,         AND(             ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),             IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),                 FALSE,                 FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])             )         )     ) ) ------------------------------------------------------------------------  
Read more