Interview Questions

Price and quantity supplied move in the same direction. As the price decreases, quantity supplied also decreases and viceversa.

SQL Server is having a fantastic feature to retrieve data persisted in the form of XML format. The data in the XML format can be retrieved using FOR XML clause appending to the SELECT statement.

It offers 3 modes.

- “FOR XML AUTO": Returns XML elements that are nested, based on which tables are listed in the "from" part of the query, and which fields are listed in the "select" part.

- "FOR XML RAW": Returns XML elements with the "row" prefix (ex: ""). Each column in a table is represented as an attribute and null column values aren't included.

- "FOR XML EXPLICIT": Explicit mode is the most complex shaping method used in SQL Server 2000. It allows users to query a data source in such a way that the names and values of the returned XML are specified before the query batch is executed. 

The main reason why the scope resolution operator (::) cannot be overloaded is that only operators that take in values as parameters can be overloaded. The scope resolution operator does not take a value as parameter.

FIND_GROUP(function) FIND_COLUMN(function)

Creating partition may serve different purposes. The common reason is that a separate partition can be used to store data files so that when Windows needs to be reinstalled, the main partition can be formatted without fear of loosing data, which are stored on the other partition.

 The primary reason to issue stock is to raise money to start and maintain an ongoing business.

Other Reasons::

The reasons that a company might want to raise money by issuing stock are:

• To develop new products

• To buy more advanced equipment

• To pay for new buildings and inventories

• To hire more employees

• To provide for a merger or acquisition

• To decrease debt

• To give company owners greater flexibility

• To place a value on the company.

var checkedP = window.document.getElementById("myCheckBox").checked;