One of the module in the database management system which is responsible for choosing efficient execution plan considering queries is considered as

a$.$ Index and glossary optimization

b$.$ None of the above.

c$.$ Structural optimization

d$.$ Query processing and optimization

e$.$ Content optimization