20-10-2012, 11:23 AM
INTERVIEW QUESTION (.NET & SQL )
interview qs(.net&sql).doc (Size: 66 KB / Downloads: 67)
What is CSHARP?
C# (pronounced “see sharp”) is a one of Dot Net programming language and supports functional, generic, object-oriented (class-based), and component-oriented programming disciplines.
Microsoft has introduced C# on June 2000 and updating/Introducing new features with different versions.
The most recent version is C# 4.0, which was released in April 12, 2010.
Explain different C# Types used to create a csharp program?
Basically c# compiler supplies intrinsic data types (int, double, string etc) and programmers can define user defined data types(class, struct, enum etc).
All above C# types fall into any one of the following categories
• Value types
• Reference types
Explain Value type and reference type?
Value Type
Variables of value types directly contain their data.
Value types store in stack.
Reference Type
Variables of reference types store references to their data
Reference types store in Heap Memory.
How does CLR solves dll hell?
Unlike VB6; .net does not require to generate GUID for the dll’s. The dll’s are hosted thru applications ,IIS or windows services. These things internally refer to the physical locations of the file thus even if the dll is updated with certain functionalities the older application can still refer to the previous version of the Dll.
How to send xml file on server using HTTP protocol?
Through SOAP Protocol
What is different between Web.Config and Machine.Config and Where it will be ?
The settings made in the web.config file are applied to that particular web application only whereas the settings of machine.config file are applied to the whole asp.net application.
Whats the difference bt. .dll extension and .exe extension files?
The main difference between .dll and .exe is
.dll is the In process component where it take up the client’s memory space to run. So the communication between the application and component(dll) is very fast.
.EXE is the Out of process component. It uses its own memory(not application memory) to run the component. The communication between the application and component is slow when compared to .dll
What is the base class of .net?
System.Object is the base class of .NET
It Supports all classes in the .NET Framework class hierarchy and provides low-level services to derived classes. This is the ultimate superclass of all classes in the .NET Framework; it is the root of the type hierarchy.
What are Jagged Arrarys ?
The other type of multidimensional array is the jagged array. A two dimensional jagged array can be thought of as a table where each row can have a different number of columns. Take for example, a table where families are the rows and family members are the columns. Unless each family has the same number of members, each row will have a variable number of columns. You can use a jagged array to represent such a table.
A jagged array is really an array of arrays. To create a jagged array, you declare the array of arrays with multiple sets of parentheses or brackets and indicate the size of the jagged array in the first set of brackets (parentheses).
SQL interview questions http://www.freshersinfo.com)
What is the full form of SQL ?
Structured Query Language (SQL). It is pronounced “sequel”.SQl is a language that provides an interface to relation database systems. It was developed by IBM.
What are two methods of retrieving SQL?
What is a deadlock in SQL ?
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated. SQLServer detects deadlocks and terminates one user’s process.
What is livelock in SQL ?
A livelock is one, where a request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. SQL Server detects the situation after four denials and refuses further shared locks. A livelock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely.
Some important system function to get the current user details
• USER_ID()
• USER_NAME()
• SESSION_USER
• CURRENT_USER
• USER
• SUSER_SID()
• HOST_NAME().
What’s the difference between a primary key and a unique key?
Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn’t allow NULLs, but unique key allows one NULL only.
What cursor type do you use to retrieve multiple recordsets?
What is candidate key, alternate key, composite key in SQL ?
A candidate key is one that can identify each row of a table uniquely.Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys.A key formed by combining at least two or more columns is called composite key.