Question: a) Describe the process of query optimization with the help of an appropriate example.

b) What is the difference between built-in function and used defined function? Give any two examples of both.

(Advanced Database Systems Course)