IT Trainer Questions

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.

The maximum number of characters allowed is 1024 characters.

A computer programming language is nothing but a language which is understand by the computer.

Examples of programming languages are Basic, C, Java, Python, ...

Kangaroo.

There are two IP address assigned to each device on a Wi-Fi network.

An Internal (Private) and an External (Public) IP address.

Internal IP address is used for communication between Your computer and a smartphone or whatever devices that are connected to that Wifi network. This is unique for each. If they are same the system cannot differentiate between each device.

While, the External IP address is that visible to the the internet - the websites, the internet connected Apps so on. By default, Routers with NAT (all routers today have it) assign same Public IP address to all devices under its network.

Resistivity :

Resistivity is a measure of the resistance to the flow of electrons. 

Conductivity :

Conductivity is just the inverse of resistivity, σ = 1/ρ, where σ is conductivity and ρ is resistivity.

Example:

Think of a pipe and water, the bigger the pipe, the easier water can flow and thus the lower the resistance. 

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.

For neutral atoms, the periodic trends in atomic size can be described like this

Atomic size decreases when going from left to right across a period,
Atomic size increases when going from top to bottom down a group.

Let's use these trends to try and figure out which atom would have the largest radius.

If you look at elements that are located in the same group, potassium will have a larger atomic radius when compared with sodium. Likewise, bromine will have a larger atomic radius when compared with chlorine.

Now focus on potassium and bromine. Since potassium is located at the start of period 3, and bromine at the end of the same period, potassium will have a larger atomic radius than bromine, and thus the largest atomic radius of the four given atoms.