Database Administration Questions

RAM storage capacity is measured in bytes, kilo bytes, mega bytes, giga bytes,...

It is a problem that can ruin TCP performance. This problem occurs when data are passed to the sending TCP entity in large blocks, but an interactive application on the receiving side reads 1 byte at a time.

Passive Voice : Has the work been completed by him?

Rules in changing from Active voice to Passive voice :

1. Identify the subject, the verb and the object: S+V+O

2. Change the object into subject

3. Put the suitable helping verb or auxiliary verb

4. Change the verb into past participle of the verb

5. Add the preposition "by"

6. Change the subject into object.

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.

The default return value from a function is int. In other words, unless explicitly specified the default return value by compiler would be integer value from function.

Light year is the unit of to express astronomical distances, that light can travel in one year. Light moves at a velocity of about 300,000 kilometers (km) each second. So in one year, it can travel about 10 trillion km. More precisely, one light-year is equal to 9,500,000,000,000 kilometers.

Approximately, 1 light year = 10^16 mts.

Tablespoon > Teaspoon

In US & UK, 1 Tablespoon = 3 Teaspoons.