IT Trainer Questions

A source program is is a text file that contains instructions or a program written in a language other than machine code, typically a high-level language.

Iteration is most similar in meaning to the word repeatation i.e, looping.

Memory refresh is the process of periodically reading information from an area of computer memory and immediately rewriting the read information to the same area without modification, for the purpose of preserving the information.

Memory refresh is a background maintenance process required during the operation of semiconductor dynamic random-access memory (DRAM), the most widely used type of computer memory.

The US state California's  economy has surpassed that of the UK to become the world’s fifth largest, according to new federal data released.

With a GDP of $2.7 trillion, California is now only behind the US, China, Japan and Germany.

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.

In chemistry rusting is called as oxidation. Oxidation is a chemical process where metal gains oxygen and become oxide. In rusting the Iron ore make a chemical reaction with the oxygen in the presence of water and environmental or atmospheric moisture to produce an Iron oxide. Iron oxide is otherwise called as rust.

The rusting of iron is a chemical change because it is two substances reacting together to make a new substance. 

Rusting would only be a physical change if iron molecules remained pure iron throughout the process.

Electric current produces a magnetic field. This magnetic field can be visualized as a pattern of circular field lines surrounding a wire.

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.