Analyst Questions

Indira Gandhi became the first woman to receive the Bharat Ratna award in 1971.

The Sahara is the biggest desert in the world.

It occupies the northern one third of the African continent.

The Indira Gandhi Zoological Park is located in Vishakapatnam (Vizag) in the state of Andhra Pradesh.

An ionic bond is a chemical bond between two atoms in which one atom seems to donate its electron to another atom.

Here in the given compounds, the compound that contains ionic bond is CaO, Calcium oxide.

The art and science of map making is called Cartography.

The highly energetic gamma particles can penetrate most compounds that stop by other types of radiation. However, lead, steel, or concrete can reduce the high energy of these particles, making them less penetrating.

Hence, Gamma radiation can be stopped by a several inches of lead or steel, or several meters of concrete.

DNA - Deoxyribonucleic acid is a type of nucleic acid. The sugar contained in it is called Deoxyribose.

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.