Interview Questions

In a database table, the category of information is called Field.

Arrays can store data in a fix allotted space. The use of linked list allows more flexibility because space is dynamically allocated as needed.

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. 

 ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.

By setting the columnSpan property for cells of each row as required.

- The Dictionary class is an abstract class.

- Classes like Hashtable which map keys to values inherit from this class. 

- An object can be looked for if a dictionary and a key is provided.

- Any non-null object can be used as a key and as a value.

Windows object is top level object in Java script. It contains several other objects such as, document, history, location, name, menu bar etc., in itself. Window object is the global object for Java script that is written at client-side.

Information pertaining to the client browser and system is returned by the navigator object of JavaScript. Navigator object is the top level object for all users.

Fractional reserve banking is the practice whereby a bank accepts deposits, makes loans or investments, but is required to hold reserves equal to only a fraction of its deposit liabilities. Fractional reserve banking is a banking system in which only a fraction of bank deposits are backed by actual cash on hand and are available for withdrawal. This is done to expand the economy by freeing up capital that can be loaned out to other parties.