1.Describe conceptually how an SQL retrieval query will be executed by specifyin

1.Describe conceptually how an SQL
retrieval query will be executed by specifying the conceptual order of
executing each of the six clauses.2. Discuss the
various types of join operations (inner vs. outer) with a brief description of
where best to use them.3.Data is carried through networks by signals. A
signal is transmitted over a physical medium according to some transmission
technique(e. g. analog digital baseband modulatedmultiplexed
compressedspread spectrum). Physical media include metallic cables
optical fibers and the open air.
Discuss important issues in the evolution of transmission media as well as
transmission techniques in networks.