1) Give brief and clear answers to the following:

d) Explain the main advantage(s) and disadvantage(s) of keeping the data file sorted.

(f) Explain why writes to a log disk might be faster than writes to the disk containing the database

(g) Since indexes speed up searches, explain why the DBMS does not automatically create an index for every column of a table