Basic Interview Question .Net
Few very basic question you need to keep in mind in interview of asp.net where database is sql.you should be more curious toward each question to arise few more question from them.i have posted some in below of the post
1) Difference between a primary key and a unique key in SQL?
primary key doesn't allow duplicate values and does not allow null.
unique key also doesnot allow duplicate values but allows one null value
2) difference between asp and asp.net
The .NET compliant languages can be used with ASP.NET like C# and VB.NET, where both of them are server-sided languages. With ASP, only VBScript and JavaScript are available as options to be used.
3) What are the new features in ASP.net 3.5
The most significant improvements in ASP.NET are:
* Integrated Ajax Support
* New Data Controls (ListView and DataPager)
* The LinqDataSource Control
Visual Studio 2008 has also included some features for an improved web application development experience. Here is the list of such improvements:
* Support for LINQ
* IntelliSense for JavaScript and ASP.NET Ajax
* Improved Design time experience
4) Choosing a Web Service or .Net Remoting in projects?
Well Web services uses .Net remoting concepts internally. But the major difference between web service and .net remoting is that “web service” can be consumed by clients who are not .NET platform. While remoting you need the client to be .NET compliant.
Regarding the speed issue ".net Remoting" is faster than “Web Services”. So I think when deciding the architecture side of choosing between “Web services” and “.NET Remoting” keep the cross platform issue and the speed issue in mind.
5) Difference between DataSet and DataReader?
DataSet is a disconnected architecture, while DataReader has live connection while reading data. If we want to cache data and pass to a different tier DataSet forms the best choice and it has decent XML support.
When application needs to access data from more than one table DataSet forms the best choice.
If we need to move back while reading records, datareader does not support this functionality.
One of the biggest drawbacks of DataSet is speed. As DataSet carry considerable overhead because of relations, multiple tables etc speed is slower than DataReader. Always try to use DataReader wherever possible, as it’s meant specially for speed performance.
6) What is the difference between Hash Table and Arrays?
1.Array is a collection of same datatype
while
arrays are objects that derive from the base Array class and implement IEnumerable so that array elements can be enumerated with a For-Each loop.
2.Hash table is a colletion of different datatype.
Hash tables hold a collection of DictionaryEntry objects, where a DictionaryEntry holds the Key along with its value.
7) Difference between C# and C programming Language?
C# does not usually make use of pointers. You can only increment, or decrement a variable as if it were an actual memory pointer inside a special unsafe block.
You can declare variables anywhere inside a method you want to; they don’t have to be at the beginning of the method.
You don’t have to declare an object before you use it; you can define it just as you need it.
C# has a somewhat different definition of the struct types, and does not support the idea of a union at all.
C# has enumerated types, which allow a series of named values, such as colors or day names, to be assigned sequential numbers, but the syntax is rather different.
C# does not have bit fields: variables that take up less than a byte of storage.
C# does not allow variable length argument lists. You have to define a method for each number and type of argument. However C# allows for the last argument of a function to be a variable parameter array.
Few more on above 7 question you can explore...
1)foreign key?relation with foreign key?
2)MVC?
3).net 4.0 and further
4)WCF basic concept
5)disconnected and connected architecture
6)dictionary
7)c++
No comments:
Post a Comment