1.What is the difference between clustered index and non cluster index difference? Which scenario they will be used?
2.How to display one lakh records in data grid? Which is best one?
3.Multiple databases how will you maintain the transactions?
4.Table lock which isolation level?
1.Do you face any problems in your carrier?
2.Do you have onsite experience and how many years total in your carrier?
3.Do you face any team issues?
4.For planning which tool you have used?
1.What are the protocols used in web service?
SOAP is an XML-based protocol for exchanging information between computers.
The Web service protocol stack is an evolving set of protocols used to define, discover, and implement Web services. The core protocol stack consists of four layers:
Service Transport: This layer is responsible for transporting messages between applications. Currently, this includes HTTP, SMTP, FTP, and newer protocols, such as Blocks Extensible Exchange Protocol (BEEP).
XML Messaging: This layer is responsible for encoding messages in a common XML format so that messages can be understood at either end. Currently, this includes XML-RPC and SOAP.
Service Description: This layer is responsible for describing the public interface to a specific Web service. Currently, service description is handled via the WSDL.
Service Discovery: This layer is responsible for centralizing services into a common registry, and providing easy publish/find functionality. Currently, service discovery is handled via the UDDI.
2.What is the role of worker process?
The worker process handles all the requests passed to the ASP.NET framework
3.Tell me how the page load process happen in dot net?
4.What are the providers available in dot net?
Membership Providers
Role Providers
Site Map Providers
Session State Providers
Profile Providers
Web Event Providers
Web Parts Personalization Providers
5.What is the difference between array and arraylist?
a) The capacity of an Array is fixed. Where as, ArrayList can increase and decrease size dynamically.
b) An Array is a collection of similar items. Where as, ArrayList can hold item of different types.
c) Array is in the System namespace. Where as, ArrayList is in the System.Collections namespace.
d) An Array can have multiple dimensions. Where as, ArrayList always has exactly one dimension.
e) We can set the lower bound of an Array. Where as, the lower bound of an ArrayList is always zero.
6.What is difference between hash table and array list?
Thus Hash is an array of KeyValue pair. There are few special methods defined, which allows you to search a particular value based on the key passed.
In one word, ArrayList is Index based, while HashTable is both Index based and KeyBased.
Array List
1.Array List is a List
2.In this we can only add items to the list
3.Here we Can Add any datatype value,Every item in
arraylist is treated as object
Hash Table
1.Hash Table is a map
2.Here we can add data with the key
3.Retrieving by key in Hashtable is faster than retrieving in
Arraylist
7.Based on what request go to particular web site?
8.How to set home page in dot net?
9.How will pass the session information one server to another server?
10.Why sqlclient provider retrieve the data very fast compare to oledb?
11.What are the things taken care the architect?
12.How will represent the 3rd party entity in use cases?
13.What is DNS?
A DNS server is any computer registered to join the Domain Name System. A DNS server runs special-purpose networking software, features a public IP address, and contains a database of network names and addresses for other Internet hosts.
14.What is difference between convert.string and tostring?
The basic difference between them is “Convert” function handles NULLS while “i.ToString()”
does not it will throw a NULL reference exception error. So as good coding practice using
true
4.Delegates?
A delegate is a reference type, like the other reference types you've seen in this book, but instead of referring to an object, a delegate refers to a method. This is called encapsulating the method. When you create the delegate, you specify a method signature and return type; you can encapsulate any matching method with that delegate.
5.Events?
Events in C# are implemented with delegates.The publishing class defines a delegate. The subscribing class does two things: first, it creates a method that matches the signature of the delegate, and then it creates an instance of that delegate type encapsulating that method. When the event is raised, the subscribing class's methods are invoked through the delegate.
By convention, event handlers in the .NET Framework always return void and take two parameters. The first parameter is the "source" of the event (that is, the publishing object). The second parameter is an object derived from EventArgs. Your event handlers will need to follow this design pattern.
EventArgs is the base class for all event data.
6.Asynchronous method?
Basically, doing something called Fire and Forget.
2.How to display one lakh records in data grid? Which is best one?
3.Multiple databases how will you maintain the transactions?
4.Table lock which isolation level?
Infosys
1.Do you face any problems in your carrier?
2.Do you have onsite experience and how many years total in your carrier?
3.Do you face any team issues?
4.For planning which tool you have used?
ACCENTURE
1.What are the protocols used in web service?
SOAP is an XML-based protocol for exchanging information between computers.
The Web service protocol stack is an evolving set of protocols used to define, discover, and implement Web services. The core protocol stack consists of four layers:
Service Transport: This layer is responsible for transporting messages between applications. Currently, this includes HTTP, SMTP, FTP, and newer protocols, such as Blocks Extensible Exchange Protocol (BEEP).
XML Messaging: This layer is responsible for encoding messages in a common XML format so that messages can be understood at either end. Currently, this includes XML-RPC and SOAP.
Service Description: This layer is responsible for describing the public interface to a specific Web service. Currently, service description is handled via the WSDL.
Service Discovery: This layer is responsible for centralizing services into a common registry, and providing easy publish/find functionality. Currently, service discovery is handled via the UDDI.
2.What is the role of worker process?
The worker process handles all the requests passed to the ASP.NET framework
3.Tell me how the page load process happen in dot net?
4.What are the providers available in dot net?
Membership Providers
Role Providers
Site Map Providers
Session State Providers
Profile Providers
Web Event Providers
Web Parts Personalization Providers
5.What is the difference between array and arraylist?
a) The capacity of an Array is fixed. Where as, ArrayList can increase and decrease size dynamically.
b) An Array is a collection of similar items. Where as, ArrayList can hold item of different types.
c) Array is in the System namespace. Where as, ArrayList is in the System.Collections namespace.
d) An Array can have multiple dimensions. Where as, ArrayList always has exactly one dimension.
e) We can set the lower bound of an Array. Where as, the lower bound of an ArrayList is always zero.
6.What is difference between hash table and array list?
Thus Hash is an array of KeyValue pair. There are few special methods defined, which allows you to search a particular value based on the key passed.
In one word, ArrayList is Index based, while HashTable is both Index based and KeyBased.
Array List
1.Array List is a List
2.In this we can only add items to the list
3.Here we Can Add any datatype value,Every item in
arraylist is treated as object
Hash Table
1.Hash Table is a map
2.Here we can add data with the key
3.Retrieving by key in Hashtable is faster than retrieving in
Arraylist
7.Based on what request go to particular web site?
8.How to set home page in dot net?
9.How will pass the session information one server to another server?
10.Why sqlclient provider retrieve the data very fast compare to oledb?
11.What are the things taken care the architect?
12.How will represent the 3rd party entity in use cases?
13.What is DNS?
A DNS server is any computer registered to join the Domain Name System. A DNS server runs special-purpose networking software, features a public IP address, and contains a database of network names and addresses for other Internet hosts.
14.What is difference between convert.string and tostring?
The basic difference between them is “Convert” function handles NULLS while “i.ToString()”
does not it will throw a NULL reference exception error. So as good coding practice using
POLARIS
1.Inheritance?
Inheritance is a way to establish Is-a relationships between objects.
Inheritance for implementation reuse leads to Tight Coupling.
Re-usability of code is achieved through composition.
HAS-A can be better than an IS-A relationship.
2.Polymorphisam?
Base classes may define and implement virtual methods, and derived classes can override them, which means they provide their own definition and implementation. At run-time, when client code calls the method, the CLR looks up the run-time type of the object, and invokes that override of the virtual method.
Operator overloading of the numeric operators (+, -, *, and /) allows polymorphic treatment of the various numerical types: integer, unsigned integer, float, decimal, etc.; each of which have different ranges, bit patterns, and representations.
http://msdn.microsoft.com/en-us/library/ms173152.aspx
3.Object comparison?
Person person1a = new Person("John");
Person person1b = person1a;
person1a.Equals(person1b)); Inheritance is a way to establish Is-a relationships between objects.
Inheritance for implementation reuse leads to Tight Coupling.
Re-usability of code is achieved through composition.
HAS-A can be better than an IS-A relationship.
2.Polymorphisam?
Base classes may define and implement virtual methods, and derived classes can override them, which means they provide their own definition and implementation. At run-time, when client code calls the method, the CLR looks up the run-time type of the object, and invokes that override of the virtual method.
Operator overloading of the numeric operators (+, -, *, and /) allows polymorphic treatment of the various numerical types: integer, unsigned integer, float, decimal, etc.; each of which have different ranges, bit patterns, and representations.
http://msdn.microsoft.com/en-us/library/ms173152.aspx
3.Object comparison?
Person person1a = new Person("John");
Person person1b = person1a;
true
4.Delegates?
A delegate is a reference type, like the other reference types you've seen in this book, but instead of referring to an object, a delegate refers to a method. This is called encapsulating the method. When you create the delegate, you specify a method signature and return type; you can encapsulate any matching method with that delegate.
5.Events?
Events in C# are implemented with delegates.The publishing class defines a delegate. The subscribing class does two things: first, it creates a method that matches the signature of the delegate, and then it creates an instance of that delegate type encapsulating that method. When the event is raised, the subscribing class's methods are invoked through the delegate.
By convention, event handlers in the .NET Framework always return void and take two parameters. The first parameter is the "source" of the event (that is, the publishing object). The second parameter is an object derived from EventArgs. Your event handlers will need to follow this design pattern.
EventArgs is the base class for all event data.
6.Asynchronous method?
Basically, doing something called Fire and Forget.
