Interview Questions :- .NET,ASP.NET , SQL Server , C#, SharePoint, Javascript, Jquery

Hey All,
   Below are some Questions ( not answers :-) ) that are asked in interviews that I have faced. Hope they prove useful to you for your preparation at some point of time.

 The Questions are mixed of : ASP.NET , SQL Server , .NET Framework , SharePoint , C# , OOPS

1. What are magic tables in SQL Server 
2.  How many and what are temp tables in Sql Server ?
3.  How will you call trigger in Sql Server ?
4.  How will you call function in Sql Server ?
5.   There are 2 tables A and B having 3 columns each...What is the output of " Select * from A,B?
6.   What is the maximum number of Clustered indexes a table can have ?
7.  when you update a table in SQL Server management studio .., what exactly happens ?
8.  What is project life cycle?
9.  What are the differences b/w SQL Server 2008 and SQL Server 2012?
10.  What is the difference between Site Template and Site Definition?
11.  What are Generics in C# ? What is the use of it ?
12.  Protected vs Protected Internal in C# ?
13.  can we create master page through sharepoint desginer ?
14.  what is the difference between creating items through sharepoint designer and sharepoint server?
15.  ASP.NET page life cycle?
16.  when can we change page's Viewstate ? on which event ?
17.  can you create site template ? how ?
18.  what is the prurpose of SPSecurity class in SharePoint ?
19.  what is Code access security in .NET ?
20.  There are 2 tables A and B... A has 3 columns , 5 rows ... B has 2 columns , 3 rows ..What will be the output of  a) Select * from A,B b) cross join between 2 tables (how many rows and columns will a cross join between 2 tables return ?)
21.  What are Cross joins ?
22. how will update sharepoint list ? write the code.
23.  what are extension methods in C#?
24.  what are anonymous methods in c#?
25.  why multiple inheritance is not possible in C#?
26. what is a site column in SharePoint?
27. Difference b/w sandboxed and Farm solution?
28.  Difference b/w Web Parts and Visual Web Parts.
29.  how to make a master page in Sharepoint Site?
30.  abstract class vs interfaces
31.   Explain Sharepoint Object Model
32.  What are SPutility and SPMetal in SharePoint ?
33.  What is .wsdl file in a web service ? 
34.  how many ways you handle erors in a web page ?
35.  HttpUtility class vs Http Module
36.  Can you run JSP pages in IIS ? How ?
37.  which exception will first occur ?inside BAL , DAL , or UI layers'?
38.  What does theme in CSS contains ?
39.  What are views in SQL Server ? can we perform DML in Views?
40.  User Defined Functions Vs Stored Procedure?
41.  Difference b/w SQL variable @ and @@
42.  Difference between Hidden Field vs Viewstate ?
43.  Boxing and Unboxing difference
44. What are extension methods and extension classes in C#?
45.  Inproc vs Outproc in Stored Procedures?
46.  HTTP module vs HTTP handler
47.  HTTP get vs HTTP Post?
48. Abstraction vs Encapsulation
49.  overloded methods can have different return type?
50.  static class vs Sealed classes .. why are they used ?
51.  polymorphism in C#
52.  types of triggers in SQL SERVER
53.  Left outer join in SQL SERVER
54.  What are indexes in SQL SERVER
55.  What are cursors in SQL Server
56.  What is the new keyword in Method overriding?
57.  What are different types of views in SQL Server?
58.  what is a $ sign in Jquery ?
59.  How will you enable a website to run only for indian country?
60.  what are lambda expressions in C#?
61.  what is difference between array and arraylist ? when to use what and which one is faster?
62.  what is datareader ? how is it different from dataset?
63.  What are out, ref parameter in C# method?
64.  For vs ForEach loop
65. what is the benefit of putting the .wsp or solution file inside GAC and inside BIN?
66.  what is RunWithElevatedPrivileges in SharePoint?
67.  what is the difference between webpart and Visual WebPart?
68.  what is the difference between Sytem.web.UI.WebControls.Webparts.WebPart vs Microsoft.Sharepoint.WebPart?
69.  Abstraction Vs Encapsulation
70.  What is viewstate ? Can you store collections in Viewstate?
71.  What is the difference between Stored Procedures and User Defined Functions in Sql Server ?
72.  What is LINQ and advantages of LINQ ?
73.  I have a collection of strings , Which will be more efficient LINQ or normal for / for each loop?
74.  What are the ways of storing information into clients computers?
75.  What are Selectors in Jquery ?
76.  What are the advantages of Entity Framework?
77.  Request vs Response Cycle of a Page?
78. Limitations of sharepoint designer
79. how will you create master pages and how will you deploy?
80.  what is a feature ? how will you deploy feature?
81.  how will you associate one content type to 3 lists ?
82.  What is caching ? How many types of caching is there?
83.  What is the difference between caching and session ?
84.  Generic list vs arraylist vs array in terms of performance and why ?
85.  why serialization is done and what are the types of serialization?
86.  What is the difference b/w caching and Session ?
87. Difference b/w httphandlers and http modules.
88.  what are the limitations or disadvandtages of Generics
89.  how to find the 4th highest salary in table?
90.  .net 2.0 vs .net 4.0 features
91.  What is garbage collector ?
92.  garbage collector dispose vs finalize 
93.  what are table valued functions in SQL Server
94.  What are shared assemblies
95.  What is Isnull and collasce operator in SQL Server?
96.  interface vs abstract class
97.  return server date in javascript 
98.  how to increment each salary of all employees with 500 
99.  how to work with cookies in asp.net 
100.  javascript function on html control click and asp.net control click
     
     
     ALL THE VERY BEST !!!

