Interview Questions for 3+ Years of Experience on .NET Professionals

Hi friends in this I will explain about Interview Questions for 3+ Years of Experience on .NET Professionals.

You can refer  .NET interview Questions for 1-2 years Experience, .NET interview Questions for 1-2 years Experience and What is the sequence in which ASP.NET events are processed? Interview Questions on ASP.NET

1. How may clustered index we can create in table?
A: Clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.
To create a different clustered index on the same table, change the Create as Clustered property setting on the existing clustered index before creating the second index.

2. Why DBMS? Why don't we save data in separate files?

•         You can query data in a database (ask it questions).

•         You can look up data from a database relatively rapidly.

•         You can relate data from two different tables together using JOINs.

•         You can create meaningful reports from data in a database.

•         Your data has a built-in structure to it.

•         Information of a given type is always stored only once.

•         Databases are ACID.

•         Databases are fault-tolerant.

•         Databases are concurrent; multiple users can use them at the same time without corrupting the data.

•         Databases scale well.

•         Data is very structured.

•         Persistent data.

•         Databases can handle very large data sets.

3. What exactly is happening when we make a field a primary key?

A. A clustered index will be created for that specific field.

4. What is the output of the following will be.

public class Sample

{

public int Sample()

{

Console.WriteLine(“Hi this is Sample class”);

}

} 

 A. Here we have a constructor Sample , a constructor should not have a return type. So the above code will throw a compilation error.”error: Method Must have return type.”