Ask a Question
Advertise on boostr.in
Question:The ITEM table has six columns. Since the table is often queried with a join to the SALE table, an index was created on five of the columns in the ITEM table. What will be the result?
a. ¬†¬†¬†¬†¬†¬†¬†Inserts to the table will be slower
b. ¬†¬†¬†¬†¬†¬†¬†The size of the ITEM table will be increased
c. ¬†¬†¬†¬†¬†¬†¬†All queries on the ITEM table will be faster if it does not contain a large number of NULL values
d. ¬†¬†¬†¬†¬†¬†¬†The speed of deletes will be increased
Sep 13, 2013
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please