Database Administration Questions

From the given data,

Manogna’s age be 0 when she was born.

Her father’s age = 38 years

Her mother’s age when Manogna’s brother who is 4 years younger to her was born = 36 years

=> Manogna’s mother age when Manogna was born = 36 - 4 = 32 years

Hence, the difference between the ages of Manogna’s parents = 38 - 32 = 6 years.

Disaccharides are formed when two monosaccharides join together by the dehydration synthesis reaction resulting in a glycosidic bond between the two monosaccharide molecules. The reaction produces water as a side product.

In SQL, BETWEEN Keyword is used for ranges like Number Ranges, Date Ranges, etc...

We can make an equation:

3(100000 + x) = 10x+1

(Why? Well, adding 100000 puts a 1 at the front of a five-digit number, and multiplying by 10 and adding 1 puts a 1 at the end of a number)

Solving this gives:

10x+1 = 3(100000 + x)
10x+1 = 300000 + 3x
10x = 299999 + 3x
7x = 299999
x = 299999/7 = 42857

The answer is 42857 (142857 is three times smaller than 428571).

An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.

In computing, memory refers to the computer hardware integrated circuits that store information for immediate use in a computer.

Most semiconductor memory is organized into memory cells or bistable flip-flops, each storing one bit (0 or 1).

A number of possible explanations for why manhole covers are round include :

1. A round manhole cover cannot fall through its circular opening, whereas a square, rectangular, or oval manhole cover could fall in if it were inserted diagonally in the hole.

2. Circular covers don’t need to be rotated or precisely aligned when placing them on the opening.

3. A round manhole cover is easily moved and rolled.

4. Human beings have a roughly circular cross-section.

5. Round tubes are the strongest shape against the compression of the earth around them, so the cover of the tube would naturally be round as well.

6. It’s easier to dig a circular hole.

Local :

Only available to the current Db connection for current user and are cleared when connection is closed.

Multiple users can’t share a local temporary table.

Global:

Available to any connection once created. They are cleared when the last connection is closed.

Can be shared by multiple user sessions