Question

In a columnar database, the columns are stored together on disk, achieving a higher compression ratio is an expensive operation, a. true b. false

Answer 1

Molecular mass of H2O = 18g/mol

Numbers of molecules present in 18g of H2O =6.022×10^23 molecules

Numbers of molecules present in 0.9g of

H2O = 6.022×10^23×18×0.9 molecules

Numbers of atom in 1 molecule 3(2hydrogen and 1 oxygen)

Number of atoms in

6.022×10^23×18×0.9 molecules of

H2O =

6.022×10^23×0.9×3

= 9.03×10^22 atoms.

Hope this helps you ☺️☺️❤️❤️✌️✌️

Answer 2

In a columnar database, the columns are stored together on disk, achieving a higher compression ratio is an expensive operation, as the size of the database goes on becoming larger and larger as you keep on doing the entries.

This means that, the given statement is true. It also takes more time for processing queries.