why is encrypting the entire database and not providing the encryption$/$decryption keys to the service provider considered inflexible?

a$-$ It enhances data security significantly

b$-$ It provides more flexibility in working with the database

c$-$ It requires the user to download entire table for decryption.

d$-$ It allows the user to access individual data items based on searches.