Interview Questions

Prices do not reflect the full social cost of production is an example of Market failure.

A market failure occurs when the supply of a good or service is insufficient to meet demand. This results in an inefficient distribution of resources among market participants.

It also occurs if externalities are not accounted for.

If a firm fails to maximize its profits this is not a general market failure.

The differences between HTML and XHTML are:

- HTML is application of Standard Generalized Markup Language(SGML) whereas XML is application of Extensible Markup Language(XML).

- HTML is a static Web Page whereas XHTML is dynamic Web Page.

- HTML allows programmer to perform changes in the tags and use attribute minimization whereas XHTML when user need a new markup tag then user can define it in this.

- HTML is about displaying information whereas XHTML is about describing the information.

UDP (User Datagram Protocol) is a communications protocol that offers a limited amount of service when messages are exchanged between computers in a network that uses the Internet Protocol (IP).

If any one want to restrict Trans-ID to single user, enter trans-id with ENQ. It won't allow any one else to use the same trans-id.

The job cost sheets constitute the subsidiary ledger for the Work in Process Inventory Account.

A job cost sheet is a form used to record the costs chargeable to a specific job and to determine the total and unit costs of the completed job. Companies keep a separate job cost sheet for each job.

UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones

The journal entry to record a credit sale is Accounts Receivable. Credit sale is nothing butthe customers pay at the time of buying.

One of the most common errors that you might face in join statements is 

Server: Msg 4104, Level 16, State 1, Line 1
The multi-part identifier could not be bound.

A multipart identifier is any description of a field or table that contains multiple parts - for instance MyTable.SomeRow - if it can't be bound that means there's something wrong with it - either you've got a simple typo, or a confusion between table and column. It can also be caused by using reserved words in your table or field names and not surrounding them with [].

The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, and then if you get error above, this means that Table1 cannot be found in the query. Sometimes you can see that source table exists in the query, but T-SQL cannot understand it, especially when you write join statements.