16 - Define the terms. Keep it simple and short.
 
a) Indexes. Explain also the advantages / disadvantages of creating indexes for a table
 
b) INNER JOIN / LEFT JOIN / STRAIGHT JOIN . Please write the differences
 
c) Temporary tables. Name some differences between them and normal tables.
 
d) Composite index. Write also the advantages. Does the order of the components matter? 
 
e) Database normalization. Briefly describe the first 3 forms. 
 
f) What will the explain command do?
 
 
17 - Please explain: 
 
(5 points)
a) Differences between Master-Master replication and Master-Slave replication
 
b) What does sharding mean? (mysql context)
 
c) Write the sql commands used to:
-    Show the table structure
-    Display the list of tables from a database
-    Show the indexes from a table
 
d) Differences between row based and column based storage engines.
 
e) Differences between MyIsam and InnoDb.