Purchased New Phone : Samsung Omnia W ( Windows Phone :- Mango)

Hi All,
    I purchased my first ever smartphone and that too windows phone .. I purchased it in the month of January but I am posting the pictures of my phone now...
  The model of my Phone is : Samsung Omnia W -  i8310
  Price ( I purchsed for ) : INR 18000

and here are the specs of Phone.. http://www.gsmarena.com/samsung_omnia_w_i8350-4200.php


Thanks,
Nitin Sharma

Fetch / Get Current Date from SQL Server in a specific format

Hi All,
      Working on Saturday is really a pain...Phew...!!!!...

I came across a requirement where you have to get a Current Date from Sql Server in the following format :

DD - MM - YYYY (note the hyphen in between)

So, here is the script with the Sql Server Replace function...:

Select Replace(Convert(varchar(11),Getdate(),106),' ',' - ') as 'Today'

And the Result is :

Thanks,
Nitin Sharma

Happy Coding....

Add Twitter and Facebook like Social Sites link to ASP.NET WebSite

Hi All,

      This is my first post of the year 2012.

I came across one requirement in my recent project in which where i do have to add two share buttons for two most popular social networking sites Facebook and Twitter.

I found this HTML code to be placed in any asp.net site . Below is the code:

<a href="http://twitter.com/home?status=" target="_blank" onclick="window.open(this.href, this.target,'height=500px,width=400px'); return false">

  <img src="Images/twitter.png" alt="Share on Twitter" />

a>

<a href="http://www.facebook.com/connect/prompt_feed.php?&message=" target="_blank" onclick="window.open(this.href, this.target,'height=500px,width=400px'); return false">

  

<img src="Images/facebook.png" alt="Share on Twitter" />

a>

Thats it...and  you are ready with the share button.

Below is the snapshot of  the rendered page after click on facebook and twitter image link.

Clicking on Twitter image opens the below page as a pop up:

Clicking on Facebook image opens the below page as a pop up:

This is for sharing your own  on these two networking sites but not shareing the link or any other outside matter.

Thanks,

Nitin Sharma

Happy Coding..!!!

Machine Key Generator for Encrypted PasswordFormat in ASP.NET Membeship

Hello Techies,
   Here i found a MachineKey Generator ( generated in XML  tag ) , which generates your machine key that is used in applications.

Go to this URL : http://www.eggheadcafe.com/articles/GenerateMachineKey/GenerateMachineKey.aspx
Click on the button "Generate Me A Key!"

I found it when i was in need to change my PasswordFormat to "Encryted" in ASP.NET membeship.
So what you have to do is add / change the passwordFormat="Encrypted"/> and add the machine key in the tag. 

So , your web.config will have settings like this.

Asp.NET membership has "Hashed" Passwordformat by default but you have to change in web.config file for "Clear" and "Encrypted" formats. (remember both format names are case sensitive).


Thanks,
Happy coding
Nitin Sharma

Show excel sheet data in Gridview using C#

Hi All,
   This post show how you can show data of Microsoft Excel Sheet inside a ASP.NET gridview.

The excel sheet in this example is generated by exporting the Northwind Database's Customers table . I have placed the excel sheet  in my D:\ directory and named it as "Test".

The excel sheet looks something like this :

Now on a web page take a ASP.NET GridView Control and and on the Page_load event write this code :

        string F1Name = "D:\\Test.xls";

        string CnStr = ("Provider=Microsoft.Jet.OLEDB.4.0;" + ("Data Source="

        + (F1Name + (";" + "Extended Properties=\"Excel 8.0;\""))));

        DataTable DT = new DataTable();

        OleDbDataAdapter DA = new OleDbDataAdapter("Select * from [Customers$]", CnStr);

       Response.Write("File Accessed!!!!");

        try

        {

            DA.Fill(DT);

            GridView1.DataSource = DT;

            GridView1.DataBind();

        }

        catch (Exception ex)

        {

            Response.Write(ex.Message);

        }

                      

Run the WebPage and see the result as: 

Hope it will be useful.

Thanks,

Nitin Sharma

