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

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

Create a SharePoint group and add users using JSOm

-
Below code will create a sharegroup and adds login user and a static user to the group.    <div>       <h1>Create SharePoint Group </h1>       <br />       <input id="btnCreateCustomGroup" type="button" value="Create SPGroup" />     </div>     <script src="/Style%20Library/Scripts/jquery-1.12.1.js"></script>      <script src="/_layouts/15/sp.js" type="text/javascript"></script>     <script src="/_layouts/15/SP.RequestExecutor.js" type="text/javascript"></script>     <script src="/_layouts/15/SP.search.js" type="text/javascript"></script>     <script type="text/javascript">     $(function() {       $('#btnCreateCustomGroup').click(btnCreateCustomGroup_Click);  ...
Read more

SP, UDF and VIEW

-
SPs are Databse subroutine used to perform tasks within the database, whether it be to INSERT, UPDATE, DELETE, SELECT, send return values, send output parameters, send e-mail, call command line arguments, encapsulate business logic, enforce data integrity, or any combination thereof. They are compiled when first run, and the query plans are stored and cached by SQL Server's optimizer, and those cached plans are swapped out depending on frequency of usage. View: • To hide the complexity of the underlying database schema, or customize the data and schema for a set of users. • To control access to rows and columns of data. • To aggregate data for performance. UDFS: Set of statements which must return an object considered as function. In general, UDFs can be a serious source of performance issues. Also, UDFs cannot be used for DML operations (INSERT/UPDATE/DELETE), cannot use non-deterministic functions, cannot use dynamic SQL, and cannot have error-handling (e.g. RAISERROR)....
Read more