IT Trainer Questions

Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key. 

Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key.

• One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization. For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain.

An IP address (internet protocol address) is a numerical representation that uniquely identifies a specific interface on the network. Addresses in IPv4 are 32-bits long. This allows for a maximum of 4,294,967,296 (2^32) unique addresses. Addresses in IPv6 are 128-bits, which allows for 3.4 x 1038 (2^128) unique addresses.

IP addresses available to the internet are classified as Public.

Materials that allow electricity to flow are called electrical conductors and that materials which does not allow electricity to flow are called Insulators.

Evaporation is the process that allows water to enter into the atmosphere.

Sunlight turns liquid water into water vapor which then rises higher into the atmosphere and forms into clouds.

Plants, too, help water get into the atmosphere through a process called transpiration.

In a brief, the system software is the interface between the hardware and user applications. System software is a type of computer program that is designed to run a computer’s hardware and application programs.

Examples : OS, System utilities, BIOS like mouse, keyboard, hard disc, Device drivers, Assembler,...

A metalloid is an element with properties between metals and non metals or the mix of both.

The six metalloids are arsenic, silicon, germanium, boron, antimony and tellurium.

Hence, silicon is the only metalloid in the given list.

DNA is a very long chain polymer made up of thousands of repeating units called nucleotides.

Nucleotide Unit is composed of a phosphate group, a pentose sugar, and a nitrogenous base.

The sides of the DNA ladder are made up of alternating deoxyribose sugar -- phosphate group units.

A Soap.

Yes, it gets shrinks smaller every time we take a bath.