IT Trainer Questions

A Paper.

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.

The standard English sentence order is Subject-Verb-Object.

For example ::

In the sentence, Why did you (S) do (V) that (O)?

String Args (String []) is an array of parameters of type String.

In Java, 'args' contains the supplied command-line arguments as an array of String objects. In other words, if you run your program as 'java MyProgram Hello World' then 'args' will contain ["Hello", "World"]. When a java class is executed from the console, the main method is what is called.

Million Instructions Per Second is a method of measuring the raw speed of a computer's processor. MIPS measures roughly the number of machine instructions that a computer can execute in one second.

A UPS (Uninterruptible Power Supply) is a device that provides battery backup when the electrical power fails or drops to an unacceptable voltage level.

Small UPS systems provide power for a few minutes; enough to power down the computer in an orderly manner, while larger systems have enough battery for several hours.

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.

A primary key is a special relational database table column or combination of columns designated to uniquely identify all table records. That is, A primary key is a column or set of columns in a table that uniquely identifies tuples (rows) in that table.

A primary key, also called a Primary Keyword.

Main Features Primary key are ::

It must contain a unique value for each row of data.

It cannot contain null values.