IT Trainer Questions

Function: A Function is a block of statement which perform some operation.

Declaring the function before using the function in program is known as implicit declaration of the function.

For Example::

int bar(void); // function (forward) declaration

int main(void) {

bar(); // bar was declared, the compiler has all the info

return foo(123); // foo not yet known; impl. decl. warning

}

// not previously declared function definition

int foo(int a) {

return a;

} 

// previously declared function definition

int bar() {

return 321;

}

A network in which there are multiple network links between computers to provide multiple paths for data to travel.

Here the letter 'M' appears once in Minute and twice in a MoMent.

Blue Zone is the hottest part of the flame that is where the flame has the most Oxygen and you are getting complete combustion. It is about 1400 degrees Centigrades. The Reddish part (Non - Luminous Zone) is the coolest part, about 800 deg C.

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.

Inheritance is the ability to create new classes based on existing classes. It is useful to reuse existing code.

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 product of a number and its reciprocal is always equals to 1.

For Example : Let the number be 4.

Now, its reciprocal is 1/4

Hence, required product = 4 x 1/4 = 1.

Now, take the number as -15.

Then its reciprocal is -1/15

Required product = -15 x -1/15 = 1.

Hence, the product of a number and its reciprocal is 1.