Interview Questions

In business, a takeover is the purchase of one company by another.

One of the major component of ADO.NET is the DataSet object, which always remains disconnected from the database and reduces the load on the database.

In a Ethernet network, between any two points on the network, there can be no more than five network segments or four repeaters, and of those five segments only three of segments can be populated.

In a nutshell, a temp table is a temporary storage structure. It means you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format.

In table_user.gender column change ‘male to female’ and ‘female to male’ in one SQL statement.

UPDATE table_user

SET gender =

CASE gender

WHEN ‘male’ THEN ‘female’

WHEN ‘female’ THEN ‘male’

ELSE gender

END

The System.xml.dll is the real physical file, which contains the XML implementation. Some of the other namespaces that allow .NET to use XML are as follows:

      =>  System.Xml

      =>  System.Xml.Schema

      =>  System.Xml.XPath

      => System.Xml.Xsl

Data Mart is a data repository which is served to a community of people who works on knowledge (also known as knowledge workers). The data resource can be from enterprise resources or from a data warehouse.

A default is a value which will be used by a column, if no value is supplied to that column while inserting data.

Yes, IDENTITY and TIMESTAMP columns are free from the bounds of default.

BUS topology:

In this each computer is directly connected to primary network cable in a single line.

STAR topology:

In this all computers are connected using a central hub.