Differences Between Sandboxed and Farm Solutions

Hello everybody,

This blog post is for all those guys who are new to Microsoft SharePoint Technologies and want a precise concept of what are Sandboxed solution and Farm Solution.

The MSDN explains it brilliantly......

Here is the URL : http://msdn.microsoft.com/en-us/library/ee361616.aspx

Below is the content from MSDN :

When you compile a SharePoint solution, it deploys to the SharePoint server and a debugger attaches to debug it. The process used to debug the solution depends on the setting of the Sandboxed Solution property: sandboxed solution or farm solution.

Farm Solutions

---

Farm solutions, which are hosted in the IIS worker process (W3WP.exe), run code that can affect the whole farm. When you debug a SharePoint project whose Sandboxed Solution property is set to "farm solution," the system's IIS application pool recycles before SharePoint retracts or deploys the feature so as to release any files locked by the IIS worker process. Only the IIS application pool serving the SharePoint project's site URL is recycled.

Sandboxed Solutions

---

Sandboxed solutions, which are hosted in the SharePoint user code solution worker process (SPUCWorkerProcess.exe), run code that can only affect the site collection of the solution. Because sandboxed solutions do not run in the IIS worker process, neither the IIS application pool nor the IIS server must restart. Visual Studio attaches the debugger to the SPUCWorkerProcess process that the SPUserCodeV4 service in SharePoint automatically triggers and controls. It is not necessary for the SPUCWorkerProcess process to recycle to load the latest version of the solution.

Either Type of Solution

---

With either solution type, Visual Studio also attaches the debugger to the browser to enable client-side script debugging. Visual Studio uses the script debugging engine for this purpose. To enable script debugging, you must change the default browser settings when you are prompted.

Visual Studio attaches the debugger only to the W3WP or SPUCWorkerProcess processes running the current site. Visual Studio also attaches the managed COM Plus and workflow debugging engines.

All about Sanboxed Solution , below is the link from http://technet.microsoft.com

http://technet.microsoft.com/en-us/library/ee721992.aspx

I hope the above links will make you clear differences between Sanboxed and Farm Solution in SharePoint.

Have a great day.!

Thanks,

Nitin Sharma

How to know that your machine/system is 64 bit capable?

Hi All,

If you want to know all about your PC machine hardware insights,then this post is for you.

I came across to this tool when i was in need of installing Sharepoint 2010 but need to check that my machine was 64 bit capable or not...and my mentor found this tool on Google :)

It is http://www.cpuid.com/

Download the Download version 1.53 32-bit (.zip, no install, english) if your machine is 32 bit and you want to check that is it 64 bit capable?

Also running on .exe it display hardware insights like Graphics,ram(its slots),processor etc etc...

I really found it useful.

Thanks,

Nitin Sharma

Microsoft Surface

What is Microsoft Surface?

Microsoft Surface™, the first commercially available surface computer from Microsoft Corp., turns an ordinary tabletop into a vibrant, interactive surface. The product provides effortless interaction with digital content through natural gestures, touch and physical objects. Surface is a 30-inch display in a table-like form factor that's easy for individuals or small groups to interact with in a way that feels familiar, just like in the real world. In essence, it's a surface that comes to life for exploring, learning, sharing, creating, buying and much more. Soon to be available in restaurants, hotels, retail establishments and public entertainment venues, this experience will transform the way people shop, dine, entertain and live.


How does Surface work?

At a high level, Surface uses cameras to sense objects, hand gestures and touch. This user input is then processed and the result is displayed on the surface using rear projection.
What is surface computing?Surface computing is a new way of working with computers that moves beyond the traditional mouse-and-keyboard experience. It is a natural user interface that allows people to interact with digital content the same way they have interacted with everyday items such as photos, paintbrushes and music their entire life: with their hands, with gestures and by putting real-world objects on the surface. Surface computing opens up a whole new category of products for users to interact with.


What are the key attributes of surface computing?

Surface computing has four key attributes:
• Direct interaction.

Users can actually "grab" digital information with their hands and interact with content by touch and gesture, without the use of a mouse or keyboard.

• Multi-touch contact.

Surface computing recognizes many points of contact simultaneously, not just from one finger, as with a typical touch screen, but up to dozens and dozens of items at once.

• Multi-user experience.

The horizontal form factor makes it easy for several people to gather around surface computers together, providing a collaborative, face-to-face computing experience.

• Object recognition.

Users can place physical objects on the surface to trigger different types of digital responses, including the transfer of digital content.


How does Surface benefit consumers?


Surface breaks down the traditional barriers between people and technology, providing effortless interaction with digital content. Similar to the way ATMs changed how people got money from the bank, Microsoft is changing the way people will interact with all kinds of everyday content, including photos, music, a virtual concierge and games. Common, everyday tasks become entertaining, enjoyable and engaging, alone or face-to-face with family, friends or co-workers.